VIEW: APPS.AST_COLL_REVIEW_KITS_V

Source

View Text - Preformatted

SELECT b.deliverable_kit_part_id , b.deliverable_kit_id , d1.deliverable_name , b.deliverable_kit_item_id , d2.deliverable_name , NVL(c.transaction_quantity, 0) , i.segment1 , d2.can_fulfill_electronic_flag , d2.can_fulfill_physical_flag , i.primary_uom_code , i.organization_id FROM Mtl_onhand_quantities c , Mtl_system_items i , Ams_deliverables_vl d2 , Ams_deliv_kit_items b , Ams_deliverables_vl d1 WHERE c.inventory_item_id(+) = i.inventory_item_id AND c.organization_id(+) = i.organization_id AND i.inventory_item_id = d2.inventory_item_id AND d2.status_code = 'AVAILABLE' AND d2.deliverable_id = b.deliverable_kit_part_id AND b.deliverable_kit_id = d1.deliverable_id AND TRUNC(SYSDATE) BETWEEN trunc(NVL(d2.actual_avail_from_date, SYSDATE)) AND trunc(NVL(d2.actual_avail_to_date, SYSDATE))

View Text - HTML Formatted

SELECT B.DELIVERABLE_KIT_PART_ID
, B.DELIVERABLE_KIT_ID
, D1.DELIVERABLE_NAME
, B.DELIVERABLE_KIT_ITEM_ID
, D2.DELIVERABLE_NAME
, NVL(C.TRANSACTION_QUANTITY
, 0)
, I.SEGMENT1
, D2.CAN_FULFILL_ELECTRONIC_FLAG
, D2.CAN_FULFILL_PHYSICAL_FLAG
, I.PRIMARY_UOM_CODE
, I.ORGANIZATION_ID
FROM MTL_ONHAND_QUANTITIES C
, MTL_SYSTEM_ITEMS I
, AMS_DELIVERABLES_VL D2
, AMS_DELIV_KIT_ITEMS B
, AMS_DELIVERABLES_VL D1
WHERE C.INVENTORY_ITEM_ID(+) = I.INVENTORY_ITEM_ID
AND C.ORGANIZATION_ID(+) = I.ORGANIZATION_ID
AND I.INVENTORY_ITEM_ID = D2.INVENTORY_ITEM_ID
AND D2.STATUS_CODE = 'AVAILABLE'
AND D2.DELIVERABLE_ID = B.DELIVERABLE_KIT_PART_ID
AND B.DELIVERABLE_KIT_ID = D1.DELIVERABLE_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(D2.ACTUAL_AVAIL_FROM_DATE
, SYSDATE))
AND TRUNC(NVL(D2.ACTUAL_AVAIL_TO_DATE
, SYSDATE))