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_BATCH_VALIDATIONS dependencies on GME_BATCH_HEADER

Line 45: FROM gme_batch_header h, mtl_material_transactions t

41:
42: CURSOR Min_max_trans_date IS
43: SELECT min(trans_date), max(trans_date) from
44: (SELECT t.transaction_date trans_date
45: FROM gme_batch_header h, mtl_material_transactions t
46: WHERE h.batch_id = p_batch_id
47: AND h.organization_id = t.organization_id
48: AND h.batch_id = t.transaction_source_id
49: AND t.transaction_source_type_id = 5

Line 52: FROM gme_batch_header h, gme_resource_txns rt

48: AND h.batch_id = t.transaction_source_id
49: AND t.transaction_source_type_id = 5
50: UNION
51: SELECT rt.trans_date
52: FROM gme_batch_header h, gme_resource_txns rt
53: WHERE h.batch_id = p_batch_id
54: AND h.batch_id = rt.doc_id
55: AND rt.completed_ind = 1
56: AND rt.doc_type = 'PROD') txn;

Line 61: gme_batch_header gbh, gmf_calendar_assignments gca

57:
58: CURSOR Get_period_id (p_date DATE) IS
59: SELECT gps.period_id
60: FROM gmf_period_statuses gps, gmf_organization_definitions god, gmf_fiscal_policies gfp,
61: gme_batch_header gbh, gmf_calendar_assignments gca
62: WHERE gbh.batch_id = p_batch_id
63: AND gbh.organization_id = god.organization_id
64: AND god.legal_entity_id = gfp.legal_entity_id
65: AND gfp.delete_mark = 0