APPS.OPI_DBI_RES_OPM_PKG dependencies on IC_ITEM_MST_B

Line 301: ic_item_mst_b item,

297: sy_orgn_mst_b plant,
298: gl_plcy_mst pol,
299: ic_whse_mst whse,
300: gme_material_details prod,
301: ic_item_mst_b item,
302: mtl_system_items_b msi
303: WHERE
304: hruom.um_code = g_hr_uom
305: AND rlc.etl_id = 4

Line 483: ic_item_mst_b i,

479: job.source
480: FROM
481: opi_dbi_jobs_f job,
482: mtl_system_items_b msi,
483: ic_item_mst_b i,
484: gme_material_details bmatl
485: WHERE
486: job.job_type = 4
487: AND job.std_res_flag = 1

Line 827: ic_item_mst_b item,

823: sy_orgn_mst_b plant,
824: ic_whse_mst whse,
825: gme_resource_txns rtran,
826: gme_material_details prod,
827: ic_item_mst_b item,
828: mtl_system_items_b msi,
829: gl_plcy_mst pol,
830: opi_dbi_run_log_curr rlc,
831: sy_uoms_mst hruom,

Line 1021: ic_item_mst_b i,

1017: job.source
1018: FROM
1019: opi_dbi_jobs_f job,
1020: mtl_system_items_b msi,
1021: ic_item_mst_b i,
1022: gme_material_details bmatl
1023: WHERE
1024: job.job_type = 4
1025: AND job.std_res_flag = 1