DBA Data[Home] [Help]

APPS.INV_UI_PROJECT_LOVS dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 352: FROM po_req_distributions_all prd,

348: OPEN x_projects FOR
349: SELECT DISTINCT p.project_id,
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

Line 381: FROM po_req_distributions_all prd,

377: OPEN x_projects FOR
378: SELECT DISTINCT p.project_id,
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

Line 409: FROM po_req_distributions_all prd,

405: UNION ALL
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