CMF_FD_LOC_INFO_INT_OTBI

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

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

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