eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_VIB dependencies on GME_RESOURCE_TXNS

Line 1064: gme_resource_txns t,

1060: decode (t.reverse_id, NULL, ol.ROWID, ol2.ROWID) c_rowid
1061: FROM gmf_batch_vib_details v,
1062: gmf_incoming_material_layers il,
1063: gmf_resource_layers ol,
1064: gme_resource_txns t,
1065: gmf_resource_layers ol2,
1066: gme_resource_txns t2
1067: WHERE
1068: il.mmt_transaction_id = p_tran_rec.reverse_id AND

Line 1066: gme_resource_txns t2

1062: gmf_incoming_material_layers il,
1063: gmf_resource_layers ol,
1064: gme_resource_txns t,
1065: gmf_resource_layers ol2,
1066: gme_resource_txns t2
1067: WHERE
1068: il.mmt_transaction_id = p_tran_rec.reverse_id AND
1069: nvl(il.lot_number, '@@@') = nvl(p_tran_rec.lot_number, '@@@') AND
1070: v.prod_layer_id = il.layer_id AND

Line 1125: FROM gmf_resource_layers l, gme_resource_txns p

1121:
1122:
1123: CURSOR c_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1124: SELECT p.resource_usage, p.trans_qty_um as trans_um, p.trans_date, p.line_type, p.reverse_id, p.organization_id, l.ROWID, l.*
1125: FROM gmf_resource_layers l, gme_resource_txns p
1126: WHERE
1127: p.doc_type = 'PROD' AND
1128: p.doc_id = p_tran_rec.transaction_source_id AND
1129: p.line_id = p_batchstep_resource_id AND

Line 1925: /* Bug 13442362 13367279 Added t.doc_type = 'PROD' AND t.doc_id = p_batch_id so that index on gme_resource_txns is used */

1921: msi.organization_id = t.organization_id AND
1922: tp.transaction_id1(+) = t.transaction_id
1923: ;
1924:
1925: /* Bug 13442362 13367279 Added t.doc_type = 'PROD' AND t.doc_id = p_batch_id so that index on gme_resource_txns is used */
1926:
1927: CURSOR c_remaining_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1928: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.line_type, t.trans_date,
1929: t.resource_usage, t.trans_qty_um trans_um, l.ROWID, t.reverse_id, l.layer_doc_qty

Line 1931: gme_resource_txns t

1927: CURSOR c_remaining_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1928: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.line_type, t.trans_date,
1929: t.resource_usage, t.trans_qty_um trans_um, l.ROWID, t.reverse_id, l.layer_doc_qty
1930: FROM gmf_resource_layers l,
1931: gme_resource_txns t
1932: WHERE
1933: t.doc_type = 'PROD' AND
1934: t.doc_id = p_batch_id AND
1935: l.poc_trans_id = t.poc_trans_id AND