APPS.FLM_PURGE dependencies on MTL_MATERIAL_TRANSACTIONS

Line 25: FROM MTL_MATERIAL_TRANSACTIONS

21: into l_records_found
22: FROM DUAL
23: WHERE EXISTS
24: (SELECT 1
25: FROM MTL_MATERIAL_TRANSACTIONS
26: WHERE ORGANIZATION_ID = arg_org_id
27: AND INVENTORY_ITEM_ID = arg_item_id
28: AND TRANSACTION_SOURCE_TYPE_ID + 0 = 5
29: AND TRANSACTION_SOURCE_ID = arg_wip_entity_id);

Line 33: arg_table_name := arg_table_name || ' MTL_MATERIAL_TRANSACTIONS *';

29: AND TRANSACTION_SOURCE_ID = arg_wip_entity_id);
30:
31:
32: if (l_records_found <> 0) then
33: arg_table_name := arg_table_name || ' MTL_MATERIAL_TRANSACTIONS *';
34: l_flag := FALSE;
35: end if;
36:
37: l_stmt_num := 320;

Line 44: FROM MTL_TRANSACTION_ACCOUNTS MTA , MTL_MATERIAL_TRANSACTIONS MMT

40: into l_records_found
41: FROM DUAL
42: WHERE EXISTS
43: (SELECT 1
44: FROM MTL_TRANSACTION_ACCOUNTS MTA , MTL_MATERIAL_TRANSACTIONS MMT
45: WHERE MMT.ORGANIZATION_ID = arg_org_id
46: AND MMT.TRANSACTION_SOURCE_ID = arg_wip_entity_id
47: AND MMT.TRANSACTION_ID = MTA.TRANSACTION_ID
48: AND MMT.TRANSACTION_SOURCE_TYPE_ID +0 = 5 );

Line 204: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP

200:
201: Begin
202: l_stmt_num := 410;
203:
204: DELETE FROM MTL_MATERIAL_TRANSACTIONS_TEMP
205: WHERE TRANSACTION_SOURCE_TYPE_ID +0 = 5
206: AND TRANSACTION_SOURCE_ID = arg_wip_entity_id
207: AND ORGANIZATION_ID = arg_org_id;
208: