[Home] [Help]
68: from wip_discrete_jobs wdj
69: , wip_entities we
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
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'
171: and nvl(ool.open_flag,'Y') <> 'N'
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
257: and nvl(mfd.current_forecast_quantity,0) <>0
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
335: where prd.project_id > 0
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
403: and ph.po_header_id = pl.po_header_id
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
480: and ph.po_header_id = pl.po_header_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,
570: 'Y',msd.repetitive_daily_rate
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,
657: 'Y',msd.repetitive_daily_rate
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
747: where pd.project_id > 0
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
847: where pd.project_id > 0