[Home] [Help]
656: -- Define cursor for selecting approved POs with acceptance required
657:
658: /* Bug# 1595348: kagarwal
659: ** Desc: If the PO/Rel is accepted using Web Supplier Portal, the acceptance
660: ** is registered in the PO Acceptances table. Hence we need to check the PO
661: ** Acceptances table also.
662: */
663: -- Bug 5074128(forward fix4772820)
664: -- poh.acceptance_required_flag can be Y or D
673: AND NVL(poh.cancel_flag,'N') = 'N'
674: AND NVL(poh.closed_code,'OPEN') <> 'FINALLY CLOSED'
675: AND not exists (
676: SELECT poa.ACCEPTANCE_ID
677: FROM PO_ACCEPTANCES poa
678: WHERE NVL(poa.accepted_flag, 'N') = 'Y'
679: AND poa.po_header_id = poh.po_header_id
680: AND nvl(poa.revision_num,0) = nvl(poh.revision_num,0));
681:
993: -- Define cursor for selecting approved releases with acceptance required
994:
995: /* Bug# 1595348: kagarwal
996: ** Desc: If the PO/Rel is accepted using Web Supplier Portal, the acceptance
997: ** is registered in the PO Acceptances table. Hence we need to check the PO
998: ** Acceptances table also.
999: */
1000:
1001: /* Bug# 2633688: kagarwal
999: */
1000:
1001: /* Bug# 2633688: kagarwal
1002: ** Desc: When accepting releases from ISP, the po header id is
1003: ** left null in the po acceptances table (See Bug 2188005) hence
1004: ** removing the condition 'poa.po_header_id = poh.po_header_id'
1005: */
1006:
1007:
1017: AND NVL(PORH.closed_code,'OPEN') <> 'FINALLY CLOSED'
1018: AND POH.PO_HEADER_ID = PORH.PO_HEADER_ID
1019: AND not exists (
1020: SELECT poa.ACCEPTANCE_ID
1021: FROM PO_ACCEPTANCES poa
1022: WHERE NVL(poa.accepted_flag, 'N') = 'Y'
1023: /* AND poa.po_header_id = poh.po_header_id */
1024: AND porh.po_release_id = poa.po_release_id
1025: AND nvl(poa.revision_num,0) = nvl(porh.revision_num,0));