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_LINE_LOCATIONS_ALL

Line 1416: po_line_locations_all poll

1412: SELECT 'Y'
1413: INTO x_different
1414: FROM po_price_differentials pdf,
1415: po_price_differentials_archive pdfa,
1416: po_line_locations_all poll
1417: WHERE poll.po_header_id = p_doc_id
1418: AND poll.line_location_id = pdf.entity_id
1419: AND pdf.entity_type = 'PRICE BREAK'
1420: AND pdf.price_differential_id = pdfa.price_differential_id (+)

Line 2190: po_line_locations_all poll,

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 -----
2194: WHERE

Line 2211: FROM po_line_locations_all

2207: OR Nvl(poll.promised_date,sysdate) <> Nvl(poall.promised_date,sysdate)
2208: OR Nvl(poll.need_by_date,sysdate) <> Nvl(poall.need_by_date,sysdate))
2209: AND poll.line_location_id IN
2210: ( SELECT line_location_id
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

Line 2222: FROM po_line_locations_all

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
2223: WHERE po_line_id = p_line_id
2224: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_LINE
2225: AND 0= (SELECT Count(1)
2226: FROM po_line_locations_all poll

Line 2226: FROM po_line_locations_all poll

2222: FROM po_line_locations_all
2223: WHERE po_line_id = p_line_id
2224: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_LINE
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))

Line 2241: FROM po_line_locations_all

2237:
2238:
2239: UNION ALL
2240: SELECT line_location_id
2241: FROM po_line_locations_all
2242: WHERE po_header_id = p_doc_id
2243: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2244: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2245: AND 0= (SELECT Count(1)

Line 2246: FROM po_line_locations_all poll

2242: WHERE po_header_id = p_doc_id
2243: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2244: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
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))

Line 2262: FROM po_line_locations_all

2258:
2259:
2260: UNION ALL
2261: SELECT line_location_id
2262: FROM po_line_locations_all
2263: WHERE po_release_id = p_doc_id
2264: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2265: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2266: AND 0= (SELECT Count(1)

Line 2267: FROM po_line_locations_all poll

2263: WHERE po_release_id = p_doc_id
2264: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2265: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
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))

Line 2302: FROM po_line_locations_all poll,

2298: -- Or if the encumbrance is On and any of the enc. related field is modified
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: -----

Line 2346: FROM po_line_locations_all

2342: )
2343: AND ROWNUM<2
2344: AND poll.line_location_id IN
2345: ( SELECT line_location_id
2346: FROM po_line_locations_all
2347: WHERE line_location_id = p_line_location_id
2348: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_SHIPMENT
2349: UNION ALL
2350: SELECT line_location_id

Line 2351: FROM po_line_locations_all

2347: WHERE line_location_id = p_line_location_id
2348: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_SHIPMENT
2349: UNION ALL
2350: SELECT line_location_id
2351: FROM po_line_locations_all
2352: WHERE po_line_id = p_line_id
2353: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_LINE
2354: UNION ALL
2355: SELECT line_location_id

Line 2356: FROM po_line_locations_all

2352: WHERE po_line_id = p_line_id
2353: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_LINE
2354: UNION ALL
2355: SELECT line_location_id
2356: FROM po_line_locations_all
2357: WHERE po_header_id = p_doc_id
2358: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2359: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2360: UNION ALL

Line 2362: FROM po_line_locations_all

2358: AND p_doc_type <> PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2359: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER
2360: UNION ALL
2361: SELECT line_location_id
2362: FROM po_line_locations_all
2363: WHERE po_release_id = p_doc_id
2364: AND p_doc_type = PO_DOCUMENT_CANCEL_PVT.c_doc_type_RELEASE
2365: AND p_action_level = PO_DOCUMENT_CANCEL_PVT.c_entity_level_HEADER);
2366: x_msg_type :='E';