View: CSI_INSTANCE_ACCTS_RG_V

Product:	CSI - Install Base
Description:	Instance and Party Accounts view for record groups.
Implementation/DBA Data:	APPS.CSI_INSTANCE_ACCTS_RG_V

View Text

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 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 )

Columns