[Home] [Help]
668: -- Define cursor for selecting approved POs with acceptance required
669:
670: /* Bug# 1595348: kagarwal
671: ** Desc: If the PO/Rel is accepted using Web Supplier Portal, the acceptance
672: ** is registered in the PO Acceptances table. Hence we need to check the PO
673: ** Acceptances table also.
674: */
675: -- Bug 5074128(forward fix4772820)
676: -- poh.acceptance_required_flag can be Y or D
685: AND NVL(poh.cancel_flag,'N') = 'N'
686: AND NVL(poh.closed_code,'OPEN') <> 'FINALLY CLOSED'
687: AND not exists (
688: SELECT poa.ACCEPTANCE_ID
689: FROM PO_ACCEPTANCES poa
690: WHERE NVL(poa.accepted_flag, 'N') = 'Y'
691: AND poa.po_header_id = poh.po_header_id
692: AND nvl(poa.revision_num,0) = nvl(poh.revision_num,0));
693:
1022: -- Define cursor for selecting approved releases with acceptance required
1023:
1024: /* Bug# 1595348: kagarwal
1025: ** Desc: If the PO/Rel is accepted using Web Supplier Portal, the acceptance
1026: ** is registered in the PO Acceptances table. Hence we need to check the PO
1027: ** Acceptances table also.
1028: */
1029:
1030: /* Bug# 2633688: kagarwal
1028: */
1029:
1030: /* Bug# 2633688: kagarwal
1031: ** Desc: When accepting releases from ISP, the po header id is
1032: ** left null in the po acceptances table (See Bug 2188005) hence
1033: ** removing the condition 'poa.po_header_id = poh.po_header_id'
1034: */
1035:
1036:
1046: AND NVL(PORH.closed_code,'OPEN') <> 'FINALLY CLOSED'
1047: AND POH.PO_HEADER_ID = PORH.PO_HEADER_ID
1048: AND not exists (
1049: SELECT poa.ACCEPTANCE_ID
1050: FROM PO_ACCEPTANCES poa
1051: WHERE NVL(poa.accepted_flag, 'N') = 'Y'
1052: /* AND poa.po_header_id = poh.po_header_id */
1053: AND porh.po_release_id = poa.po_release_id
1054: AND nvl(poa.revision_num,0) = nvl(porh.revision_num,0));