Definition of View CSI_INST_INSTALL_LOCATION_V is Incorrect

(Doc ID 2348203.1)

Last updated on JANUARY 12, 2018

Applies to:

Oracle Installed Base - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 Currently definition of view  CSI_INST_INSTALL_LOCATION_V is

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;


In second union and third union, there are

SELECT CSII.INSTANCE_ID INSTANCE_ID
, CSII.LOCATION_ID INSTALL_LOCATION_ID

here CSII.LOCATION_ID should be CSII.INSTALL_LOCATION_ID like the first block

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms