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 1214: FROM PO_RELEASES_ALL

1210: -- retrieve the vendor and vendor site id
1211: BEGIN
1212: SELECT po_header_id
1213: INTO l_po_header_id
1214: FROM PO_RELEASES_ALL
1215: WHERE po_release_id = l_document_id;
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12764: OR EXISTS (select null from po_releases_all h

12760: AND (h.closed_code is NULL or h.closed_code NOT IN ('FINALLY CLOSED'))
12761: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')))
12762: AND (p_release_id(i) IS NULL
12763: --Case 2: PO Release is specified
12764: OR EXISTS (select null from po_releases_all h
12765: WHERE h.po_release_id = p_release_id(i)
12766: AND (h.authorization_status is NULL
12767: OR h.authorization_status NOT IN ('PRE-APPROVED', 'IN PROCESS'))
12768: AND (h.cancel_flag is null or h.cancel_flag <> 'Y')

Line 12992: OR EXISTS (select null from po_releases_all h

12988: AND (h.user_hold_flag is NULL or h.user_hold_flag <> 'Y')))
12989: AND (p_release_id(i) IS NULL
12990: --Case 2: PO Release is specified
12991: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
12992: OR EXISTS (select null from po_releases_all h
12993: WHERE h.po_release_id = p_release_id(i)
12994: AND (h.authorization_status is NULL
12995: OR h.authorization_status NOT IN ('APPROVED'))
12996: AND (h.closed_code is NULL or h.closed_code <> 'FINALLY CLOSED')

Line 13163: OR EXISTS (select null from po_releases_all h

13159: AND (h.user_hold_flag is NULL or h.user_hold_flag <> 'Y')))
13160: AND (p_release_id(i) IS NULL
13161: --Case 2: PO Release is specified
13162: -- Bug 3407980: Modified closed_code condition so that it only discards 'FINALLY CLOSED'
13163: OR EXISTS (select null from po_releases_all h
13164: WHERE h.po_release_id = p_release_id(i)
13165: AND (h.closed_code is NULL or h.closed_code <> 'FINALLY CLOSED')
13166: AND (h.frozen_flag is NULL or h.frozen_flag <> 'Y')
13167: AND (h.hold_flag is NULL or h.hold_flag <> 'Y')))

Line 13331: FROM po_releases_all h

13327: ' ' dummy, ' ' dummy, ' ' dummy,
13328: NVL(authorization_status, 'INCOMPLETE'), nvl(approved_flag, 'N'),
13329: nvl(closed_code, 'OPEN'), NVL(cancel_flag, 'N'),
13330: NVL(frozen_flag, 'N'), NVL(hold_flag, 'N'), l_sequence(i)
13331: FROM po_releases_all h
13332: WHERE h.po_release_id = p_release_id(i)
13333: ;
13334:
13335: --IF line ID present at an index, overwrite the status fields with Line Level status