APPS.INV_VALIDATE_TROLIN dependencies on MTL_SECONDARY_INVENTORIES

Line 366: from mtl_secondary_inventories

362: else
363: if (l_org_loc_control = 4) then
364: select nvl(locator_type,3)
365: into l_sub_loc_control
366: from mtl_secondary_inventories
367: where organization_id = p_trolin_rec.organization_id
368: and secondary_inventory_name = p_trolin_rec.to_subinventory_code;
369:
370: if (l_sub_loc_control = 1) THEN

Line 409: FROM mtl_secondary_inventories

405: AND p_trolin_rec.to_subinventory_code is not null
406: THEN
407: SELECT NVL(lpn_controlled_flag, 0), reservable_type
408: INTO l_sub_lpn_controlled, l_sub_reservable
409: FROM mtl_secondary_inventories
410: WHERE organization_id = p_trolin_rec.organization_id
411: AND secondary_inventory_name = p_trolin_rec.to_subinventory_code;
412:
413: IF l_sub_reservable = inv_globals.g_subinventory_reservable

Line 1283: FROM mtl_secondary_inventories sec, mtl_item_sub_inventories item

1279: if( g_item.restrict_subinventories_code = 1 ) then
1280: --inv_Debug.message('ssia', 'g_item_restrict subinventory code is 1');
1281: BEGIN
1282: SELECT 'Y' INTO l_found
1283: FROM mtl_secondary_inventories sec, mtl_item_sub_inventories item
1284: WHERE item.inventory_item_id = p_trolin_rec.inventory_item_id
1285: AND sec.organization_id = p_trolin_Rec.organization_id
1286: AND sec.secondary_inventory_name = p_trolin_rec.to_subinventory_code
1287: AND sec.organization_id = item.organization_id

Line 1302: FROM mtl_secondary_inventories

1298: -- item is not restricted to specific subs
1299: --inv_Debug.message('ssia', 'g_item_restrict subinventory code is 2');
1300: BEGIN
1301: SELECT 'Y' INTO l_found
1302: FROM mtl_secondary_inventories
1303: WHERE organization_id = p_trolin_rec.organization_id
1304: AND secondary_inventory_name = p_trolin_rec.to_subinventory_code
1305: AND nvl(disable_date, SYSDATE+1) > SYSDATE;
1306: --