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_OPM_PKG dependencies on SY_UOMS_MST

Line 15: g_hr_uom sy_uoms_mst.um_code%TYPE;

11: g_degree NUMBER := 1;
12: g_ok NUMBER(1) := 0;
13: g_warning NUMBER(1) := 1;
14: g_error NUMBER(1) := -1;
15: g_hr_uom sy_uoms_mst.um_code%TYPE;
16:
17: /*
18: PROCEDURE put_line(p_msg VARCHAR2)
19: IS

Line 176: sy_uoms_mst ruom,

172: pol.gl_cost_mthd,
173: whse.mtl_organization_id,
174: ravail.shift_date
175: ) r,
176: sy_uoms_mst ruom,
177: (
178: SELECT
179: hdr.cost_mthd_code,
180: dtl.calendar_code,

Line 193: sy_uoms_mst rcostuom,

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
197: AND r.shift_date BETWEEN cal.start_date AND cal.end_date

Line 194: sy_uoms_mst hruom

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
197: AND r.shift_date BETWEEN cal.start_date AND cal.end_date
198: AND rcost.orgn_code = r.orgn_code

Line 291: sy_uoms_mst hruom,

287: SUM(rtran.resource_usage * prod.cost_alloc * hruom.std_factor / ruom.std_factor) actual_qty_g,
288: pol.gl_cost_mthd cost_mthd_code,
289: pol.co_code co_code
290: FROM
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,

Line 294: sy_uoms_mst ruom,

290: FROM
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,

Line 517: sy_uoms_mst bresuom,

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,
518: sy_uoms_mst ruom,
519: sy_uoms_mst hruom
520: WHERE
521: job.std_res_flag = 1

Line 518: sy_uoms_mst ruom,

514: cr_rsrc_mst_b resmst,
515: sy_orgn_mst_b o,
516: gl_plcy_mst pol,
517: sy_uoms_mst bresuom,
518: sy_uoms_mst ruom,
519: sy_uoms_mst hruom
520: WHERE
521: job.std_res_flag = 1
522: AND job.job_type = 4

Line 519: sy_uoms_mst hruom

515: sy_orgn_mst_b o,
516: gl_plcy_mst pol,
517: sy_uoms_mst bresuom,
518: sy_uoms_mst ruom,
519: sy_uoms_mst hruom
520: WHERE
521: job.std_res_flag = 1
522: AND job.job_type = 4
523: AND bhdr.batch_id = job.job_id

Line 551: sy_uoms_mst jobres_uom,

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

Line 552: sy_uoms_mst rescost_uom

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
555: AND jobres.assembly_item_id = jobitem.assembly_item_id
556: AND cal.cost_mthd_code = jobres.gl_cost_mthd

Line 666: sy_uoms_mst hruom,

662: g_user_id created_by,
663: g_user_id last_updated_by,
664: g_login_id last_update_login
665: FROM
666: sy_uoms_mst hruom,
667: sy_uoms_mst ruom,
668: sy_uoms_mst rcostuom,
669: (
670: SELECT

Line 667: sy_uoms_mst ruom,

663: g_user_id last_updated_by,
664: g_login_id last_update_login
665: FROM
666: sy_uoms_mst hruom,
667: sy_uoms_mst ruom,
668: sy_uoms_mst rcostuom,
669: (
670: SELECT
671: rdtl.orgn_code,

Line 668: sy_uoms_mst rcostuom,

664: g_login_id last_update_login
665: FROM
666: sy_uoms_mst hruom,
667: sy_uoms_mst ruom,
668: sy_uoms_mst rcostuom,
669: (
670: SELECT
671: rdtl.orgn_code,
672: rdtl.resources,

Line 831: sy_uoms_mst hruom,

827: ic_item_mst_b item,
828: mtl_system_items_b msi,
829: gl_plcy_mst pol,
830: opi_dbi_run_log_curr rlc,
831: sy_uoms_mst hruom,
832: sy_uoms_mst ruom
833: WHERE
834: rlc.etl_id = 4
835: AND rlc.source = 2

Line 832: sy_uoms_mst ruom

828: mtl_system_items_b msi,
829: gl_plcy_mst pol,
830: opi_dbi_run_log_curr rlc,
831: sy_uoms_mst hruom,
832: sy_uoms_mst ruom
833: WHERE
834: rlc.etl_id = 4
835: AND rlc.source = 2
836: AND rtran.poc_trans_id >= rlc.start_txn_id

Line 1055: sy_uoms_mst bresuom,

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,
1056: sy_uoms_mst ruom,
1057: sy_uoms_mst hruom
1058: WHERE
1059: job.std_res_flag = 1

Line 1056: sy_uoms_mst ruom,

1052: cr_rsrc_mst_b resmst,
1053: sy_orgn_mst_b o,
1054: gl_plcy_mst pol,
1055: sy_uoms_mst bresuom,
1056: sy_uoms_mst ruom,
1057: sy_uoms_mst hruom
1058: WHERE
1059: job.std_res_flag = 1
1060: AND job.job_type = 4

Line 1057: sy_uoms_mst hruom

1053: sy_orgn_mst_b o,
1054: gl_plcy_mst pol,
1055: sy_uoms_mst bresuom,
1056: sy_uoms_mst ruom,
1057: sy_uoms_mst hruom
1058: WHERE
1059: job.std_res_flag = 1
1060: AND job.job_type = 4
1061: AND bhdr.batch_id = job.job_id

Line 1089: sy_uoms_mst jobres_uom,

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

Line 1090: sy_uoms_mst rescost_uom

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
1093: AND jobres.assembly_item_id = jobitem.assembly_item_id
1094: AND cal.cost_mthd_code = jobres.gl_cost_mthd