APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on OPI_DBI_ORG_LE_TEMP

Line 1826: opi_dbi_org_le_temp tmp, --BUG 4768058

1822: (SELECT transaction_id,
1823: sum(txn_base_value) base_transaction_value
1824: ,accounted_flag
1825: FROM gmf_transaction_valuation gtv,
1826: opi_dbi_org_le_temp tmp, --BUG 4768058
1827: opi_dbi_conc_prog_run_log col
1828: WHERE --gtv.transaction_source = 'INVENTORY' AND --bug 4870029
1829: gtv.journal_line_type = 'ITR'
1830: and col.driving_table_code='GTV'

Line 2254: opi_dbi_org_le_temp tmp --bug 4768058

2250: decode(gtv.accounted_flag,NULL,txn_base_value,0),0)) --
2251: --decode('D',NULL,txn_base_value,0),0))
2252: wip_val_b
2253: from gmf_transaction_valuation gtv,
2254: opi_dbi_org_le_temp tmp --bug 4768058
2255: where --gtv.final_posting_date >= g_global_start_date -- Not required
2256: --and --
2257: gtv.journal_line_type IN ('WIP','INV')
2258: and gtv.transaction_date >= g_global_start_date

Line 2391: opi_dbi_org_le_temp tmp, --Bug 4768058

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