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,
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