[Home] [Help]
109: IF (p_tran_rec.reverse_id IS NOT NULL and p_tran_rec.doc_qty IS NULL) THEN
110: BEGIN
111: SELECT -l.layer_doc_qty, l.layer_doc_um
112: INTO l_doc_qty, l_doc_um
113: FROM gmf_incoming_material_layers l, mtl_material_transactions mmt,
114: mtl_transaction_lot_numbers mtln
115: WHERE
116: mmt.transaction_id = p_tran_rec.reverse_id AND
117: mtln.transaction_id (+) = p_tran_rec.reverse_id AND
286: SELECT v.rowid, v.*, mmt.organization_id, l.layer_date
287: FROM gmf_batch_vib_details v,
288: gmf_batch_requirements r,
289: gmf_incoming_material_layers l,
290: mtl_material_transactions mmt,
291: mtl_transaction_lot_numbers mtln
292: WHERE
293: r.batch_id = p_tran_rec.transaction_source_id AND
294: r.ing_material_detail_id = p_tran_rec.trx_source_line_id AND
365: IF (p_tran_rec.reverse_id IS NOT NULL and p_tran_rec.doc_qty IS NULL) THEN
366: BEGIN
367: SELECT -l.layer_doc_qty, l.layer_doc_um
368: INTO l_doc_qty, l_doc_um
369: FROM gmf_outgoing_material_layers l, mtl_material_transactions mmt,
370: mtl_transaction_lot_numbers mtln
371: WHERE
372: mmt.transaction_id = p_tran_rec.reverse_id AND
373: mtln.transaction_id (+) = p_tran_rec.reverse_id AND
685: SELECT v.rowid, v.*, t.organization_id, l.layer_date
686: FROM gmf_batch_vib_details v,
687: gmf_batch_requirements r,
688: gmf_incoming_material_layers l,
689: mtl_material_transactions t
690: WHERE
691: r.batch_id = p_rsrc_rec.doc_id AND
692: r.batchstep_resource_id = p_rsrc_rec.line_id AND
693: r.delete_mark = 0 AND