APPS.INV_UI_PROJECT_LOVS dependencies on PO_LINE_LOCATIONS_ALL

Line 137: po_line_locations_all poll

133: p.project_number,
134: p.project_name
135: FROM po_distributions_all pod,
136: pjm_projects_mtll_v p,
137: po_line_locations_all poll
138: WHERE pod.project_id = p.project_id
139: AND pod.po_header_id = p_po_header_id
140: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
141: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))

Line 167: po_line_locations_all poll

163: p.project_number,
164: p.project_name
165: FROM po_distributions_all pod,
166: pjm_projects_mtll_v p,
167: po_line_locations_all poll
168: WHERE pod.project_id = p.project_id
169: AND pod.po_header_id = p_po_header_id
170: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
171: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))

Line 195: po_line_locations_all poll

191: SELECT DISTINCT -9999 project_id,
192: l_no_proj_str project_number,
193: l_no_proj_str project_name
194: FROM po_distributions_all pod,
195: po_line_locations_all poll
196: WHERE pod.project_id is NULL
197: AND pod.po_header_id = p_po_header_id
198: AND pod.po_line_id = NVL (p_po_line_id ,POD.PO_LINE_ID )
199: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))