Product: | AMS - Marketing |
---|---|
Description: | This public view returns the collateral items associated to collateral kits. |
Implementation/DBA Data: | APPS.AMS_P_DELIV_KIT_ITEMS_V |
SELECT B.ROWID ROW_ID
, B.DELIVERABLE_KIT_ITEM_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.DELIVERABLE_KIT_ID
, D1.DELIVERABLE_NAME
, B.DELIVERABLE_KIT_PART_ID
, D2.DELIVERABLE_NAME
, B.QUANTITY
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
FROM AMS_DELIV_KIT_ITEMS B
, AMS_DELIVERABLES_VL D1
, AMS_DELIVERABLES_VL D2
WHERE B.DELIVERABLE_KIT_ID = D1.DELIVERABLE_ID AND B.DELIVERABLE_KIT_PART_ID = D2.DELIVERABLE_ID