149: cr_rsrc_dtl rdtl,
150: cr_rsrc_mst_b rmst,
151: sy_orgn_mst_b plant,
152: gl_plcy_mst pol,
153: ic_whse_mst whse,
154: gmp_resource_avail ravail
155: WHERE
156: rmst.resources = rdtl.resources
157: AND plant.orgn_code = rdtl.orgn_code
295: cr_rsrc_dtl rdtl,
296: cr_rsrc_mst_b rmst,
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
682: cr_rsrc_dtl rdtl,
683: cr_rsrc_mst_b rmst,
684: sy_orgn_mst_b plant,
685: gl_plcy_mst pol,
686: ic_whse_mst whse,
687: gmp_resource_avail ravail
688: WHERE
689: rmst.resources = rdtl.resources
690: AND plant.orgn_code = rdtl.orgn_code
820: FROM
821: cr_rsrc_dtl rdtl,
822: cr_rsrc_mst_b rmst,
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,