VIEW: APPS.CSI_CUSTOMER_PRODUCTS_RG_V

Source

View Text - Preformatted

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 NVL(CII.ACTIVE_END_DATE, (SYSDATE+1)) > SYSDATE 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 )

View Text - HTML Formatted

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 NVL(CII.ACTIVE_END_DATE
, (SYSDATE+1)) > SYSDATE
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 )