APPS.OPI_DBI_INV_CCA_OPM_PKG dependencies on IC_CYCL_DTL

Line 425: ic_cycl_dtl icd,

421: ic_cycl_adt ica,
422: ic_cycl_hdr ich,
423: ic_rank_mst irm,
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) */

Line 575: ic_cycl_dtl icd,

571: ic_cycl_hdr ich,
572: ic_rank_mst irm,
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