APPS.INV_UI_PROJECT_LOVS dependencies on PO_LINES_ALL

Line 55: FROM po_lines_all pol

51: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
52: AND ( p_item_id IS NULL
53: OR pod.po_line_id IN (
54: SELECT pol.po_line_id
55: FROM po_lines_all pol
56: WHERE pol.item_id = p_item_id
57: AND pol.po_header_id = p_po_header_id
58: )
59: )

Line 76: FROM po_lines_all pol

72: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
73: AND ( p_item_id IS NULL
74: OR pod.po_line_id IN (
75: SELECT pol.po_line_id
76: FROM po_lines_all pol
77: WHERE pol.item_id = p_item_id
78: AND pol.po_header_id = p_po_header_id
79: )
80: )

Line 93: FROM po_lines_all pol

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))
92: AND (p_item_id IS NULL OR pod.po_line_id IN ( SELECT pol.po_line_id
93: FROM po_lines_all pol
94: WHERE pol.item_id = p_item_id
95: AND pol.po_header_id=p_po_header_id)
96: )
97: AND l_no_proj_str LIKE ( p_project_number ) ;

Line 175: FROM po_lines_all pol /* bug 6785303 po_lines -> po_lines_all */

171: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))
172: AND ( p_item_id IS NULL
173: OR pod.po_line_id IN (
174: SELECT pol.po_line_id
175: FROM po_lines_all pol /* bug 6785303 po_lines -> po_lines_all */
176: WHERE pol.item_id = p_item_id
177: AND pol.po_header_id = p_po_header_id
178: )
179: )