CMF_FD_LOC_INFO_INT_OTBI_V
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: VIEW
Columns
Name |
---|
FD_HEADERS_INT_ID DOCUMENT_HEADER_ID DOCUMENT_NUMBER FISCAL_PROC_OPTIONS_ID ISSUER_TYPE ISSUER_SUPPLIER_TAX_ID ISSUER_CUSTOMER_TAX_ID ISSUER_LE_TAX_ID ISSUER_SUPPLIER_TAXPAYER_ID ISSUER_CUSTOMER_TAXPAYER_ID ISSUER_LE_TAXPAYER_ID ISSUER_SUPPLIER_FORM_TAX_NUM ISSUER_CUSTOMER_FORM_TAX_NUM ISSUER_LE_FORM_TAX_NUMBER ISSUER_SUPPLIER_PARTY_ID ISSUER_CUSTOMER_PARTY_ID ISSUER_LE_ID ISSUER_SUPPLIER_PARTY_SITE_ID ISSUER_CUSTOMER_PARTY_SITE_ID ISSUER_LE_SITE_ID ISSUER_SUPPLIER_LOCATION_ID ISSUER_CUSTOMER_LOCATION_ID ISSUER_LE_LOCATION_ID RECEIVER_TYPE RECEIVER_SUPPLIER_TAX_ID RECEIVER_CUSTOMER_TAX_ID RECEIVER_LE_TAX_ID RECEIVER_SUPPLIER_TAXPAYER_ID RECEIVER_CUSTOMER_TAXPAYER_ID RECEIVER_LE_TAXPAYER_ID RECEIVER_SUPPLIER_FORM_TAX_NUM RECEIVER_CUSTOMER_FORM_TAX_NUM RECEIVER_LE_FORM_TAX_NUMBER RECEIVER_SUPPLIER_PARTY_ID RECEIVER_CUSTOMER_PARTY_ID RECEIVER_LE_PARTY_ID RECEIVER_SUPP_PARTY_SITE_ID RECEIVER_CUST_PARTY_SITE_ID RECEIVER_LE_PARTY_SITE_ID RECEIVER_SUPPLIER_LOCATION_ID RECEIVER_CUSTOMER_LOCATION_ID RECEIVER_LE_LOCATION_ID SHIPFROM_TYPE SHIPFROM_SUPPLIER_TAX_ID SHIPFROM_CUSTOMER_TAX_ID SHIPFROM_LE_TAX_ID SHIPFROM_SUPPLIER_TAXPAYER_ID SHIPFROM_CUSTOMER_TAXPAYER_ID SHIPFROM_LE_TAXPAYER_ID SHIPFROM_SUPPLIER_FORM_TAX_NUM SHIPFROM_CUSTOMER_FORM_TAX_NUM SHIPFROM_LE_FORM_TAX_NUMBER SHIPFROM_SUPPLIER_PARTY_ID SHIPFROM_CUSTOMER_PARTY_ID SHIPFROM_LE_PARTY_ID SHIPFROM_SUPP_PARTY_SITE_ID SHIPFROM_CUST_PARTY_SITE_ID SHIPFROM_LE_PARTY_SITE_ID SHIPFROM_SUPPLIER_LOCATION_ID SHIPFROM_CUSTOMER_LOCATION_ID SHIPFROM_LE_LOCATION_ID SHIPTO_TYPE SHIPTO_SUPPLIER_TAX_ID SHIPTO_CUSTOMER_TAX_ID SHIPTO_LE_TAX_ID SHIPTO_SUPPLIER_TAXPAYER_ID SHIPTO_CUSTOMER_TAXPAYER_ID SHIPTO_LE_TAXPAYER_ID SHIPTO_SUPPLIER_FORM_TAX_NUM SHIPTO_CUSTOMER_FORM_TAX_NUM SHIPTO_LE_FORM_TAX_NUMBER SHIPTO_SUPPLIER_PARTY_ID SHIPTO_CUSTOMER_PARTY_ID SHIPTO_LE_PARTY_ID SHIPTO_SUPP_PARTY_SITE_ID SHIPTO_CUST_PARTY_SITE_ID SHIPTO_LE_PARTY_SITE_ID SHIPTO_SUPPLIER_LOCATION_ID SHIPTO_CUSTOMER_LOCATION_ID SHIPTO_LE_LOCATION_ID |
Query
SQL_Statement |
---|
SELECT FDH.FD_HEADERS_INT_ID ,FDH.DOCUMENT_HEADER_ID ,FDH.DOCUMENT_NUMBER ,FDH.FISCAL_PROC_OPTIONS_ID ,FDP.ISSUER_TYPE ,DECODE(FDP.ISSUER_TYPE,'SUPPLIER',ISSUER.PARTY_TAXPAYER_IDNTFS_ID,NULL) ISSUER_SUPPLIER_TAX_ID ,DECODE(FDP.ISSUER_TYPE,'CUSTOMER',ISSUER.PARTY_TAXPAYER_IDNTFS_ID,NULL) ISSUER_CUSTOMER_TAX_ID ,DECODE(FDP.ISSUER_TYPE,'LE',LEISSUER.REGISTRATION_ID,NULL) ISSUER_LE_TAX_ID ,DECODE(FDP.ISSUER_TYPE,'SUPPLIER',ISSUER.TAXPAYER_ID,NULL) ISSUER_SUPPLIER_TAXPAYER_ID ,DECODE(FDP.ISSUER_TYPE,'CUSTOMER',ISSUER.TAXPAYER_ID,NULL) ISSUER_CUSTOMER_TAXPAYER_ID ,DECODE(FDP.ISSUER_TYPE,'LE',LEISSUER.TAXPAYER_ID,NULL) ISSUER_LE_TAXPAYER_ID ,DECODE(FDP.ISSUER_TYPE,'SUPPLIER',ISSUER.FORMATTED_TAXPAYER_NUMBER,NULL) ISSUER_SUPPLIER_FORM_TAX_NUM ,DECODE(FDP.ISSUER_TYPE,'CUSTOMER',ISSUER.FORMATTED_TAXPAYER_NUMBER,NULL) ISSUER_CUSTOMER_FORM_TAX_NUM ,DECODE(FDP.ISSUER_TYPE,'LE',LEISSUER.FORMATTED_TAXPAYER_NUMBER,NULL) ISSUER_LE_FORM_TAX_NUMBER ,DECODE(FDP.ISSUER_TYPE,'SUPPLIER',ISSUER.PARTY_ID,NULL) ISSUER_SUPPLIER_PARTY_ID ,DECODE(FDP.ISSUER_TYPE,'CUSTOMER',ISSUER.PARTY_ID,NULL) ISSUER_CUSTOMER_PARTY_ID ,DECODE(FDP.ISSUER_TYPE,'LE',LEISSUER.LEGAL_ENTITY_ID,NULL) ISSUER_LE_ID ,DECODE(FDP.ISSUER_TYPE,'SUPPLIER',ISSUER.PARTY_SITE_ID,NULL) ISSUER_SUPPLIER_PARTY_SITE_ID ,DECODE(FDP.ISSUER_TYPE,'CUSTOMER',ISSUER.PARTY_SITE_ID,NULL) ISSUER_CUSTOMER_PARTY_SITE_ID ,DECODE(FDP.ISSUER_TYPE,'LE',LEISSUER.ESTABLISHMENT_ID,NULL) ISSUER_LE_SITE_ID ,DECODE(FDP.ISSUER_TYPE,'SUPPLIER',ISSUER.LOCATION_ID,NULL) ISSUER_SUPPLIER_LOCATION_ID ,DECODE(FDP.ISSUER_TYPE,'CUSTOMER',ISSUER.LOCATION_ID,NULL) ISSUER_CUSTOMER_LOCATION_ID ,DECODE(FDP.ISSUER_TYPE,'LE',LEISSUER.LOCATION_ID,NULL) ISSUER_LE_LOCATION_ID ,FDP.RECEIVER_TYPE ,DECODE(FDP.RECEIVER_TYPE,'SUPPLIER',RECEIVER.PARTY_TAXPAYER_IDNTFS_ID,NULL) RECEIVER_SUPPLIER_TAX_ID ,DECODE(FDP.RECEIVER_TYPE,'CUSTOMER',RECEIVER.PARTY_TAXPAYER_IDNTFS_ID,NULL) RECEIVER_CUSTOMER_TAX_ID ,DECODE(FDP.RECEIVER_TYPE,'LE',LERECEIVER.REGISTRATION_ID,NULL) RECEIVER_LE_TAX_ID ,DECODE(FDP.RECEIVER_TYPE,'SUPPLIER',RECEIVER.TAXPAYER_ID,NULL) RECEIVER_SUPPLIER_TAXPAYER_ID ,DECODE(FDP.RECEIVER_TYPE,'CUSTOMER',RECEIVER.TAXPAYER_ID,NULL) RECEIVER_CUSTOMER_TAXPAYER_ID ,DECODE(FDP.RECEIVER_TYPE,'LE',LERECEIVER.TAXPAYER_ID,NULL) RECEIVER_LE_TAXPAYER_ID ,DECODE(FDP.RECEIVER_TYPE,'SUPPLIER',RECEIVER.FORMATTED_TAXPAYER_NUMBER,NULL) RECEIVER_SUPPLIER_FORM_TAX_NUM ,DECODE(FDP.RECEIVER_TYPE,'CUSTOMER',RECEIVER.FORMATTED_TAXPAYER_NUMBER,NULL) RECEIVER_CUSTOMER_FORM_TAX_NUM ,DECODE(FDP.RECEIVER_TYPE,'LE',LERECEIVER.FORMATTED_TAXPAYER_NUMBER,NULL) RECEIVER_LE_FORM_TAX_NUMBER ,DECODE(FDP.RECEIVER_TYPE,'SUPPLIER',RECEIVER.PARTY_ID,NULL) RECEIVER_SUPPLIER_PARTY_ID ,DECODE(FDP.RECEIVER_TYPE,'CUSTOMER',RECEIVER.PARTY_ID,NULL) RECEIVER_CUSTOMER_PARTY_ID ,DECODE(FDP.RECEIVER_TYPE,'LE',LERECEIVER.LEGAL_ENTITY_ID,NULL) RECEIVER_LE_PARTY_ID ,DECODE(FDP.RECEIVER_TYPE,'SUPPLIER',RECEIVER.PARTY_SITE_ID,NULL) RECEIVER_SUPP_PARTY_SITE_ID ,DECODE(FDP.RECEIVER_TYPE,'CUSTOMER',RECEIVER.PARTY_SITE_ID,NULL) RECEIVER_CUST_PARTY_SITE_ID ,DECODE(FDP.RECEIVER_TYPE,'LE',LERECEIVER.ESTABLISHMENT_ID,NULL) RECEIVER_LE_PARTY_SITE_ID ,DECODE(FDP.RECEIVER_TYPE,'SUPPLIER',RECEIVER.LOCATION_ID,NULL) RECEIVER_SUPPLIER_LOCATION_ID ,DECODE(FDP.RECEIVER_TYPE,'CUSTOMER',RECEIVER.LOCATION_ID,NULL) RECEIVER_CUSTOMER_LOCATION_ID ,DECODE(FDP.RECEIVER_TYPE,'LE',LERECEIVER.LOCATION_ID,NULL) RECEIVER_LE_LOCATION_ID ,FDP.SHIP_FROM_TYPE SHIPFROM_TYPE ,DECODE(FDP.SHIP_FROM_TYPE,'SUPPLIER',SHIPFROM.PARTY_TAXPAYER_IDNTFS_ID,NULL) SHIPFROM_SUPPLIER_TAX_ID ,DECODE(FDP.SHIP_FROM_TYPE,'CUSTOMER',SHIPFROM.PARTY_TAXPAYER_IDNTFS_ID,NULL) SHIPFROM_CUSTOMER_TAX_ID ,DECODE(FDP.SHIP_FROM_TYPE,'LE',LESHIPFROM.REGISTRATION_ID,NULL) SHIPFROM_LE_TAX_ID ,DECODE(FDP.SHIP_FROM_TYPE,'SUPPLIER',SHIPFROM.TAXPAYER_ID,NULL) SHIPFROM_SUPPLIER_TAXPAYER_ID ,DECODE(FDP.SHIP_FROM_TYPE,'CUSTOMER',SHIPFROM.TAXPAYER_ID,NULL) SHIPFROM_CUSTOMER_TAXPAYER_ID ,DECODE(FDP.SHIP_FROM_TYPE,'LE',LESHIPFROM.TAXPAYER_ID,NULL) SHIPFROM_LE_TAXPAYER_ID ,DECODE(FDP.SHIP_FROM_TYPE,'SUPPLIER',SHIPFROM.FORMATTED_TAXPAYER_NUMBER,NULL) SHIPFROM_SUPPLIER_FORM_TAX_NUM ,DECODE(FDP.SHIP_FROM_TYPE,'CUSTOMER',SHIPFROM.FORMATTED_TAXPAYER_NUMBER,NULL) SHIPFROM_CUSTOMER_FORM_TAX_NUM ,DECODE(FDP.SHIP_FROM_TYPE,'LE',LESHIPFROM.FORMATTED_TAXPAYER_NUMBER,NULL) SHIPFROM_LE_FORM_TAX_NUMBER ,DECODE(FDP.SHIP_FROM_TYPE,'SUPPLIER',SHIPFROM.PARTY_ID,NULL) SHIPFROM_SUPPLIER_PARTY_ID ,DECODE(FDP.SHIP_FROM_TYPE,'CUSTOMER',SHIPFROM.PARTY_ID,NULL) SHIPFROM_CUSTOMER_PARTY_ID ,DECODE(FDP.SHIP_FROM_TYPE,'LE',LESHIPFROM.LEGAL_ENTITY_ID,NULL) SHIPFROM_LE_PARTY_ID ,DECODE(FDP.SHIP_FROM_TYPE,'SUPPLIER',SHIPFROM.PARTY_SITE_ID,NULL) SHIPFROM_SUPP_PARTY_SITE_ID ,DECODE(FDP.SHIP_FROM_TYPE,'CUSTOMER',SHIPFROM.PARTY_SITE_ID,NULL) SHIPFROM_CUST_PARTY_SITE_ID ,DECODE(FDP.SHIP_FROM_TYPE,'LE',LESHIPFROM.ESTABLISHMENT_ID,NULL) SHIPFROM_LE_PARTY_SITE_ID ,DECODE(FDP.SHIP_FROM_TYPE,'SUPPLIER',SHIPFROM.LOCATION_ID,NULL) SHIPFROM_SUPPLIER_LOCATION_ID ,DECODE(FDP.SHIP_FROM_TYPE,'CUSTOMER',SHIPFROM.LOCATION_ID,NULL) SHIPFROM_CUSTOMER_LOCATION_ID ,DECODE(FDP.SHIP_FROM_TYPE,'LE',LESHIPFROM.LOCATION_ID,NULL) SHIPFROM_LE_LOCATION_ID ,FDP.SHIP_TO_TYPE SHIPTO_TYPE ,DECODE(FDP.SHIP_TO_TYPE,'SUPPLIER',SHIPTO.PARTY_TAXPAYER_IDNTFS_ID,NULL) SHIPTO_SUPPLIER_TAX_ID ,DECODE(FDP.SHIP_TO_TYPE,'CUSTOMER',SHIPTO.PARTY_TAXPAYER_IDNTFS_ID,NULL) SHIPTO_CUSTOMER_TAX_ID ,DECODE(FDP.SHIP_TO_TYPE,'LE',LESHIPTO.REGISTRATION_ID,NULL) SHIPTO_LE_TAX_ID ,DECODE(FDP.SHIP_TO_TYPE,'SUPPLIER',SHIPTO.TAXPAYER_ID,NULL) SHIPTO_SUPPLIER_TAXPAYER_ID ,DECODE(FDP.SHIP_TO_TYPE,'CUSTOMER',SHIPTO.TAXPAYER_ID,NULL) SHIPTO_CUSTOMER_TAXPAYER_ID ,DECODE(FDP.SHIP_TO_TYPE,'LE',LESHIPTO.TAXPAYER_ID,NULL) SHIPTO_LE_TAXPAYER_ID ,DECODE(FDP.SHIP_TO_TYPE,'SUPPLIER',SHIPTO.FORMATTED_TAXPAYER_NUMBER,NULL) SHIPTO_SUPPLIER_FORM_TAX_NUM ,DECODE(FDP.SHIP_TO_TYPE,'CUSTOMER',SHIPTO.FORMATTED_TAXPAYER_NUMBER,NULL) SHIPTO_CUSTOMER_FORM_TAX_NUM ,DECODE(FDP.SHIP_TO_TYPE,'LE',LESHIPTO.FORMATTED_TAXPAYER_NUMBER,NULL) SHIPTO_LE_FORM_TAX_NUMBER ,DECODE(FDP.SHIP_TO_TYPE,'SUPPLIER',SHIPTO.PARTY_ID,NULL) SHIPTO_SUPPLIER_PARTY_ID ,DECODE(FDP.SHIP_TO_TYPE,'CUSTOMER',SHIPTO.PARTY_ID,NULL) SHIPTO_CUSTOMER_PARTY_ID ,DECODE(FDP.SHIP_TO_TYPE,'LE',LESHIPTO.LEGAL_ENTITY_ID,NULL) SHIPTO_LE_PARTY_ID ,DECODE(FDP.SHIP_TO_TYPE,'SUPPLIER',SHIPTO.PARTY_SITE_ID,NULL) SHIPTO_SUPP_PARTY_SITE_ID ,DECODE(FDP.SHIP_TO_TYPE,'CUSTOMER',SHIPTO.PARTY_SITE_ID,NULL) SHIPTO_CUST_PARTY_SITE_ID ,DECODE(FDP.SHIP_TO_TYPE,'LE',LESHIPTO.ESTABLISHMENT_ID,NULL) SHIPTO_LE_PARTY_SITE_ID ,DECODE(FDP.SHIP_TO_TYPE,'SUPPLIER',SHIPTO.LOCATION_ID,NULL) SHIPTO_SUPPLIER_LOCATION_ID ,DECODE(FDP.SHIP_TO_TYPE,'CUSTOMER',SHIPTO.LOCATION_ID,NULL) SHIPTO_CUSTOMER_LOCATION_ID ,DECODE(FDP.SHIP_TO_TYPE,'LE',LESHIPTO.LOCATION_ID,NULL) SHIPTO_LE_LOCATION_ID FROM CMF_PARTY_TAXPAYER_INFO_V ISSUER ,CMF_LELRU_TAXPAYER_INFO_V LEISSUER ,CMF_PARTY_TAXPAYER_INFO_V RECEIVER ,CMF_LELRU_TAXPAYER_INFO_V LERECEIVER ,CMF_PARTY_TAXPAYER_INFO_V SHIPFROM ,CMF_LELRU_TAXPAYER_INFO_V LESHIPFROM ,CMF_PARTY_TAXPAYER_INFO_V SHIPTO ,CMF_LELRU_TAXPAYER_INFO_V LESHIPTO ,CMF_FISCAL_PROC_OPTIONS FDP ,CMF_FD_HEADERS_INT FDH WHERE ISSUER.PARTY_TAXPAYER_IDNTFS_ID(+) = FDH.ISSUER_TAX_ID AND LEISSUER.REGISTRATION_ID(+) = FDH.ISSUER_TAX_ID AND RECEIVER.PARTY_TAXPAYER_IDNTFS_ID(+) = FDH.RECEIVER_TAX_ID AND LERECEIVER.REGISTRATION_ID(+) = FDH.RECEIVER_TAX_ID AND SHIPFROM.PARTY_TAXPAYER_IDNTFS_ID(+) = FDH.SHIPFROM_TAX_ID AND LESHIPFROM.REGISTRATION_ID(+) = FDH.SHIPFROM_TAX_ID AND SHIPTO.PARTY_TAXPAYER_IDNTFS_ID(+) = FDH.SHIPTO_TAX_ID AND LESHIPTO.REGISTRATION_ID(+) = FDH.SHIPTO_TAX_ID AND FDP.FISCAL_PROC_OPTIONS_ID = FDH.FISCAL_PROC_OPTIONS_ID |