APPS.OPI_DBI_RES_OPM_PKG dependencies on CR_RSRC_DTL

Line 149: cr_rsrc_dtl rdtl,

145: whse.mtl_organization_id organization_id,
146: ravail.shift_date,
147: SUM((ravail.to_time - ravail.from_time)/3600) shift_hours
148: FROM
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,

Line 295: cr_rsrc_dtl rdtl,

291: sy_uoms_mst hruom,
292: opi_dbi_run_log_curr rlc,
293: gme_resource_txns rtran,
294: sy_uoms_mst ruom,
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,

Line 513: cr_rsrc_dtl resdtl,

509: opi_dbi_jobs_f job,
510: gme_batch_header bhdr,
511: gme_batch_steps bstep,
512: gme_batch_step_resources bres,
513: cr_rsrc_dtl resdtl,
514: cr_rsrc_mst_b resmst,
515: sy_orgn_mst_b o,
516: gl_plcy_mst pol,
517: sy_uoms_mst bresuom,

Line 682: cr_rsrc_dtl rdtl,

678: whse.mtl_organization_id organization_id,
679: ravail.shift_date,
680: SUM((ravail.to_time - ravail.from_time)/3600) shift_hours
681: FROM
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,

Line 821: cr_rsrc_dtl rdtl,

817: SUM(rtran.resource_usage * prod.cost_alloc * hruom.std_factor / ruom.std_factor) actual_qty_g,
818: pol.gl_cost_mthd cost_mthd_code,
819: pol.co_code co_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,

Line 1051: cr_rsrc_dtl resdtl,

1047: opi_dbi_jobs_f job,
1048: gme_batch_header bhdr,
1049: gme_batch_steps bstep,
1050: gme_batch_step_resources bres,
1051: cr_rsrc_dtl resdtl,
1052: cr_rsrc_mst_b resmst,
1053: sy_orgn_mst_b o,
1054: gl_plcy_mst pol,
1055: sy_uoms_mst bresuom,