APPS.OPI_DBI_RES_PKG dependencies on CR_RSRC_DTL

Line 1224: cr_rsrc_dtl rdtl,

1220: rmst.resource_class department_id
1221: FROM sy_uoms_mst hruom,
1222: sy_uoms_mst ruom,
1223: gme_resource_txns rtran,
1224: cr_rsrc_dtl rdtl,
1225: cr_rsrc_mst_b rmst,
1226: gme_material_details prod,
1227: (
1228: SELECT gtv.transaction_id,

Line 1352: FROM cr_rsrc_dtl rdtl,

1348: cmm.default_lot_cost_type_id,
1349: pol.legal_entity_id,
1350: ravail.shift_date,
1351: sum((ravail.to_time - ravail.from_time)*ravail.resource_units/3600) shift_hours
1352: FROM cr_rsrc_dtl rdtl,
1353: cr_rsrc_mst_b rmst,
1354: gmf_fiscal_policies pol,
1355: mtl_parameters mp,
1356: gmp_resource_avail ravail,

Line 1493: cr_rsrc_dtl rdtl,

1489: rmst.resource_class department_id
1490: FROM sy_uoms_mst hruom,
1491: sy_uoms_mst ruom,
1492: gme_resource_txns rtran,
1493: cr_rsrc_dtl rdtl,
1494: cr_rsrc_mst_b rmst,
1495: gme_material_details prod,
1496: (
1497: SELECT gtv.transaction_id,

Line 1647: FROM cr_rsrc_dtl rdtl,

1643: cmm.default_lot_cost_type_id,
1644: pol.legal_entity_id,
1645: ravail.shift_date,
1646: SUM((ravail.to_time - ravail.from_time)*ravail.resource_units/3600) shift_hours
1647: FROM cr_rsrc_dtl rdtl,
1648: cr_rsrc_mst_b rmst,
1649: gmf_fiscal_policies pol,
1650: gmp_resource_avail ravail,
1651: mtl_parameters mp,

Line 1855: cr_rsrc_dtl resdtl,

1851: FROM opi_dbi_jobs_f job,
1852: gme_batch_header bhdr,
1853: gme_batch_steps bstep,
1854: gme_batch_step_resources bres,
1855: cr_rsrc_dtl resdtl,
1856: cr_rsrc_mst_b resmst,
1857: gmf_fiscal_policies pol,
1858: sy_uoms_mst_v bresuom,
1859: sy_uoms_mst_v ruom,

Line 2080: cr_rsrc_dtl resdtl,

2076: opi_dbi_jobs_f job,
2077: gme_batch_header bhdr,
2078: gme_batch_steps bstep,
2079: gme_batch_step_resources bres,
2080: cr_rsrc_dtl resdtl,
2081: cr_rsrc_mst_b resmst,
2082: gmf_fiscal_policies pol,
2083: sy_uoms_mst_v bresuom,
2084: sy_uoms_mst_v ruom,