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_CHECKS_PVT dependencies on PO_RELEASES_ALL

Line 3000: FROM PO_RELEASES_ALL

2996: -- retrieve the vendor and vendor site id
2997: BEGIN
2998: SELECT po_header_id
2999: INTO l_po_header_id
3000: FROM PO_RELEASES_ALL
3001: WHERE po_release_id = l_document_id;
3002: EXCEPTION
3003: WHEN OTHERS THEN
3004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4857: FROM po_line_locations_archive_all PLL2, po_releases_all POR2, PO_HEADERS_GT POH

4853: - nvl(PLL2.quantity_cancelled,0) )
4854: * PLL2.price_override ) ) )
4855: , 0 )
4856: INTO l_previous_rel_archive_amount
4857: FROM po_line_locations_archive_all PLL2, po_releases_all POR2, PO_HEADERS_GT POH
4858: WHERE PLL2.po_release_id = POR2.po_release_id
4859: AND POR2.po_header_id = POH.po_header_id
4860: AND nvl(POR2.approved_flag, 'N') IN ('R','F')
4861: and NVL(PLL2.LATEST_EXTERNAL_FLAG,'N') = 'Y'

Line 16283: OR EXISTS (select null from po_releases_all h

16279: AND (h.closed_code is NULL or h.closed_code NOT IN ('FINALLY CLOSED'))
16280: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')))
16281: AND (p_release_id(i) IS NULL
16282: --Case 2: PO Release is specified
16283: OR EXISTS (select null from po_releases_all h
16284: WHERE h.po_release_id = p_release_id(i)
16285: AND (h.authorization_status is NULL
16286: OR h.authorization_status NOT IN ('PRE-APPROVED', 'IN PROCESS'))
16287: AND (h.cancel_flag is null or h.cancel_flag <> 'Y')

Line 16516: OR EXISTS (select null from po_releases_all h

16512: AND (h.user_hold_flag is NULL or h.user_hold_flag <> 'Y')))
16513: AND (p_release_id(i) IS NULL
16514: --Case 2: PO Release is specified
16515: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
16516: OR EXISTS (select null from po_releases_all h
16517: WHERE h.po_release_id = p_release_id(i)
16518: AND (h.authorization_status is NULL
16519: OR h.authorization_status NOT IN ('APPROVED'))
16520: AND (h.closed_code is NULL or h.closed_code <> 'FINALLY CLOSED')

Line 16687: OR EXISTS (select null from po_releases_all h

16683: AND (h.user_hold_flag is NULL or h.user_hold_flag <> 'Y')))
16684: AND (p_release_id(i) IS NULL
16685: --Case 2: PO Release is specified
16686: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
16687: OR EXISTS (select null from po_releases_all h
16688: WHERE h.po_release_id = p_release_id(i)
16689: AND (h.closed_code is NULL or h.closed_code <> 'FINALLY CLOSED')
16690: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')
16691: AND (h.hold_flag is NULL or h.hold_flag <> 'Y')))

Line 16855: FROM po_releases_all h

16851: ' ' dummy, ' ' dummy, ' ' dummy,
16852: NVL(authorization_status, 'INCOMPLETE'), nvl(approved_flag, 'N'),
16853: nvl(closed_code, 'OPEN'), NVL(cancel_flag, 'N'),
16854: NVL(frozen_flag, 'N'), NVL(hold_flag, 'N'), l_sequence(i)
16855: FROM po_releases_all h
16856: WHERE h.po_release_id = p_release_id(i)
16857: ;
16858:
16859: --IF line ID present at an index, overwrite the status fields with Line Level status