DBA Data[Home] [Help]

APPS.WIP_WEIGHTED_AVG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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: