APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 3488: po_line_locations_archive_all plla

3484: cursor c_sco_ack_rej_ship(p_po_header_id_csr IN NUMBER, c_revision_num IN NUMBER) is
3485: SELECT count(1)
3486: FROM po_acceptances pa,
3487: po_lines_archive_all pla,
3488: po_line_locations_archive_all plla
3489: WHERE plla.po_header_id = p_po_header_id_csr
3490: AND pa.accepted_flag = 'N'
3491: AND plla.po_line_id = pla.po_line_id
3492: AND pa.po_line_location_id = plla.line_location_id

Line 3495: FROM po_line_locations_archive_all plla2

3491: AND plla.po_line_id = pla.po_line_id
3492: AND pa.po_line_location_id = plla.line_location_id
3493: AND pa.revision_num = c_revision_num
3494: AND plla.revision_num = (SELECT max(plla2.revision_num)
3495: FROM po_line_locations_archive_all plla2
3496: WHERE plla2.line_location_id = plla.line_location_id
3497: AND plla.revision_num <= c_revision_num);
3498:
3499:

Line 3513: po_line_locations_archive_all plla

3509: cursor c_sco_ack_rej_ship_rel(p_po_header_id_csr IN NUMBER, c_revision_num IN NUMBER, p_po_release_id_csr IN NUMBER ) is
3510: SELECT count(1)
3511: FROM po_acceptances pa,
3512: po_lines_archive_all pla,
3513: po_line_locations_archive_all plla
3514: WHERE plla.po_header_id = p_po_header_id_csr
3515: AND pa.po_release_id = p_po_release_id_csr
3516: AND pa.accepted_flag = 'N'
3517: AND plla.po_release_id = pa.po_release_id

Line 3522: FROM po_line_locations_archive_all plla2

3518: AND plla.po_line_id = pla.po_line_id
3519: AND pa.po_line_location_id = plla.line_location_id
3520: AND pa.revision_num = c_revision_num
3521: AND plla.revision_num = (SELECT max(plla2.revision_num)
3522: FROM po_line_locations_archive_all plla2
3523: WHERE plla2.line_location_id = plla.line_location_id
3524: AND plla.revision_num <= c_revision_num);
3525:
3526: -- Cursor for checking whether the signature is required or not