[Home] [Help]
643: nvl(project_reference_enabled, 2)
644: into l_locatorCntlCode,
645: l_projRefEnabled
646: from mtl_parameters p,
647: mtl_secondary_inventories s,
648: mtl_system_items i
649: where i.inventory_item_id = pt_rec.inventory_item_id
650: and i.organization_id = pt_rec.organization_id
651: and s.secondary_inventory_name = pt_rec.subinventory_code
1501: and transaction_source_type_id = 5
1502: and transaction_action_id <> WIP_CONSTANTS.SCRASSY_ACTION
1503: and ( ( l_poExpToAssetTnsf = 2
1504: and not exists(select 'X'
1505: from mtl_secondary_inventories sub,
1506: mtl_system_items msi
1507: where msi.organization_id = mti.organization_id
1508: and msi.inventory_item_id = msi.inventory_item_id
1509: and sub.organization_id = mti.organization_id
1514: and sub.quantity_tracked =1 )
1515: or msi.inventory_asset_flag = 'N')))
1516: or ( l_poExpToAssetTnsf <> 2
1517: and not exists (select 'X'
1518: from mtl_secondary_inventories sub
1519: where sub.organization_id = mti.organization_id
1520: and nvl(sub.disable_date, trunc(sysdate)+1) > trunc(sysdate)
1521: and sub.quantity_tracked = 1 )));
1522:
2399: sub.locator_type),
2400: mp.stock_locator_control_code)
2401: into l_locctrl
2402: from mtl_parameters mp,
2403: mtl_secondary_inventories sub,
2404: mtl_system_items it
2405: where it.inventory_item_id = l_itemIDTbl(i)
2406: and sub.secondary_inventory_name = l_subCodeTbl(i)
2407: and mp.organization_id = l_orgIDTbl(i)