[Home] [Help]
650: nvl(project_reference_enabled, 2)
651: into l_locatorCntlCode,
652: l_projRefEnabled
653: from mtl_parameters p,
654: mtl_secondary_inventories s,
655: mtl_system_items i
656: where i.inventory_item_id = pt_rec.inventory_item_id
657: and i.organization_id = pt_rec.organization_id
658: and s.secondary_inventory_name = pt_rec.subinventory_code
1547: and transaction_source_type_id = 5
1548: and transaction_action_id <> WIP_CONSTANTS.SCRASSY_ACTION
1549: and ( ( l_poExpToAssetTnsf = 2
1550: and not exists(select 'X'
1551: from mtl_secondary_inventories sub,
1552: mtl_system_items msi
1553: where msi.organization_id = mti.organization_id
1554: and msi.inventory_item_id = msi.inventory_item_id
1555: and sub.organization_id = mti.organization_id
1560: and sub.quantity_tracked =1 )
1561: or msi.inventory_asset_flag = 'N')))
1562: or ( l_poExpToAssetTnsf <> 2
1563: and not exists (select 'X'
1564: from mtl_secondary_inventories sub
1565: where sub.organization_id = mti.organization_id
1566: and nvl(sub.disable_date, trunc(sysdate)+1) > trunc(sysdate)
1567: and sub.quantity_tracked = 1 )));
1568:
2448: sub.locator_type),
2449: mp.stock_locator_control_code)
2450: into l_locctrl
2451: from mtl_parameters mp,
2452: mtl_secondary_inventories sub,
2453: mtl_system_items it
2454: where it.inventory_item_id = l_itemIDTbl(i)
2455: and sub.secondary_inventory_name = l_subCodeTbl(i)
2456: and mp.organization_id = l_orgIDTbl(i)