APPS.OPI_DBI_RES_PKG dependencies on CM_RSRC_DTL

Line 1395: cm_rsrc_dtl rcost

1391: ) cal,
1392: sy_uoms_mst_v ruom,
1393: sy_uoms_mst_v rcostuom,
1394: sy_uoms_mst_v hruom,
1395: cm_rsrc_dtl rcost
1396: WHERE cal.cost_type_id in (r.cost_type_id, r.default_lot_cost_type_id)
1397: AND r.legal_entity_id = cal.legal_entity_id
1398: AND r.shift_date BETWEEN cal.start_date AND cal.end_date
1399: AND rcost.organization_id = r.organization_id

Line 1690: cm_rsrc_dtl rcost

1686: ) cal,
1687: sy_uoms_mst_v ruom,
1688: sy_uoms_mst_v rcostuom,
1689: sy_uoms_mst_v hruom,
1690: cm_rsrc_dtl rcost
1691: WHERE cal.cost_type_id in (r.cost_type_id, r.default_lot_cost_type_id)
1692: AND r.legal_entity_id = cal.legal_entity_id
1693: AND r.shift_date BETWEEN cal.start_date AND cal.end_date
1694: AND rcost.organization_id = r.organization_id

Line 1889: cm_rsrc_dtl rescost,

1885: FROM gmf_period_statuses period
1886: WHERE period.end_date >= g_global_start_date
1887: AND period.start_date <= sysdate
1888: ) cal,
1889: cm_rsrc_dtl rescost,
1890: sy_uoms_mst_v jobres_uom,
1891: sy_uoms_mst_v rescost_uom
1892: WHERE jobres.job_id = jobitem.job_id -- combine all batch resources with all batch coproducts
1893: AND jobres.assembly_item_id = jobitem.assembly_item_id

Line 2114: cm_rsrc_dtl rescost,

2110: FROM gmf_period_statuses period
2111: WHERE period.end_date >= g_global_start_date
2112: AND period.start_date <= sysdate
2113: ) cal,
2114: cm_rsrc_dtl rescost,
2115: sy_uoms_mst_v jobres_uom,
2116: sy_uoms_mst_v rescost_uom
2117: WHERE
2118: jobres.job_id = jobitem.job_id -- combine all batch resources with all batch coproducts