APPS.INV_AUTODETAIL dependencies on MTL_SECONDARY_INVENTORIES

Line 252: FROM mtl_secondary_inventories

248: AND default_type = 3; -- default transfer order sub
249: --
250: /* CURSOR l_sub_status_csr IS
251: SELECT status_id
252: FROM mtl_secondary_inventories
253: WHERE secondary_inventory_name = l_putaway_sub
254: AND organization_id = l_organization_id ;
255: --
256: CURSOR l_locator_type_csr IS

Line 258: FROM mtl_secondary_inventories

254: AND organization_id = l_organization_id ;
255: --
256: CURSOR l_locator_type_csr IS
257: SELECT locator_type
258: FROM mtl_secondary_inventories
259: WHERE secondary_inventory_name = l_putaway_sub
260: AND organization_id = l_organization_id ;
261: */ --
262: CURSOR l_locator_status_csr IS

Line 288: FROM mtl_secondary_inventories msi

284: WHERE mp.organization_id = p_organization_id;
285:
286: CURSOR l_cost_group_csr IS
287: SELECT default_cost_group_id
288: FROM mtl_secondary_inventories msi
289: WHERE msi.secondary_inventory_name = l_putaway_sub
290: AND msi.organization_id = p_organization_id;
291: */
292:

Line 936: l_from := l_from || ',mtl_secondary_inventories msi';

932: -- ----------------------------------------------
933: -- Third, picking rule pertaining to subinventory
934: -- ----------------------------------------------
935: IF l_sub_rule = 2 THEN -- Subinventory Picking Order
936: l_from := l_from || ',mtl_secondary_inventories msi';
937: l_sub_where := l_sub_where
938: || g_line_feed
939: || ' AND base.subinventory_code = msi.secondary_inventory_name '
940: || g_line_feed

Line 1215: l_from_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;

1211: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;
1212: --
1213: l_serial_number VARCHAR2(30);
1214:
1215: l_from_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;
1216: l_to_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;
1217: l_org_rec MTL_PARAMETERS%ROWTYPE;
1218: l_item_rec MTL_SYSTEM_ITEMS%ROWTYPE;
1219: l_ret_value NUMBER;

Line 1216: l_to_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;

1212: --
1213: l_serial_number VARCHAR2(30);
1214:
1215: l_from_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;
1216: l_to_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;
1217: l_org_rec MTL_PARAMETERS%ROWTYPE;
1218: l_item_rec MTL_SYSTEM_ITEMS%ROWTYPE;
1219: l_ret_value NUMBER;
1220: l_move_order_type NUMBER;

Line 1227: FROM MTL_SECONDARY_INVENTORIES

1223: l_att_om_indivisible NUMBER;
1224:
1225: /* CURSOR l_from_sub_cursor IS
1226: SELECT *
1227: FROM MTL_SECONDARY_INVENTORIES
1228: WHERE secondary_inventory_name = l_from_subinventory
1229: AND organization_id = p_request_line_rec.organization_id;
1230:
1231: CURSOR l_to_sub_cursor IS

Line 1233: FROM MTL_SECONDARY_INVENTORIES

1229: AND organization_id = p_request_line_rec.organization_id;
1230:
1231: CURSOR l_to_sub_cursor IS
1232: SELECT *
1233: FROM MTL_SECONDARY_INVENTORIES
1234: WHERE secondary_inventory_name = l_to_subinventory
1235: AND organization_id = p_request_line_rec.organization_id;
1236:
1237: CURSOR l_org_cursor IS