DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 1562: from po_lines_archive_all pol

1558: -- Bug 8818198. Modified cursor to pick lines, which are not cancelled.
1559: -- Bug 9060324. Modified cursor to pick only the open lines.
1560: cursor ga_line_csr(p_po_header_id in number) is
1561: select po_line_id
1562: from po_lines_archive_all pol
1563: where pol.po_header_id = p_po_header_id and
1564: pol.latest_external_flag='Y' and
1565: nvl(pol.closed_code,'OPEN') not in ('FINALLY CLOSED') and
1566: nvl(pol.cancel_flag,'N') <> 'Y' and