DBA Data[Home] [Help]

APPS.WIP_WEIGHTED_AVG dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 204: from mtl_material_transactions_temp mmtt

200:
201: cursor get_cmp_txns(c_mtl_hdr_id number) is
202: select mmtt.rowid,
203: mmtt.primary_quantity
204: from mtl_material_transactions_temp mmtt
205: where mmtt.transaction_header_id = c_mtl_hdr_id
206: and mmtt.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
207: order by mmtt.source_line_id;
208:

Line 278: update mtl_material_transactions_temp

274: -- update completion flag
275: -- Fix bug 13826369, only update final_completion_flag to 'Y' if there
276: -- isn't any remaining qty. This is based on Costing Team suggestion.
277: if (x_pri_qty >= x_rem_qty AND l_remain_job_qty = 0) then
278: update mtl_material_transactions_temp
279: set final_completion_flag = 'Y'
280: where rowid = x_rowid;
281: end if;
282: