View: AMS_PARTY_INSTANCE_V

Product:	AMS - Marketing
Description:	Data source view for install base
Implementation/DBA Data:	APPS.AMS_PARTY_INSTANCE_V

View Text

SELECT CII.INSTANCE_ID
, CII.INSTANCE_NUMBER
, CII.INVENTORY_ITEM_ID
, CII.INV_MASTER_ORGANIZATION_ID
, CII.SERIAL_NUMBER
, CII.QUANTITY
, CII.UNIT_OF_MEASURE
, CII.INSTANCE_TYPE_CODE
, CII.ACTIVE_START_DATE
, CII.ACTIVE_END_DATE
, CII.PO_ORDER_LINE_ID
, CII.INSTALL_DATE
, CIP.PARTY_ID
FROM CSI_ITEM_INSTANCES CII
, CSI_I_PARTIES CIP
, HZ_PARTIES PARTIES
WHERE CII.INSTANCE_ID = CIP.INSTANCE_ID
AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
AND CIP.PARTY_ID = PARTIES.PARTY_ID
AND CII.LAST_UPDATE_DATE IN (SELECT MAX(CII_2.LAST_UPDATE_DATE)
FROM CSI_ITEM_INSTANCES CII_2
, CSI_I_PARTIES CIP_2
WHERE CII_2.INSTANCE_ID = CIP_2.INSTANCE_ID
AND CIP_2.PARTY_ID = CIP.PARTY_ID )

Columns