DBA Data[Home] [Help]

APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 473: mtl_System_items_b msi

469: from opi_pmi_cost_result_gtmp costs,
470: OPI_DBI_JOBS_F jobs,
471: ic_whse_mst whse,
472: ic_item_mst_b item,
473: mtl_System_items_b msi
474: where whse.mtl_organization_id = f.organization_id
475: and whse.whse_code = costs.whse_code
476: and whse.orgn_code = costs.orgn_code
477: and trunc(jobs.completion_date) = trunc(costs.trans_date)

Line 1730: mtl_system_items_b msi,

1726: inventory_item_id,
1727: to_number(job_id),
1728: to_number(job_type)
1729: ) act_std,
1730: mtl_system_items_b msi,
1731: eni_oltp_item_star cat,
1732: opi_dbi_cuv_conv_rates conv
1733: WHERE
1734: act_std.organization_id = msi.organization_id