View: CSI_INST_INSTALL_LOCATION_V

Product:	CSI - Install Base
Description:	Internal View : View to resolve the Install_location_id to the respective foreign key tables and bring the Address.
Implementation/DBA Data:	APPS.CSI_INST_INSTALL_LOCATION_V

View Text

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

Columns