APPS.PO_CREATE_SR_ASL dependencies on PO_LINES_ARCHIVE

Line 164: FROM po_lines_archive pla

160: AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'
161: AND nvl(pl.cancel_flag,'N') = 'N'
162: AND NOT EXISTS
163: (SELECT 'Line included in Prior Revision'
164: FROM po_lines_archive pla
165: WHERE pla.po_line_id = pl.po_line_id
166: AND pla.revision_num < ph.revision_num)
167: AND pl.line_num > x_prev_line_num
168: ORDER BY ph.po_header_id, pl.line_num;

Line 629: FROM po_lines_archive pla

625: AND nvl(pl.closed_code,'OPEN') <> 'FINALLY CLOSED'
626: AND nvl(pl.cancel_flag,'N') = 'N'
627: /* AND NOT EXISTS
628: (SELECT 'Line included in Prior Revision'
629: FROM po_lines_archive pla
630: WHERE pla.po_line_id = pl.po_line_id
631: AND pla.revision_num < ph.revision_num)*/
632: AND pl.line_num > l_previous_line_num
633: AND NVL(pl.expiration_date ,sysdate+1) >= sysdate ---Bug 10022351,10192008

Line 779: po_lines_archive_all pola,

775: -- SQL Join: po_header_id
776: SELECT max(pola.line_num)
777: INTO l_previous_line_num
778: FROM
779: po_lines_archive_all pola,
780: po_headers_all poh
781: WHERE
782: poh.po_header_id=p_document_id
783: AND pola.po_header_id=poh.po_header_id