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
619: AND m.inventory_item_id = 0
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
694: AND m.inventory_item_id = 0
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
930: AND m.inventory_item_id = 0
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
1003: AND m.inventory_item_id = 0
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
2818: AND job.source = 1
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
3713: AND wor.organization_id = job.organization_id