APPS.OPI_DBI_RES_OPM_PKG dependencies on CM_RSRC_DTL

Line 192: cm_rsrc_dtl rcost,

188: hdr.calendar_code = dtl.calendar_code
189: AND dtl.end_date >= g_global_start_date
190: AND dtl.start_date <= sysdate
191: ) cal,
192: cm_rsrc_dtl rcost,
193: sy_uoms_mst rcostuom,
194: sy_uoms_mst hruom
195: WHERE
196: r.cost_mthd_code = cal.cost_mthd_code

Line 354: cm_rsrc_dtl rcost

350: AND hdr.calendar_code = dtl.calendar_code
351: AND dtl.end_date >= g_global_start_date
352: AND dtl.start_date <= sysdate
353: ) cal,
354: cm_rsrc_dtl rcost
355: WHERE
356: r.co_code = cal.co_code
357: AND r.cost_mthd_code = cal.cost_mthd_code
358: AND r.transaction_date BETWEEN cal.start_date AND cal.end_date

Line 550: cm_rsrc_dtl rescost,

546: hdr.calendar_code = dtl.calendar_code
547: AND dtl.end_date >= g_global_start_date
548: AND dtl.start_date <= sysdate
549: ) cal,
550: cm_rsrc_dtl rescost,
551: sy_uoms_mst jobres_uom,
552: sy_uoms_mst rescost_uom
553: WHERE
554: jobres.job_id = jobitem.job_id -- combine all batch resources with all batch coproducts

Line 724: cm_rsrc_dtl rcost

720: hdr.calendar_code = dtl.calendar_code
721: AND dtl.end_date >= g_global_start_date
722: AND dtl.start_date <= sysdate
723: ) cal,
724: cm_rsrc_dtl rcost
725: WHERE
726: r.cost_mthd_code = cal.cost_mthd_code
727: AND r.shift_date BETWEEN cal.start_date AND cal.end_date
728: AND rcost.orgn_code = r.orgn_code

Line 884: cm_rsrc_dtl rcost

880: AND hdr.calendar_code = dtl.calendar_code
881: AND dtl.end_date >= g_global_start_date
882: AND dtl.start_date <= sysdate
883: ) cal,
884: cm_rsrc_dtl rcost
885: WHERE
886: r.co_code = cal.co_code
887: AND r.cost_mthd_code = cal.cost_mthd_code
888: AND r.transaction_date BETWEEN cal.start_date AND cal.end_date

Line 1088: cm_rsrc_dtl rescost,

1084: hdr.calendar_code = dtl.calendar_code
1085: AND dtl.end_date >= g_global_start_date
1086: AND dtl.start_date <= sysdate
1087: ) cal,
1088: cm_rsrc_dtl rescost,
1089: sy_uoms_mst jobres_uom,
1090: sy_uoms_mst rescost_uom
1091: WHERE
1092: jobres.job_id = jobitem.job_id -- combine all batch resources with all batch coproducts