[Home] [Help]
319: -- mtln.transaction_id(+) = l.mmt_transaction_id AND
320: -- mtln.lot_number(+) = l.lot_number AND
321: -- mmt.source_line_id = -99 AND
322: mmt.opm_costed_flag IS NOT NULL AND
323: not exists (select 'x' from gme_transaction_pairs tp
324: where transaction_id1 = mmt.transaction_id and tp.pair_type = 1)
325: ORDER by v.prod_layer_id DESC;
326:
327:
1399: SELECT mmt.rowid r_id, mmt.transaction_id as trans_id, mmt.transaction_date as trans_date,
1400: md.line_type as line_type, md.dtl_um as doc_um, 'M' as type, mmt.primary_quantity as trans_qty,
1401: tp.transaction_id2 as reverse_id
1402: from mtl_material_transactions mmt,
1403: gme_transaction_pairs tp,
1404: gme_material_details md,
1405: gme_batch_header b
1406: where md.batch_id = b.batch_id
1407: and b.batch_id = l_batch_id
1843: SELECT mmt.rowid r_id, mmt.transaction_id as trans_id, mmt.transaction_date as trans_date,
1844: md.line_type as line_type, md.dtl_um as doc_um, 'M' as type, mmt.primary_quantity as trans_qty,
1845: tp.transaction_id2 as reverse_id, mmt.trx_source_line_id AS mat_det_id
1846: from mtl_material_transactions mmt,
1847: gme_transaction_pairs tp,
1848: gme_material_details md,
1849: gme_batch_header b
1850: where md.batch_id = b.batch_id
1851: and b.batch_id = l_batch_id