DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on GME_BATCH_HEADER

Line 2274: -- gme_batch_headers gbh

2270: gtv.event_class_code,
2271: gtv.final_posting_date) gtv,
2272: gme_material_details gmdtl,
2273: opi_dbi_conc_prog_run_log prl
2274: -- gme_batch_headers gbh
2275: WHERE gtv.doc_id = gmdtl.batch_id(+)
2276: AND nvl(gmdtl.line_type,1) = 1 -- (MK) identified issue during UT. Need to be reviewed with Vikas/David
2277: AND prl.driving_table_code = 'GTV'
2278: AND prl.etl_type = 'INVENTORY'

Line 2389: FROM gme_batch_header gbh,

2385: gmdtl.cost_alloc))) wip_value_b,
2386: 2 source,
2387: 'N' push_to_fact_flag,
2388: 'OPJ' transaction_source
2389: FROM gme_batch_header gbh,
2390: gmf_transaction_valuation gtv,
2391: opi_dbi_org_le_temp tmp, --Bug 4768058
2392: gme_material_details gmdtl
2393: WHERE gtv.journal_line_type = 'WIP'