VIEW: APPS.CSI_INST_INSTALL_LOCATION_V

Source

View Text - Preformatted

SELECT CSII.INSTANCE_ID INSTANCE_ID, CSII.INSTALL_LOCATION_ID INSTALL_LOCATION_ID, CSII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE, NULL PARTY_NAME, NULL PARTY_NUMBER, HZL.ADDRESS1 ADDRESS1, HZL.ADDRESS2 ADDRESS2, HZL.ADDRESS3 ADDRESS3, HZL.ADDRESS4 ADDRESS4, HZL.CITY CITY, HZL.STATE STATE, HZL.POSTAL_CODE POSTAL_CODE, HZL.COUNTRY COUNTRY, NULL PARTY_SITE_NUMBER FROM CSI_ITEM_INSTANCES CSII, HZ_LOCATIONS HZL WHERE CSII.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS' AND CSII.INSTALL_LOCATION_ID = HZL.LOCATION_ID UNION ALL SELECT CSII.INSTANCE_ID INSTANCE_ID, CSII.LOCATION_ID INSTALL_LOCATION_ID, CSII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE, CHA.PARTY_NAME PARTY_NAME, CHA.PARTY_NUMBER PARTY_NUMBER, CHA.ADDRESS1 ADDRESS1, CHA.ADDRESS2 ADDRESS2, CHA.ADDRESS3 ADDRESS3, CHA.ADDRESS4 ADDRESS4, CHA.CITY CITY, CHA.STATE STATE, CHA.ZIP POSTAL_CODE, CHA.COUNTRY COUNTRY, CHA.PARTY_SITE_NUMBER PARTY_SITE_NUMBER FROM CSI_ITEM_INSTANCES CSII, CSI_HZPTY_ADDRESSES_V CHA WHERE CSII.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES' AND CSII.INSTALL_LOCATION_ID = CHA.LOCATION UNION ALL SELECT CSII.INSTANCE_ID INSTANCE_ID, CSII.LOCATION_ID INSTALL_LOCATION_ID, CSII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE, NULL PARTY_NAME, NULL PARTY_NUMBER, VS.ADDRESS_LINE1 ADDRESS1, VS.ADDRESS_LINE2 ADDRESS2, VS.ADDRESS_LINE3 ADDRESS3, NULL ADDRESS4, VS.CITY CITY, VS.STATE STATE, VS.ZIP POSTAL_CODE, VS.COUNTRY COUNTRY, NULL PARTY_SITE_NUMBER FROM CSI_ITEM_INSTANCES CSII, PO_VENDOR_SITES_ALL VS WHERE CSII.INSTALL_LOCATION_TYPE_CODE = 'VENDOR_SITE' AND CSII.INSTALL_LOCATION_ID = VS.VENDOR_SITE_ID

View Text - HTML Formatted

SELECT CSII.INSTANCE_ID INSTANCE_ID
, CSII.INSTALL_LOCATION_ID INSTALL_LOCATION_ID
, CSII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE
, NULL PARTY_NAME
, NULL PARTY_NUMBER
, HZL.ADDRESS1 ADDRESS1
, HZL.ADDRESS2 ADDRESS2
, HZL.ADDRESS3 ADDRESS3
, HZL.ADDRESS4 ADDRESS4
, HZL.CITY CITY
, HZL.STATE STATE
, HZL.POSTAL_CODE POSTAL_CODE
, HZL.COUNTRY COUNTRY
, NULL PARTY_SITE_NUMBER
FROM CSI_ITEM_INSTANCES CSII
, HZ_LOCATIONS HZL
WHERE CSII.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS'
AND CSII.INSTALL_LOCATION_ID = HZL.LOCATION_ID UNION ALL SELECT CSII.INSTANCE_ID INSTANCE_ID
, CSII.LOCATION_ID INSTALL_LOCATION_ID
, CSII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE
, CHA.PARTY_NAME PARTY_NAME
, CHA.PARTY_NUMBER PARTY_NUMBER
, CHA.ADDRESS1 ADDRESS1
, CHA.ADDRESS2 ADDRESS2
, CHA.ADDRESS3 ADDRESS3
, CHA.ADDRESS4 ADDRESS4
, CHA.CITY CITY
, CHA.STATE STATE
, CHA.ZIP POSTAL_CODE
, CHA.COUNTRY COUNTRY
, CHA.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
FROM CSI_ITEM_INSTANCES CSII
, CSI_HZPTY_ADDRESSES_V CHA
WHERE CSII.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES'
AND CSII.INSTALL_LOCATION_ID = CHA.LOCATION UNION ALL SELECT CSII.INSTANCE_ID INSTANCE_ID
, CSII.LOCATION_ID INSTALL_LOCATION_ID
, CSII.INSTALL_LOCATION_TYPE_CODE INSTALL_LOCATION_TYPE_CODE
, NULL PARTY_NAME
, NULL PARTY_NUMBER
, VS.ADDRESS_LINE1 ADDRESS1
, VS.ADDRESS_LINE2 ADDRESS2
, VS.ADDRESS_LINE3 ADDRESS3
, NULL ADDRESS4
, VS.CITY CITY
, VS.STATE STATE
, VS.ZIP POSTAL_CODE
, VS.COUNTRY COUNTRY
, NULL PARTY_SITE_NUMBER
FROM CSI_ITEM_INSTANCES CSII
, PO_VENDOR_SITES_ALL VS
WHERE CSII.INSTALL_LOCATION_TYPE_CODE = 'VENDOR_SITE'
AND CSII.INSTALL_LOCATION_ID = VS.VENDOR_SITE_ID