DBA Data[Home] [Help]

APPS.INV_UI_PROJECT_LOVS dependencies on PO_REQUISITION_LINES_ALL

Line 354: po_requisition_lines_all prl

350: p.project_number,
351: p.project_name
352: FROM po_req_distributions_all prd,
353: pjm_projects_mtll_v p,
354: po_requisition_lines_all prl
355: WHERE prd.project_id IS NOT NULL
356: AND prd.project_id = p.project_id
357: AND prd.requisition_line_id = prl.requisition_line_id
358: AND prl.requisition_header_id = p_req_header_id

Line 383: po_requisition_lines_all prl

379: p.project_number,
380: p.project_name
381: FROM po_req_distributions_all prd,
382: pjm_projects_mtll_v p,
383: po_requisition_lines_all prl
384: WHERE prd.project_id IS NOT NULL
385: AND prd.project_id = p.project_id
386: AND prd.requisition_line_id = prl.requisition_line_id
387: AND prl.requisition_header_id = p_req_header_id

Line 410: po_requisition_lines_all prl

406: SELECT DISTINCT -9999 project_id,
407: l_no_proj_str project_number,
408: l_no_proj_str project_name
409: FROM po_req_distributions_all prd,
410: po_requisition_lines_all prl
411: WHERE prd.project_id IS NULL
412: AND prd.requisition_line_id = prl.requisition_line_id
413: AND prl.requisition_header_id = p_req_header_id
414: AND l_no_proj_str LIKE ( p_project_number )