DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on OPI_PMI_COST_RESULT_GTMP

Line 338: opi_pmi_cost_result_gtmp c,

334: SUM(DECODE(q.type, 1, q.quantity * c.total_cost, 0)) onhand_value_b,
335: SUM(DECODE(q.type, 2, q.quantity * c.total_cost, 0)) intransit_value_b
336: FROM
337: opi_dbi_opm_inception_qty q,
338: opi_pmi_cost_result_gtmp c,
339: ic_item_mst_b iim,
340: ic_whse_mst w,
341: mtl_system_items_b msi
342: WHERE