APPS.WIP_WEIGHTED_AVG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 99: from mtl_material_transactions

95: cursor get_mmt_cmp_qty (
96: c_org_id NUMBER,
97: c_wip_id NUMBER) is
98: select nvl(sum(primary_quantity),0)
99: from mtl_material_transactions
100: where transaction_source_type_id = 5
101: and transaction_source_id = c_wip_id
102: and organization_id = c_org_id
103: and transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,

Line 181: from mtl_material_transactions_temp mmtt

177:
178: cursor get_cmp_txns(c_mtl_hdr_id number) is
179: select mmtt.rowid,
180: mmtt.primary_quantity
181: from mtl_material_transactions_temp mmtt
182: where mmtt.transaction_header_id = c_mtl_hdr_id
183: and mmtt.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
184: order by mmtt.source_line_id;
185:

Line 232: update mtl_material_transactions_temp

228: exit when x_done;
229:
230: -- update completion flag
231: if (x_pri_qty >= x_rem_qty) then
232: update mtl_material_transactions_temp
233: set final_completion_flag = 'Y'
234: where rowid = x_rowid;
235: end if;
236: