[Home] [Help]
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
79: and ml1.view_application_id = 700
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
169: where ool.project_id > 0
170: and nvl(ool.cancelled_flag,'N') <> 'Y'
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
256: where mfd.project_id > 0
326: , prd.task_id task_id
327: from po_requisition_lines_all prl
328: , po_req_distributions_all prd
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
394: from po_lines_all pl
395: , po_headers_all ph
396: , po_lookup_codes plc
397: , hr_locations hl
398: , mtl_item_flexfields mif
399: , pa_projects_all pp
400: , pa_tasks pt
401: , financials_system_params_all fsp
402: where pl.project_id > 0
471: from po_lines_all pl
472: , po_headers_all ph
473: , po_lookup_codes plc
474: , hr_locations hl
475: , mtl_item_flexfields mif
476: , pa_projects_all pp
477: , pa_tasks pt
478: , financials_system_params_all fsp
479: where pl.project_id > 0
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
569: and nvl(decode(mif.repetitive_planning_flag,
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
656: and nvl(decode(mif.repetitive_planning_flag,
738: from po_distributions_all pd
739: , po_line_locations_all pll
740: , po_lines_all pl
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
838: , po_releases_all pr
839: , po_line_locations_all pll
840: , po_lines_all pl
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