DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1016: FROM mtl_secondary_inventories

1012:
1013: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
1014: IS
1015: SELECT locator_type
1016: FROM mtl_secondary_inventories
1017: WHERE organization_id = v_org_id
1018: AND secondary_inventory_name = v_subinventory;
1019: /* Bug 5441643 Added NVL condition for location control code*/
1020: /* Bug 5681997 Added mtl_transactions_enabled_flag from item master */

Line 3195: FROM mtl_secondary_inventories

3191:
3192: CURSOR cur_sub_control (v_org_id NUMBER, v_subinventory VARCHAR2)
3193: IS
3194: SELECT locator_type
3195: FROM mtl_secondary_inventories
3196: WHERE organization_id = v_org_id
3197: AND secondary_inventory_name = v_subinventory;
3198: BEGIN
3199: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN