eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_UI_PROJECT_LOVS dependencies on PO_DISTRIBUTIONS_ALL

Line 46: FROM po_distributions_all pod,

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 )

Line 67: FROM po_distributions_all pod,

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 )

Line 87: FROM po_distributions_all pod

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))

Line 135: FROM po_distributions_all pod,

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

Line 165: FROM po_distributions_all pod,

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

Line 194: FROM po_distributions_all pod,

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 )

Line 245: FROM po_distributions_all pod,

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

Line 273: FROM po_distributions_all pod,

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

Line 300: FROM po_distributions_all pod,

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 )