[Home] [Help]
1012: FROM gmf_batch_vib_details v,
1013: gmf_incoming_material_layers il,
1014: gmf_outgoing_material_layers ol,
1015: mtl_material_transactions t,
1016: gme_transaction_pairs tp,
1017: gmf_outgoing_material_layers ol2,
1018: mtl_material_transactions t2
1019: WHERE
1020: il.mmt_transaction_id = p_tran_rec.reverse_id AND -- incoming layer of reversed prod yield
1067: mtl_material_transactions mmt,
1068: mtl_transaction_lot_numbers mtln,
1069: mtl_system_items_b msi,
1070: gme_material_details md,
1071: gme_transaction_pairs tp
1072: WHERE
1073: mmt.transaction_source_type_id = 5 AND
1074: mmt.transaction_source_id = p_tran_rec.transaction_source_id AND
1075: mmt.trx_source_line_id = p_ing_material_detail_id AND
1836: mtln.transaction_id(+) = t.transaction_id AND
1837: l.mmt_transaction_id = t.transaction_id AND
1838: l.pseudo_layer_id IS NULL AND
1839: nvl(l.lot_number, '@@@') = nvl(mtln.lot_number, '@@@') AND
1840: not exists (select 'x' from gme_transaction_pairs tp
1841: where transaction_id1 = t.transaction_id and tp.pair_type = 1)
1842: ORDER BY l.creation_date DESC;
1843:
1844: CURSOR c_remaining_ing_layers (p_ing_material_detail_id NUMBER) IS
1846: mtln.lot_number, md.line_type, t.primary_quantity, msi.primary_uom_code, l.ROWID, tp.transaction_id2 as reverse_id,
1847: l.layer_doc_qty
1848: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,
1849: mtl_transaction_lot_numbers mtln, gme_material_details md,
1850: mtl_system_items_b msi, gme_transaction_pairs tp
1851: WHERE
1852: t.trx_source_line_id = p_ing_material_detail_id AND
1853: t.transaction_source_id = p_batch_id AND
1854: t.transaction_source_type_id = 5 AND