View: ECE_MVSTO_LOCATIONS_V

Product:	EC - e-Commerce Gateway
Description:	This view extracts line location informationfor the outbound Movement Statistics (INTRASTAT) transaction.@rep:scope private@rep:product INV@rep:lifecycle active@rep:displayname Movement Statistics Line Location View@rep:category BUSINESS_EN
Implementation/DBA Data:	APPS.ECE_MVSTO_LOCATIONS_V

View Text

SELECT PT1.ORIG_SYSTEM_REFERENCE BILL_TO_CODE_INTERNAL
, CAS1.ECE_TP_LOCATION_CODE BILL_TO_CODE_EXTERNAL
, PT1.PARTY_NAME BILL_TO_NAME
, LC1.ADDRESS1 BILL_TO_ADDRESS1
, LC1.ADDRESS2 BILL_TO_ADDRESS2
, LC1.ADDRESS3 BILL_TO_ADDRESS3
, LC1.ADDRESS4 BILL_TO_ADDRESS4
, LC1.CITY BILL_TO_CITY
, LC1.POSTAL_CODE BILL_TO_POSTAL_CODE
, LC1.COUNTRY BILL_TO_COUNTRY
, LC1.STATE BILL_TO_STATE
, LC1.PROVINCE BILL_TO_PROVINCE
, LC1.COUNTY BILL_TO_COUNTY
, LC1.LOCATION_ID BILL_TO_ADDRESS_ID
, CAS1.CUST_ACCOUNT_ID BILL_TO_CUSTOMER_ID
, CSU1.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, PT2.ORIG_SYSTEM_REFERENCE SHIP_TO_CODE_INTERNAL
, CAS2.ECE_TP_LOCATION_CODE SHIP_TO_CODE_EXTERNAL
, PT2.PARTY_NAME SHIP_TO_NAME
, LC2.ADDRESS1 SHIP_TO_ADDRESS1
, LC2.ADDRESS2 SHIP_TO_ADDRESS2
, LC2.ADDRESS3 SHIP_TO_ADDRESS3
, LC2.ADDRESS4 SHIP_TO_ADDRESS4
, LC2.CITY SHIP_TO_CITY
, LC2.POSTAL_CODE SHIP_TO_POSTAL_CODE
, LC2.COUNTRY SHIP_TO_COUNTRY
, LC2.STATE SHIP_TO_STATE
, LC2.PROVINCE SHIP_TO_PROVINCE
, LC2.COUNTY SHIP_TO_COUNTY
, LC2.LOCATION_ID SHIP_TO_ADDRESS_ID
, CAS2.CUST_ACCOUNT_ID SHIP_TO_CUSTOMER_ID
, CSU2.SITE_USE_ID SHIP_TO_SITE_USE_ID
, PVS.VENDOR_SITE_ID VENDOR_CODE_INT
, PVS.ECE_TP_LOCATION_CODE VENDOR_CODE_EXT
, PV.VENDOR_NAME VENDOR_CUSTOMER_NAME
, PVS.ADDRESS_LINE1 VENDOR_ADDRESS1
, PVS.ADDRESS_LINE2 VENDOR_ADDRESS2
, PVS.ADDRESS_LINE3 VENDOR_ADDRESS3
, PVS.ADDRESS_LINE4 VENDOR_ADDRESS4
, PVS.CITY VENDOR_CITY
, PVS.ZIP VENDOR_POSTAL_CODE
, PVS.COUNTRY VENDOR_COUNTRY_INT
, PVS.ZIP VENDOR_TO_POSTAL_CODE
, PVS.STATE VENDOR_STATE_INT
, PVS.PROVINCE VENDOR_PROVINCE_INT
, PVS.COUNTY VENDOR_COUNTY
, NULL TRANSACTION_HEADER_ID
, NULL TRANSACTION_LINE_ID
FROM HZ_PARTIES PT1
, HZ_CUST_ACCOUNTS CA1
, HZ_CUST_ACCT_SITES_ALL CAS1
, HZ_PARTY_SITES PS1
, HZ_LOCATIONS LC1
, HZ_CUST_SITE_USES_ALL CSU1
, HZ_PARTIES PT2
, HZ_CUST_ACCOUNTS CA2
, HZ_CUST_ACCT_SITES_ALL CAS2
, HZ_PARTY_SITES PS2
, HZ_LOCATIONS LC2
, HZ_CUST_SITE_USES_ALL CSU2
, PO_VENDOR_SITES PVS
, PO_VENDORS PV
WHERE PT1.PARTY_ID = CA1.PARTY_ID
AND CA1.CUST_ACCOUNT_ID = CAS1.CUST_ACCOUNT_ID
AND CAS1.CUST_ACCT_SITE_ID = CSU1.CUST_ACCT_SITE_ID
AND PT1.PARTY_ID = PS1.PARTY_ID
AND PS1.LOCATION_ID = LC1.LOCATION_ID
AND PT2.PARTY_ID = CA2.PARTY_ID
AND CA2.CUST_ACCOUNT_ID = CAS2.CUST_ACCOUNT_ID
AND CAS2.CUST_ACCT_SITE_ID = CSU2.CUST_ACCT_SITE_ID
AND PT2.PARTY_ID = PS2.PARTY_ID
AND PS2.LOCATION_ID = LC2.LOCATION_ID
AND PV.VENDOR_ID = PVS.VENDOR_ID

Columns