View: AMS_ACT_DELIVERABLES_V

Product:	AMS - Marketing
Description:	This view returns all marketing deliverables, including collaterals.
Implementation/DBA Data:	APPS.AMS_ACT_DELIVERABLES_V

View Text

SELECT OBJ.OBJECT_ASSOCIATION_ID
, OBJ.USAGE_TYPE
, LKUP1.MEANING
, OBJ.MASTER_OBJECT_ID
, OBJ.MASTER_OBJECT_TYPE
, LKUP2.MEANING
, OBJ.USING_OBJECT_ID
, OBJ.USING_OBJECT_TYPE
, LKUP3.MEANING
, DLV.DELIVERABLE_NAME
, DLV.CATEGORY_TYPE_ID
, DLV.DELIVERABLE_CATEGORY
, DLV.CATEGORY_SUB_TYPE_ID
, DLV.DELIVERABLE_SUB_CATEGORY
, OBJ.QUANTITY_NEEDED
, OBJ.QUANTITY_NEEDED_BY_DATE
, OBJ.FULFILL_ON_TYPE_CODE
, LKUP4.MEANING
, OBJ.PRIMARY_FLAG
, OBJ.OBJECT_VERSION_NUMBER
FROM AMS_OBJECT_ASSOCIATIONS OBJ
, AMS_P_DELIVERABLES_V DLV
, AMS_LOOKUPS LKUP1
, AMS_LOOKUPS LKUP2
, AMS_LOOKUPS LKUP3
, AMS_LOOKUPS LKUP4
WHERE OBJ.USING_OBJECT_TYPE='DELV'
AND OBJ.USING_OBJECT_ID=DLV.DELIVERABLE_ID
AND LKUP1.LOOKUP_TYPE(+)='AMS_OBJECT_USAGE_TYPE'
AND LKUP1.LOOKUP_CODE(+)= OBJ.USAGE_TYPE
AND LKUP2.LOOKUP_TYPE(+)='AMS_MASTER_OBJECT_TYPE'
AND LKUP2.LOOKUP_CODE(+)= OBJ.MASTER_OBJECT_TYPE
AND LKUP3.LOOKUP_TYPE(+)='AMS_USING_OBJECT_TYPE'
AND LKUP3.LOOKUP_CODE(+)= OBJ.USING_OBJECT_TYPE
AND LKUP4.LOOKUP_TYPE(+)='AMS_EVENT_FULFILL_ON'
AND LKUP4.LOOKUP_CODE(+)= OBJ.FULFILL_ON_TYPE_CODE

Columns