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.PO_DOCUMENT_REVISION_GRP dependencies on PO_DISTRIBUTIONS

Line 1452: FROM PO_DISTRIBUTIONS POD,

1448: INTO x_different
1449: from sys.dual
1450: where exists(
1451: select null
1452: FROM PO_DISTRIBUTIONS POD,
1453: PO_DISTRIBUTIONS_ARCHIVE PODA,
1454: PO_LINE_LOCATIONS POLL --Bug 13960467
1455: WHERE POD.po_header_id = p_doc_id
1456: AND (POD.line_location_id = POLL.line_location_id) --Bug 13960467

Line 1453: PO_DISTRIBUTIONS_ARCHIVE PODA,

1449: from sys.dual
1450: where exists(
1451: select null
1452: FROM PO_DISTRIBUTIONS POD,
1453: PO_DISTRIBUTIONS_ARCHIVE PODA,
1454: PO_LINE_LOCATIONS POLL --Bug 13960467
1455: WHERE POD.po_header_id = p_doc_id
1456: AND (POD.line_location_id = POLL.line_location_id) --Bug 13960467
1457: AND (p_line_id IS NULL OR POD.po_line_id = p_line_id) --

Line 1659: FROM PO_DISTRIBUTIONS POD,

1655: INTO x_different
1656: from sys.dual
1657: where exists(
1658: select null
1659: FROM PO_DISTRIBUTIONS POD,
1660: PO_DISTRIBUTIONS_ARCHIVE PODA
1661: WHERE POD.po_release_id = p_doc_id
1662: AND (p_line_location_id IS NULL OR POD.line_location_id = p_line_location_id) --
1663: AND POD.po_distribution_id =

Line 1660: PO_DISTRIBUTIONS_ARCHIVE PODA

1656: from sys.dual
1657: where exists(
1658: select null
1659: FROM PO_DISTRIBUTIONS POD,
1660: PO_DISTRIBUTIONS_ARCHIVE PODA
1661: WHERE POD.po_release_id = p_doc_id
1662: AND (p_line_location_id IS NULL OR POD.line_location_id = p_line_location_id) --
1663: AND POD.po_distribution_id =
1664: PODA.po_distribution_id (+)

Line 2122: -- Throw an error if the encumbered flag at PO distributions is N for

2118:
2119: BEGIN
2120:
2121: -- <13503748: Edit without unreserve ER >
2122: -- Throw an error if the encumbered flag at PO distributions is N for
2123: -- encumbered enabled environment else give warning
2124:
2125: --Query encumbrance flags from FINANCIALS_SYSTEM_PARAMS
2126: --Using this flag to stop revert changes as part of cancel when encumbrance

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 2218: FROM po_distributions_archive_all poad

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))
2220: UNION ALL
2221: SELECT line_location_id
2222: FROM po_line_locations_all

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 2235: FROM po_distributions_archive_all poad

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))
2237:
2238:
2239: UNION ALL

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 2255: FROM po_distributions_archive_all poad

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))
2257:
2258:
2259:

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 2276: FROM po_distributions_archive_all poad

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)));
2278:
2279: x_msg_type :='W';
2280:

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 2315: FROM po_distributions_archive_all poad

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)
2317: )
2318: ))
2319:

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'

Line 2330: po_distributions_archive_all poad

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'
2334: AND (Nvl(poad.encumbered_amount,0)<>Nvl(pod.encumbered_amount,0)