APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 2189: po_line_locations_archive_all poall,

2185: x_token_name_tbl(5),
2186: x_token_value_tbl(5)
2187:
2188: FROM
2189: po_line_locations_archive_all poall,
2190: po_line_locations_all poll,
2191: po_headers_all poh,
2192: po_lines_all pol,
2193: po_distributions_all pod -----

Line 2229: FROM po_line_locations_archive_all poall

2225: AND 0= (SELECT Count(1)
2226: FROM po_line_locations_all poll
2227: WHERE po_line_id=p_line_id
2228: AND NOT EXISTS (SELECT line_location_id
2229: FROM po_line_locations_archive_all poall
2230: WHERE poll.line_location_id=poall.line_location_id))
2231: AND 0= (SELECT Count(1)
2232: FROM po_distributions_all pod
2233: WHERE pod.po_line_id=p_line_id

Line 2249: FROM po_line_locations_archive_all poall

2245: AND 0= (SELECT Count(1)
2246: FROM po_line_locations_all poll
2247: WHERE po_header_id = p_doc_id
2248: AND NOT EXISTS (SELECT line_location_id
2249: FROM po_line_locations_archive_all poall
2250: WHERE poll.line_location_id=poall.line_location_id))
2251: AND 0= (SELECT Count(1)
2252: FROM po_distributions_all pod
2253: WHERE pod.po_header_id=p_doc_id

Line 2270: FROM po_line_locations_archive_all poall

2266: AND 0= (SELECT Count(1)
2267: FROM po_line_locations_all poll
2268: WHERE po_release_id = p_doc_id
2269: AND NOT EXISTS (SELECT line_location_id
2270: FROM po_line_locations_archive_all poall
2271: WHERE poll.line_location_id=poall.line_location_id))
2272: AND 0= (SELECT Count(1)
2273: FROM po_distributions_all pod
2274: WHERE pod.po_release_id=p_doc_id

Line 2309: FROM po_line_locations_archive_all poall

2305: AND (l_po_encumbrance_flag = 'Y' AND pod.encumbered_flag = 'N')
2306: -----
2307: AND Nvl(poll.approved_flag,'N') <>'Y'
2308: AND ((NOT EXISTS (SELECT 'Archive Exists'
2309: FROM po_line_locations_archive_all poall
2310: WHERE poll.line_location_id=poall.line_location_id)
2311: OR (0 <> (SELECT Count(1)
2312: FROM po_distributions_all pod
2313: WHERE pod.line_location_id=poll.line_location_id

Line 2322: FROM po_line_locations_archive_all poall

2318: ))
2319:
2320: OR(l_po_encumbrance_flag = 'Y'
2321: AND (EXISTS (SELECT 'Enc Columns Changed'
2322: FROM po_line_locations_archive_all poall
2323: WHERE poll.line_location_id=poall.line_location_id
2324: AND poall.latest_external_flag ='Y'
2325: AND (nvl(poll.price_override,0) <> Nvl(poall.price_override,0)
2326: OR Nvl(poll.quantity,0) <> Nvl(poall.quantity,0)