View: CSI_CUSTOMER_PRODUCTS_RG_V

Product:	CSI - Install Base
Description:	Backward Compatible : Customer Products Record Groups.
Implementation/DBA Data:	APPS.CSI_CUSTOMER_PRODUCTS_RG_V

View Text

SELECT CII.INSTANCE_ID
, CII.INSTANCE_NUMBER
, CII.SERIAL_NUMBER
, MSIK.CONCATENATED_SEGMENTS
, MSIK.DESCRIPTION
, CII.QUANTITY
, CII.UNIT_OF_MEASURE
, CIA.PARTY_ACCOUNT_ID
, HCA.ACCOUNT_NUMBER
, NULL
, CII.SYSTEM_ID
, CII.LAST_OE_ORDER_LINE_ID
FROM CSI_ITEM_INSTANCES CII
, MTL_SYSTEM_ITEMS_KFV MSIK
, HZ_CUST_ACCOUNTS HCA
, CSI_I_PARTIES CIP
, CSI_IP_ACCOUNTS CIA
WHERE CII.INSTANCE_ID = CIP.INSTANCE_ID(+) AND CIA.PARTY_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID AND CII.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID AND MSIK.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER' AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND CIP.INSTANCE_PARTY_ID = CIA.INSTANCE_PARTY_ID (+) AND CIA.ACTIVE_END_DATE (+) IS NULL AND CIA.RELATIONSHIP_TYPE_CODE(+) = 'OWNER'
AND NOT EXISTS ( SELECT 1 FROM CSI_INSTALL_PARAMETERS CIPM WHERE CIPM.INTERNAL_PARTY_ID = CIP.PARTY_ID )

Columns