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 1269: FROM mtl_secondary_inventories sec, mtl_item_sub_inventories item

1265: if( g_item.restrict_subinventories_code = 1 ) then
1266: --inv_Debug.message('ssia', 'g_item_restrict subinventory code is 1');
1267: BEGIN
1268: SELECT 'Y' INTO l_found
1269: FROM mtl_secondary_inventories sec, mtl_item_sub_inventories item
1270: WHERE item.inventory_item_id = p_trolin_rec.inventory_item_id
1271: AND sec.organization_id = p_trolin_Rec.organization_id
1272: AND sec.secondary_inventory_name = p_trolin_rec.to_subinventory_code
1273: AND sec.organization_id = item.organization_id

Line 1288: FROM mtl_secondary_inventories

1284: -- item is not restricted to specific subs
1285: --inv_Debug.message('ssia', 'g_item_restrict subinventory code is 2');
1286: BEGIN
1287: SELECT 'Y' INTO l_found
1288: FROM mtl_secondary_inventories
1289: WHERE organization_id = p_trolin_rec.organization_id
1290: AND secondary_inventory_name = p_trolin_rec.to_subinventory_code
1291: AND nvl(disable_date, SYSDATE+1) > SYSDATE;
1292: --