DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on GMF_ORGANIZATION_DEFINITIONS

Line 256: ,gmf_organization_definitions god

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)
259: AND mmt.opm_costed_flag IS NOT NULL
260: AND god.legal_entity_id = cp_le_id

Line 268: ,gmf_organization_definitions god

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
271: AND rt.completed_ind = 1
272: AND god.legal_entity_id = cp_le_id

Line 279: gmf_organization_definitions god

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
283: AND nvl(bh.update_inventory_ind, 'N') = 'Y'