APPS.WSMPINVL dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1233: FROM mtl_material_transactions_temp mmtt

1229: IF x_dummy <>0 then
1230: lProcLocation := 30;
1231:
1232: SELECT 0 into x_dummy -- Fine if it satisfies this condition.
1233: FROM mtl_material_transactions_temp mmtt
1234: WHERE mmtt.organization_id = crec.organization_id
1235: and mmtt.inventory_item_id = crec.inventory_item_id
1236: and NVL(mmtt.lot_number, '@#$') = crec.lot_number
1237: and mmtt.subinventory_code = crec.subinventory_code

Line 1245: FROM mtl_material_transactions_temp mmtt2

1241: and mmtt.transaction_source_type_id = 13 -- Inventory
1242: and crec.quantity = ((-1) * mmtt.transaction_quantity)
1243: and mmtt.transaction_date = (
1244: SELECT max(mmtt2.transaction_date)
1245: FROM mtl_material_transactions_temp mmtt2
1246: WHERE mmtt2.organization_id = crec.organization_id
1247: and mmtt2.inventory_item_id = crec.inventory_item_id
1248: and NVL(mmtt2.lot_number, '@#$') = crec.lot_number
1249: and mmtt2.subinventory_code = crec.subinventory_code

Line 1697: FROM mtl_material_transactions_temp mmtt

1693:
1694: lprocLocation := 40;
1695:
1696: SELECT 0 into x_dummy -- Fine if it satisfies this condition.
1697: FROM mtl_material_transactions_temp mmtt
1698: WHERE mmtt.organization_id = crec.organization_id
1699: and mmtt.inventory_item_id = crec.inventory_item_id
1700: and NVL(mmtt.lot_number, '@#$') = crec.lot_number
1701: and mmtt.subinventory_code = crec.subinventory_code

Line 1709: FROM mtl_material_transactions_temp mmtt2

1705: and mmtt.transaction_source_type_id = 13 -- Inventory
1706: and crec.quantity = ((-1) * mmtt.transaction_quantity)
1707: and mmtt.transaction_date = (
1708: SELECT max(mmtt2.transaction_date)
1709: FROM mtl_material_transactions_temp mmtt2
1710: WHERE mmtt2.organization_id = crec.organization_id
1711: and mmtt2.inventory_item_id = crec.inventory_item_id
1712: and NVL(mmtt2.lot_number, '@#$') = crec.lot_number
1713: and mmtt2.subinventory_code = crec.subinventory_code

Line 4383: INSERT INTO mtl_material_transactions_temp

4379: /*EA#1754109*/
4380:
4381:
4382: l_stmt_num :=40;
4383: INSERT INTO mtl_material_transactions_temp
4384: (last_update_date,
4385: creation_date,
4386: last_updated_by,
4387: created_by,

Line 4603: INSERT INTO mtl_material_transactions_temp

4599:
4600: l_stmt_num :=40;
4601:
4602:
4603: INSERT INTO mtl_material_transactions_temp
4604: (last_update_date,
4605: creation_date,
4606: last_updated_by,
4607: created_by,