View: AST_COLL_REVIEW_KITS_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_COLL_REVIEW_KITS_V

View Text

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

Columns