DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on GME_MATERIAL_DETAILS

Line 2272: gme_material_details gmdtl,

2268: decode(gtv.journal_line_type,'WIP',gtv.doc_id,NULL),
2269: gtv.journal_line_type,
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

Line 2392: gme_material_details gmdtl

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'
2394: AND nvl(gtv.accounted_flag,'F') <> 'N'
2395: AND gtv.transaction_date >= g_global_start_date
2396: AND gtv.doc_id = gmdtl.batch_id