VIEW: APPS.AMS_P_EVENT_DELIVERABLES_V

Source

View Text - Preformatted

SELECT a.rowid row_id, a.master_object_id, e.event_offer_name, e.description, a.using_object_id, d.deliverable_name, d.description, d.language_code, d.can_fulfill_electronic_flag, d.can_fulfill_physical_flag, d.deliverable_category, d.deliverable_sub_category, d.inventory_flag, d.inventory_item_id, d.inventory_item_org_id, d.kit_flag from ams_object_associations a, ams_event_offers_vl e, ams_p_deliverables_v d WHERE a.master_object_id=e.event_offer_id and a.using_object_id=d.deliverable_id

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.MASTER_OBJECT_ID
, E.EVENT_OFFER_NAME
, E.DESCRIPTION
, A.USING_OBJECT_ID
, D.DELIVERABLE_NAME
, D.DESCRIPTION
, D.LANGUAGE_CODE
, D.CAN_FULFILL_ELECTRONIC_FLAG
, D.CAN_FULFILL_PHYSICAL_FLAG
, D.DELIVERABLE_CATEGORY
, D.DELIVERABLE_SUB_CATEGORY
, D.INVENTORY_FLAG
, D.INVENTORY_ITEM_ID
, D.INVENTORY_ITEM_ORG_ID
, D.KIT_FLAG
FROM AMS_OBJECT_ASSOCIATIONS A
, AMS_EVENT_OFFERS_VL E
, AMS_P_DELIVERABLES_V D
WHERE A.MASTER_OBJECT_ID=E.EVENT_OFFER_ID
AND A.USING_OBJECT_ID=D.DELIVERABLE_ID