VIEW: APPS.CSI_INSTANCE_ACCTS_RG_V

Source

View Text - Preformatted

SELECT cii.instance_id customer_product_id, cii.instance_number reference_number, cii.serial_number current_serial_number, si.concatenated_segments product, si.description product_description, cii.quantity quantity, cii.unit_of_measure unit_of_measure_code, cia.party_account_id account_id, acc.account_number, cii.last_txn_line_detail_id line_inst_detail_id, cii.system_id, cii.last_oe_order_line_id original_order_line_id FROM MTL_SYSTEM_ITEMS_KFV SI, HZ_CUST_ACCOUNTS ACC, CSI_ITEM_INSTANCES CII, 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 CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER' AND CIP.INSTANCE_PARTY_ID = CIA.INSTANCE_PARTY_ID AND CIA.RELATIONSHIP_TYPE_CODE = 'OWNER' AND CIA.PARTY_ACCOUNT_ID = ACC.CUST_ACCOUNT_ID AND CII.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID AND SI.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID AND CIP.PARTY_ID NOT IN ( SELECT INTERNAL_PARTY_ID FROM CSI_INSTALL_PARAMETERS )

View Text - HTML Formatted

SELECT CII.INSTANCE_ID CUSTOMER_PRODUCT_ID
, CII.INSTANCE_NUMBER REFERENCE_NUMBER
, CII.SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, SI.CONCATENATED_SEGMENTS PRODUCT
, SI.DESCRIPTION PRODUCT_DESCRIPTION
, CII.QUANTITY QUANTITY
, CII.UNIT_OF_MEASURE UNIT_OF_MEASURE_CODE
, CIA.PARTY_ACCOUNT_ID ACCOUNT_ID
, ACC.ACCOUNT_NUMBER
, CII.LAST_TXN_LINE_DETAIL_ID LINE_INST_DETAIL_ID
, CII.SYSTEM_ID
, CII.LAST_OE_ORDER_LINE_ID ORIGINAL_ORDER_LINE_ID
FROM MTL_SYSTEM_ITEMS_KFV SI
, HZ_CUST_ACCOUNTS ACC
, CSI_ITEM_INSTANCES CII
, 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 CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER'
AND CIP.INSTANCE_PARTY_ID = CIA.INSTANCE_PARTY_ID
AND CIA.RELATIONSHIP_TYPE_CODE = 'OWNER'
AND CIA.PARTY_ACCOUNT_ID = ACC.CUST_ACCOUNT_ID
AND CII.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID
AND SI.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID
AND CIP.PARTY_ID NOT IN ( SELECT INTERNAL_PARTY_ID
FROM CSI_INSTALL_PARAMETERS )