DBA Data[Home] [Help]

APPS.GMI_OM_ALLOC_API_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1912: , mtl_system_items mtl

1908: CURSOR ic_item_mst_cur ( discrete_org_id IN NUMBER
1909: , discrete_item_id IN NUMBER) IS
1910: SELECT ic.*
1911: FROM ic_item_mst_b ic
1912: , mtl_system_items mtl
1913: WHERE delete_mark = 0
1914: AND ic.item_no = mtl.segment1
1915: AND mtl.organization_id = discrete_org_id
1916: AND mtl.inventory_item_id = discrete_item_id;