DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 976: FROM mtl_secondary_inventories

972:
973: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
974: IS
975: SELECT locator_type
976: FROM mtl_secondary_inventories
977: WHERE organization_id = v_org_id
978: AND secondary_inventory_name = v_subinventory;
979: /* Bug 5441643 Added NVL condition for location control code*/
980: /* Bug 5681997 Added mtl_transactions_enabled_flag from item master */

Line 3051: FROM mtl_secondary_inventories

3047:
3048: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
3049: IS
3050: SELECT locator_type
3051: FROM mtl_secondary_inventories
3052: WHERE organization_id = v_org_id
3053: AND secondary_inventory_name = v_subinventory;
3054: BEGIN
3055: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN