[Home] [Help]
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
338: and nvl(prh.closed_code,'OPEN') not like '%CLOSED%'
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'
405: and ph.status_lookup_code <> 'C'
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'
482: and ph.status_lookup_code <> 'C'
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
750: and pl.po_line_id = pll.po_line_id
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
850: and pll.line_location_id = pd.line_location_id