VIEW: APPS.AMS_ACT_DELIVERABLES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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