[Home] [Help]
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
77: and wdj.status_type not in (4,5,7,12)
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'
172: and nvl(ool.shipped_quantity,0)+nvl(ool.cancelled_quantity,0) < ool.ordered_quantity
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
258: and mif.organization_id = mfd.organization_id
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
336: and prd.requisition_line_id = prl.requisition_line_id
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
404: and ph.type_lookup_code = 'RFQ'
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
481: and ph.type_lookup_code = 'QUOTATION'
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
571: ,msd.schedule_quantity),0) <>0
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
658: ,msd.schedule_quantity),0) <>0
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
748: and pd.po_release_id is null
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
848: and pd.po_release_id is not null