eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_RES_PKG dependencies on SY_UOMS_MST

Line 24: g_hr_uom sy_uoms_mst_v.um_code%TYPE;

20: g_global_rate_type VARCHAR2(15);
21: g_secondary_currency_code VARCHAR2(10);
22: g_secondary_rate_type VARCHAR2 (15);
23:
24: g_hr_uom sy_uoms_mst_v.um_code%TYPE;
25:
26:
27: /*========================================
28: Package Level Constants

Line 1221: FROM sy_uoms_mst hruom,

1217: rtran.doc_id job_id,
1218: 4 job_type,
1219: prod.inventory_item_id assembly_item_id,
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,

Line 1222: sy_uoms_mst ruom,

1218: 4 job_type,
1219: prod.inventory_item_id assembly_item_id,
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,

Line 1392: sy_uoms_mst_v ruom,

1388: FROM gmf_period_statuses period
1389: WHERE period.end_date >= p_start_date
1390: AND period.start_date <= p_end_date
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)

Line 1393: sy_uoms_mst_v rcostuom,

1389: WHERE period.end_date >= p_start_date
1390: AND period.start_date <= p_end_date
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

Line 1394: sy_uoms_mst_v hruom,

1390: AND period.start_date <= p_end_date
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

Line 1490: FROM sy_uoms_mst hruom,

1486: rtran.doc_id job_id,
1487: 4 job_type,
1488: prod.inventory_item_id assembly_item_id,
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,

Line 1491: sy_uoms_mst ruom,

1487: 4 job_type,
1488: prod.inventory_item_id assembly_item_id,
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,

Line 1687: sy_uoms_mst_v ruom,

1683: FROM gmf_period_statuses period
1684: WHERE period.end_date >= l_start_date
1685: AND period.start_date <= l_end_date
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)

Line 1688: sy_uoms_mst_v rcostuom,

1684: WHERE period.end_date >= l_start_date
1685: AND period.start_date <= l_end_date
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

Line 1689: sy_uoms_mst_v hruom,

1685: AND period.start_date <= l_end_date
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

Line 1858: sy_uoms_mst_v bresuom,

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,
1860: sy_uoms_mst_v hruom,
1861: org_organization_definitions org_def,
1862: cm_mthd_mst cmm

Line 1859: sy_uoms_mst_v ruom,

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,
1860: sy_uoms_mst_v hruom,
1861: org_organization_definitions org_def,
1862: cm_mthd_mst cmm
1863: WHERE

Line 1860: sy_uoms_mst_v hruom,

1856: cr_rsrc_mst_b resmst,
1857: gmf_fiscal_policies pol,
1858: sy_uoms_mst_v bresuom,
1859: sy_uoms_mst_v ruom,
1860: sy_uoms_mst_v hruom,
1861: org_organization_definitions org_def,
1862: cm_mthd_mst cmm
1863: WHERE
1864: job.std_res_flag = 1

Line 1890: sy_uoms_mst_v jobres_uom,

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
1894: AND cal.cost_type_id in (jobres.cost_type_id, jobres.default_lot_cost_type_id)

Line 1891: sy_uoms_mst_v rescost_uom

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
1894: AND cal.cost_type_id in (jobres.cost_type_id, jobres.default_lot_cost_type_id)
1895: AND cal.legal_entity_id = jobres.legal_entity_id

Line 2083: sy_uoms_mst_v bresuom,

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,
2085: sy_uoms_mst_v hruom,
2086: org_organization_definitions org_def,
2087: cm_mthd_mst cmm

Line 2084: sy_uoms_mst_v ruom,

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,
2085: sy_uoms_mst_v hruom,
2086: org_organization_definitions org_def,
2087: cm_mthd_mst cmm
2088: WHERE

Line 2085: sy_uoms_mst_v hruom,

2081: cr_rsrc_mst_b resmst,
2082: gmf_fiscal_policies pol,
2083: sy_uoms_mst_v bresuom,
2084: sy_uoms_mst_v ruom,
2085: sy_uoms_mst_v hruom,
2086: org_organization_definitions org_def,
2087: cm_mthd_mst cmm
2088: WHERE
2089: job.std_res_flag = 1

Line 2115: sy_uoms_mst_v jobres_uom,

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
2119: AND jobres.assembly_item_id = jobitem.assembly_item_id

Line 2116: sy_uoms_mst_v rescost_uom

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
2119: AND jobres.assembly_item_id = jobitem.assembly_item_id
2120: AND cal.cost_type_id in (jobres.cost_type_id, jobres.default_lot_cost_type_id)