APPS.PJM_SCHED_INT_WF dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 74: , hr_all_organization_units_tl hou

70: , fnd_lookup_values ml1
71: , fnd_lookup_values ml2
72: , pa_projects_all pp
73: , pa_tasks pt
74: , hr_all_organization_units_tl hou
75: , mtl_item_flexfields mif
76: where wdj.project_id > 0
77: and wdj.status_type not in (4,5,7,12)
78: and we.wip_entity_id = wdj.wip_entity_id

Line 164: , hr_all_organization_units_tl hou

160: ) exception_days2
161: , ool.project_id project_id
162: , ool.task_id task_id
163: from oe_order_lines_all ool
164: , hr_all_organization_units_tl hou
165: , oe_order_headers_all ooh
166: , mtl_item_flexfields mif
167: , pa_projects_all pp
168: , pa_tasks pt

Line 251: , hr_all_organization_units_tl hou

247: ) exception_days2
248: , mfd.project_id project_id
249: , mfd.task_id task_id
250: from mrp_forecast_dates mfd
251: , hr_all_organization_units_tl hou
252: , mtl_item_flexfields mif
253: , pa_projects_all pp
254: , pa_tasks pt
255: , mrp_forecast_designators mfdes

Line 333: , hr_all_organization_units_tl hou

329: , po_requisition_headers_all prh
330: , mtl_item_flexfields mif
331: , pa_projects_all pp
332: , pa_tasks pt
333: , hr_all_organization_units_tl hou
334: , financials_system_params_all fsp
335: where prd.project_id > 0
336: and prd.requisition_line_id = prl.requisition_line_id
337: and prh.requisition_header_id = prl.requisition_header_id

Line 564: , hr_all_organization_units_tl hou

560: ) exception_days2
561: , msd.project_id project_id
562: , msd.task_id task_id
563: from mrp_schedule_dates msd
564: , hr_all_organization_units_tl hou
565: , mtl_item_flexfields mif
566: , pa_projects_all pp
567: , pa_tasks pt
568: where msd.project_id > 0

Line 651: , hr_all_organization_units_tl hou

647: ) exception_days2
648: , msd.project_id project_id
649: , msd.task_id task_id
650: from mrp_schedule_dates msd
651: , hr_all_organization_units_tl hou
652: , mtl_item_flexfields mif
653: , pa_projects_all pp
654: , pa_tasks pt
655: where msd.project_id > 0

Line 745: , hr_all_organization_units_tl hou

741: , po_headers_all ph
742: , mtl_item_flexfields mif
743: , pa_projects_all pp
744: , pa_tasks pt
745: , hr_all_organization_units_tl hou
746: , financials_system_params_all fsp
747: where pd.project_id > 0
748: and pd.po_release_id is null
749: and pll.line_location_id = pd.line_location_id

Line 845: , hr_all_organization_units_tl hou

841: , po_headers_all ph
842: , mtl_item_flexfields mif
843: , pa_projects_all pp
844: , pa_tasks pt
845: , hr_all_organization_units_tl hou
846: , financials_system_params_all fsp
847: where pd.project_id > 0
848: and pd.po_release_id is not null
849: and pr.po_release_id = pd.po_release_id