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 MTL_PARAMETERS

Line 327: mtl_parameters mp,

323: C_EURO_MISSING_AT_START, G_EURO_START_DATE,
324: conv.transaction_date) transaction_date,
325: conv.f_currency_code func_currency_code
326: FROM opi_dbi_res_conv_rates conv,
327: mtl_parameters mp,
328: (
329: SELECT /*+ parallel (opi_dbi_res_actual_stg) */
330: DISTINCT
331: organization_id,

Line 358: mtl_parameters mp,

354: C_EURO_MISSING_AT_START, G_EURO_START_DATE,
355: conv.transaction_date) transaction_date_date,
356: conv.f_currency_code func_currency_code
357: FROM opi_dbi_res_conv_rates conv,
358: mtl_parameters mp,
359: (
360: SELECT /*+ parallel (opi_dbi_res_actual_stg) */
361: DISTINCT
362: organization_id,

Line 612: mtl_parameters mp,

608: FROM bom_resources br,
609: bom_departments bd,
610: bom_department_resources bdr,
611: bom_calendar_dates bcd,
612: mtl_parameters mp,
613: mtl_uom_conversions m,
614: mtl_uom_conversions m2,
615: cst_resource_costs crc
616: WHERE bdr.available_24_hours_flag = 1 -- 24 hr available

Line 687: mtl_parameters mp,

683: bom_department_resources bdr,
684: bom_resource_shifts brs,
685: bom_shift_dates bsd,
686: bom_shift_times bst,
687: mtl_parameters mp,
688: mtl_uom_conversions m,
689: mtl_uom_conversions m2,
690: cst_resource_costs crc
691: WHERE bdr.available_24_hours_flag = 2 -- shift based

Line 923: mtl_parameters mp,

919: FROM bom_resources br,
920: bom_departments bd,
921: bom_department_resources bdr,
922: bom_calendar_dates bcd,
923: mtl_parameters mp,
924: mtl_uom_conversions m,
925: mtl_uom_conversions m2,
926: cst_resource_costs crc
927: WHERE bdr.available_24_hours_flag = 1 -- 24 hr available

Line 996: mtl_parameters mp,

992: bom_department_resources bdr,
993: bom_resource_shifts brs,
994: bom_shift_dates bsd,
995: bom_shift_times bst,
996: mtl_parameters mp,
997: mtl_uom_conversions m,
998: mtl_uom_conversions m2,
999: cst_resource_costs crc
1000: WHERE bdr.available_24_hours_flag = 2 -- shift based

Line 1355: mtl_parameters mp,

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,
1357: org_organization_definitions org_def,
1358: cm_mthd_mst cmm
1359: WHERE rmst.resources = rdtl.resources

Line 1651: mtl_parameters mp,

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,
1652: org_organization_definitions org_def,
1653: cm_mthd_mst cmm
1654: WHERE rmst.resources = rdtl.resources
1655: AND rdtl.organization_id = org_def.organization_id

Line 2811: mtl_parameters mp,

2807: FROM wip_operation_resources wor,
2808: wip_operations wo,
2809: opi_dbi_jobs_f job,
2810: bom_resources br,
2811: mtl_parameters mp,
2812: mtl_uom_conversions m,
2813: mtl_uom_conversions m2,
2814: cst_resource_costs crc,
2815: bom_department_resources bdr

Line 3706: mtl_parameters mp,

3702: FROM wip_operation_resources wor,
3703: wip_operations wo,
3704: opi_dbi_jobs_f job,
3705: bom_resources br,
3706: mtl_parameters mp,
3707: mtl_uom_conversions m,
3708: mtl_uom_conversions m2,
3709: cst_resource_costs crc,
3710: bom_department_resources bdr