42: OPEN x_projects FOR
43: SELECT DISTINCT p.project_id,
44: p.project_number,
45: p.project_name
46: FROM po_distributions_all pod,
47: pjm_projects_mtll_v p
48: WHERE pod.project_id = p.project_id
49: AND pod.po_header_id = p_po_header_id
50: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
63: OPEN x_projects FOR
64: SELECT DISTINCT p.project_id,
65: p.project_number,
66: p.project_name
67: FROM po_distributions_all pod,
68: pjm_projects_mtll_v p
69: WHERE pod.project_id = p.project_id
70: AND pod.po_header_id = p_po_header_id
71: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
83: UNION ALL
84: SELECT DISTINCT -9999 project_id,
85: l_no_proj_str project_number,
86: l_no_proj_str project_name
87: FROM po_distributions_all pod
88: WHERE pod.project_id is NULL
89: AND pod.po_header_id = p_po_header_id
90: AND pod.po_line_id = NVL (p_po_line_id ,POD.PO_LINE_ID )
91: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
131: OPEN x_projects FOR
132: SELECT DISTINCT p.project_id,
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
161: OPEN x_projects FOR
162: SELECT DISTINCT p.project_id,
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
190: UNION ALL
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 )
241: OPEN x_projects FOR
242: SELECT DISTINCT p.project_id,
243: p.project_number,
244: p.project_name
245: FROM po_distributions_all pod,
246: pjm_projects_mtll_v p,
247: rcv_shipment_lines rsl
248: WHERE pod.project_id IS NOT NULL
249: AND pod.po_header_id = rsl.po_header_id
269: OPEN x_projects FOR
270: SELECT DISTINCT p.project_id,
271: p.project_number,
272: p.project_name
273: FROM po_distributions_all pod,
274: pjm_projects_mtll_v p,
275: rcv_shipment_lines rsl
276: WHERE pod.project_id IS NOT NULL
277: AND pod.po_header_id = rsl.po_header_id
296: UNION ALL
297: SELECT DISTINCT -9999 project_id,
298: l_no_proj_str project_number,
299: l_no_proj_str project_name
300: FROM po_distributions_all pod,
301: rcv_shipment_lines rsl
302: WHERE pod.project_id IS NULL
303: AND pod.po_header_id = rsl.po_header_id
304: AND pod.po_header_id = NVL ( p_po_header_id, pod.po_header_id )