APPS.WMA_FLOW dependencies on WIP_LPN_COMPLETIONS_LOTS

Line 627: in wip_lpn_completions_lots and wip_lpn_completions_serials.

623:
624: /*Start - Fix for bug #6216695, which is an FP of 6082623 :
625: Insert records into MTLT and MSNT also. Need to create records in
626: mtl_transaction_lots_temp and mtl_serial_numbers_temp based on data
627: in wip_lpn_completions_lots and wip_lpn_completions_serials.
628: This is done so that the data is available for label printing. */
629:
630: insert into mtl_transaction_lots_temp(
631: transaction_temp_id,

Line 800: from wip_lpn_completions_lots wlcl

796: wlcl.width_uom,
797: wlcl.curl_wrinkle_fold,
798: wlcl.last_update_date,
799: wlcl.last_updated_by
800: from wip_lpn_completions_lots wlcl
801: where wlcl.header_id = flowRec.header_id;
802:
803: update mtl_transaction_lots_temp
804: set serial_transaction_temp_id = mtl_material_transactions_s.nextval