APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_DISTRIBUTIONS_ALL

Line 2193: po_distributions_all pod -----

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 -----
2194: WHERE
2195: poll.line_location_id = pod.line_location_id -----
2196: AND poll.po_line_id = pol.po_line_id
2197: AND poll.po_header_id = pol.po_header_id

Line 2215: FROM po_distributions_all pod

2211: FROM po_line_locations_all
2212: WHERE line_location_id = p_line_location_id
2213: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_SHIPMENT
2214: AND 0= (SELECT Count(1)
2215: FROM po_distributions_all pod
2216: WHERE pod.line_location_id=p_line_location_id
2217: AND NOT EXISTS (SELECT po_distribution_id
2218: FROM po_distributions_archive_all poad
2219: WHERE pod.po_distribution_id=poad.po_distribution_id))

Line 2232: FROM po_distributions_all pod

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
2234: AND NOT EXISTS (SELECT po_distribution_id
2235: FROM po_distributions_archive_all poad
2236: WHERE pod.po_distribution_id=poad.po_distribution_id))

Line 2252: FROM po_distributions_all pod

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
2254: AND NOT EXISTS (SELECT po_distribution_id
2255: FROM po_distributions_archive_all poad
2256: WHERE pod.po_distribution_id=poad.po_distribution_id))

Line 2273: FROM po_distributions_all pod

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
2275: AND NOT EXISTS (SELECT po_distribution_id
2276: FROM po_distributions_archive_all poad
2277: WHERE pod.po_distribution_id=poad.po_distribution_id)));

Line 2303: po_distributions_all pod -----

2299: -- then do not allow cancel action , ask user to undo the changes
2300: SELECT 'PO_CHANGED_CANT_CANCEL'
2301: INTO x_msg_name
2302: FROM po_line_locations_all poll,
2303: po_distributions_all pod -----
2304: WHERE poll.line_location_id = pod.line_location_id
2305: AND (l_po_encumbrance_flag = 'Y' AND pod.encumbered_flag = 'N')
2306: -----
2307: AND Nvl(poll.approved_flag,'N') <>'Y'

Line 2312: FROM po_distributions_all pod

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
2314: AND NOT EXISTS (SELECT po_distribution_id
2315: FROM po_distributions_archive_all poad
2316: WHERE pod.po_distribution_id=poad.po_distribution_id)

Line 2329: FROM po_distributions_all pod,

2325: AND (nvl(poll.price_override,0) <> Nvl(poall.price_override,0)
2326: OR Nvl(poll.quantity,0) <> Nvl(poall.quantity,0)
2327: OR Nvl(poll.amount,0) <> Nvl(poall.amount,0)))
2328: OR EXISTS (SELECT 'Enc Amount Changed'
2329: FROM po_distributions_all pod,
2330: po_distributions_archive_all poad
2331: WHERE pod.po_distribution_id=poad.po_distribution_id
2332: AND pod.line_location_id=poll.line_location_id
2333: AND poad.latest_external_flag ='Y'