DBA Data[Home] [Help]

APPS.GMI_RESERVATION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1953: From mtl_system_items_b mtl

1949:
1950: -- Get the inventory_item_id for the org
1951: Cursor get_inventory_item_id IS
1952: Select inventory_item_id
1953: From mtl_system_items_b mtl
1954: , ic_item_mst ic
1955: Where ic.item_id = p_item_id
1956: and mtl.organization_id = p_organization_id
1957: and ic.item_no = mtl.segment1;

Line 2984: FROM mtl_system_items

2980: SELECT item_id
2981: FROM ic_item_mst
2982: WHERE delete_mark = 0
2983: AND item_no in (SELECT segment1
2984: FROM mtl_system_items
2985: WHERE organization_id = p_organization_id
2986: AND inventory_item_id = l_apps_itm_id);
2987:
2988: CURSOR get_item_ctl(l_opm_itm_id NUMBER) IS