[Home] [Help]
1027: FROM gmf_batch_vib_details v,
1028: gmf_incoming_material_layers il,
1029: gmf_outgoing_material_layers ol,
1030: mtl_material_transactions t,
1031: gme_transaction_pairs tp,
1032: gmf_outgoing_material_layers ol2,
1033: mtl_material_transactions t2
1034: WHERE
1035: il.mmt_transaction_id = p_tran_rec.reverse_id AND -- incoming layer of reversed prod yield
1082: FROM gmf_outgoing_material_layers l,
1083: mtl_material_transactions mmt,
1084: mtl_system_items_b msi,
1085: gme_material_details md,
1086: gme_transaction_pairs tp
1087: WHERE
1088: mmt.transaction_source_type_id = 5 AND
1089: mmt.transaction_source_id = p_tran_rec.transaction_source_id AND
1090: mmt.trx_source_line_id = p_ing_material_detail_id AND
1103: FROM gmf_outgoing_material_layers l,
1104: mtl_material_transactions mmt,
1105: mtl_system_items_b msi,
1106: gme_material_details md,
1107: gme_transaction_pairs tp
1108: WHERE
1109: mmt.transaction_source_type_id = 5 AND
1110: mmt.transaction_source_id = p_tran_rec.transaction_source_id AND
1111: mmt.trx_source_line_id = p_ing_material_detail_id AND
1895: t.transaction_source_id = p_batch_id AND
1896: t.transaction_source_type_id = 5 AND
1897: l.mmt_transaction_id = t.transaction_id AND
1898: l.pseudo_layer_id IS NULL AND
1899: not exists (select 'x' from gme_transaction_pairs tp
1900: where transaction_id1 = t.transaction_id and tp.pair_type = 1)
1901: ORDER BY l.creation_date DESC;
1902:
1903: /* Bug 8219507 removed mtln from query */
1907: NULL lot_number, md.line_type, t.primary_quantity, msi.primary_uom_code, l.ROWID, tp.transaction_id2 as reverse_id,
1908: l.layer_doc_qty
1909: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,
1910: gme_material_details md,
1911: mtl_system_items_b msi, gme_transaction_pairs tp
1912: WHERE
1913: t.trx_source_line_id = p_ing_material_detail_id AND
1914: t.transaction_source_id = p_batch_id AND
1915: t.transaction_source_type_id = 5 AND