DBA Data[Home] [Help]

APPS.OPI_DBI_INV_CCA_OPM_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 428: mtl_system_items_b msi,

424: ic_whse_inv iwi,
425: ic_cycl_dtl icd,
426: ic_item_mst_b icmb,
427: ic_whse_mst iwm,
428: mtl_system_items_b msi,
429: (SELECT /*+ use_hash(gsl,itc) parallel(gsl) parallel(itc) */
430: gsl.amount_base amount_base,
431: itc.whse_code whse_code,
432: itc. item_id item_id,

Line 577: mtl_system_items_b msi

573: ic_whse_inv iwi,
574: ic_whse_mst iwm,
575: ic_cycl_dtl icd,
576: ic_item_mst_b icmb,
577: mtl_system_items_b msi
578: WHERE
579: ica.cycle_id = ich.cycle_id and
580: ica.cycle_id = icd.cycle_id and
581: ica.item_id = icd.item_id and