APPS.FLM_PURGE dependencies on DUAL

Line 22: FROM DUAL

18: l_stmt_num := 310;
19:
20: SELECT COUNT(*)
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

Line 41: FROM DUAL

37: l_stmt_num := 320;
38:
39: SELECT COUNT(*)
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

Line 59: FROM DUAL

55: l_stmt_num := 330;
56:
57: SELECT COUNT(*)
58: into l_records_found
59: FROM DUAL
60: WHERE EXISTS
61: (SELECT 1
62: FROM MTL_TRANSACTION_LOT_NUMBERS
63: WHERE TRANSACTION_SOURCE_TYPE_ID = 5

Line 75: FROM DUAL

71: l_stmt_num := 340;
72:
73: SELECT COUNT(*)
74: into l_records_found
75: FROM DUAL
76: WHERE EXISTS
77: (SELECT 1
78: FROM MTL_UNIT_TRANSACTIONS
79: WHERE TRANSACTION_SOURCE_TYPE_ID = 5

Line 91: FROM DUAL

87: l_stmt_num := 350;
88:
89: SELECT COUNT(*)
90: into l_records_found
91: FROM DUAL
92: WHERE EXISTS
93: (SELECT 1
94: FROM MTL_DEMAND MD, WIP_ENTITIES WE
95: WHERE WE.WIP_ENTITY_ID = arg_wip_entity_id

Line 110: FROM DUAL

106: l_stmt_num := 360;
107:
108: SELECT COUNT(*)
109: into l_records_found
110: FROM DUAL
111: WHERE EXISTS
112: (SELECT 1
113: FROM MTL_USER_SUPPLY
114: WHERE SOURCE_TYPE_ID = 4

Line 127: FROM DUAL

123: l_stmt_num := 370;
124:
125: SELECT COUNT(*)
126: into l_records_found
127: FROM DUAL
128: WHERE EXISTS
129: (SELECT 1
130: FROM MTL_USER_DEMAND
131: WHERE SOURCE_TYPE_ID = 4

Line 144: FROM DUAL

140: l_stmt_num := 380;
141:
142: SELECT COUNT(*)
143: into l_records_found
144: FROM DUAL
145: WHERE EXISTS
146: (SELECT 1
147: FROM MTL_SERIAL_NUMBERS
148: WHERE INVENTORY_ITEM_ID = arg_item_id