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_UOM_CONVERSIONS

Line 613: mtl_uom_conversions m,

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
617: AND bdr.share_from_dept_id IS NULL -- owing dept

Line 614: mtl_uom_conversions m2,

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
617: AND bdr.share_from_dept_id IS NULL -- owing dept
618: AND br.resource_id = bdr.resource_id

Line 688: mtl_uom_conversions m,

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
692: AND bdr.share_from_dept_id IS NULL -- owning dept

Line 689: mtl_uom_conversions m2,

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
692: AND bdr.share_from_dept_id IS NULL -- owning dept
693: AND br.resource_id = bdr.resource_id

Line 801: mtl_uom_conversions m,

797: wt.primary_item_id assembly_item_id
798: FROM wip_transactions wt,
799: wip_transaction_accounts wta,
800: wip_entities we,
801: mtl_uom_conversions m,
802: mtl_uom_conversions m2,
803: opi_dbi_run_log_curr rlc,
804: bom_department_resources bdr
805: WHERE

Line 802: mtl_uom_conversions m2,

798: FROM wip_transactions wt,
799: wip_transaction_accounts wta,
800: wip_entities we,
801: mtl_uom_conversions m,
802: mtl_uom_conversions m2,
803: opi_dbi_run_log_curr rlc,
804: bom_department_resources bdr
805: WHERE
806: -- 1->resource trx 3-> outside processing,

Line 924: mtl_uom_conversions m,

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
928: AND bdr.share_from_dept_id IS NULL -- owing dept

Line 925: mtl_uom_conversions m2,

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
928: AND bdr.share_from_dept_id IS NULL -- owing dept
929: AND br.resource_id = bdr.resource_id

Line 997: mtl_uom_conversions m,

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
1001: AND bdr.share_from_dept_id IS NULL -- owning dept

Line 998: mtl_uom_conversions m2,

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
1001: AND bdr.share_from_dept_id IS NULL -- owning dept
1002: AND br.resource_id = bdr.resource_id

Line 1114: mtl_uom_conversions m,

1110: wip_transaction_accounts wta,
1111: wip_entities we,
1112: opi_dbi_run_log_curr rlc,
1113: bom_department_resources bdr,
1114: mtl_uom_conversions m,
1115: mtl_uom_conversions m2
1116: WHERE
1117: -- 1->resource trx 3-> outside processing,
1118: -- both involve resource, other types don't have resource_id

Line 1115: mtl_uom_conversions m2

1111: wip_entities we,
1112: opi_dbi_run_log_curr rlc,
1113: bom_department_resources bdr,
1114: mtl_uom_conversions m,
1115: mtl_uom_conversions m2
1116: WHERE
1117: -- 1->resource trx 3-> outside processing,
1118: -- both involve resource, other types don't have resource_id
1119: Rlc.etl_id = ACTUAL_RES_ETL

Line 2812: mtl_uom_conversions m,

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
2816: WHERE job.job_type IN (1,2,5) -- Discrete and Repetitive also OSFM

Line 2813: mtl_uom_conversions m2,

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
2816: WHERE job.job_type IN (1,2,5) -- Discrete and Repetitive also OSFM
2817: AND job.std_res_flag = 1

Line 3707: mtl_uom_conversions m,

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
3711: WHERE job.job_type IN (1,2,5) -- Discrete and Repetitive also OSFM

Line 3708: mtl_uom_conversions m2,

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
3711: WHERE job.job_type IN (1,2,5) -- Discrete and Repetitive also OSFM
3712: AND job.std_res_flag = 1