DBA Data[Home] [Help]

APPS.GMF_LAYERS dependencies on GME_MATERIAL_DETAILS

Line 1404: gme_material_details md,

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
1408: and mmt.transaction_source_type_id = 5

Line 1848: gme_material_details md,

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
1852: and mmt.transaction_source_type_id = 5