DBA Data[Home] [Help]

APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 1623: mtl_system_items_vl mtl

1619: schm.requested_date,
1620: schm.requested_quantity,
1621: mtl.concatenated_segments
1622: FROM ahl_schedule_materials schm,
1623: mtl_system_items_vl mtl
1624: WHERE schm.inventory_item_id = mtl.inventory_item_id
1625: AND schm.organization_id = mtl.organization_id
1626: AND schm.requested_quantity <> 0
1627: AND NVL(schm.status, 'X') <> 'IN-SERVICE' --Added by sowsubra for Issue 105