VIEW: APPS.ECE_MVSTO_LOCATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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