DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on GME_BATCH_HEADER

Line 254: FROM gme_batch_header bh

250: SELECT batch_id,
251: NTILE(cp_num_req) OVER(ORDER BY batch_id) bucket_num
252: FROM (
253: SELECT bh.batch_id
254: FROM gme_batch_header bh
255: ,mtl_material_transactions mmt
256: ,gmf_organization_definitions god
257: WHERE mmt.transaction_source_type_id = 5
258: AND mmt.transaction_action_id IN (1, 27, 31, 32)

Line 266: FROM gme_batch_header bh

262: AND mmt.organization_id = god.organization_id
263: AND mmt.transaction_date between cp_posting_start_date and cp_posting_end_date
264: UNION
265: SELECT bh.batch_id
266: FROM gme_batch_header bh
267: ,gme_resource_txns rt
268: ,gmf_organization_definitions god
269: WHERE rt.posted_ind = 0
270: AND rt.delete_mark = 0

Line 278: FROM gme_batch_header bh,

274: AND rt.organization_id = god.organization_id
275: AND rt.trans_date between cp_posting_start_date and cp_posting_end_date
276: UNION
277: SELECT bh.batch_id
278: FROM gme_batch_header bh,
279: gmf_organization_definitions god
280: WHERE bh.batch_close_date IS NOT NULL
281: AND bh.batch_status = 4
282: AND bh.gl_posted_ind = 0