DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_ITEM_ASSOCIATIONS_VL

Line 268: FROM ahl_item_associations_vl it,

264: SELECT it.inventory_item_id,
265: it.priority,
266: it.uom_code,
267: it.quantity
268: FROM ahl_item_associations_vl it,
269: mtl_system_items_vl mt
270: WHERE it.inventory_item_id = mt.inventory_item_id
271: AND item_group_id = C_ITEM_GROUP_ID
272: AND mt.organization_id = C_ORG_ID