APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL

Line 3376: po_line_locations_archive_all plla

3372: cursor c_sco_ack_rej_ship(p_po_header_id_csr IN NUMBER, c_revision_num IN NUMBER) is
3373: SELECT count(1)
3374: FROM po_acceptances pa,
3375: po_lines_archive_all pla,
3376: po_line_locations_archive_all plla
3377: WHERE plla.po_header_id = p_po_header_id_csr
3378: AND pa.accepted_flag = 'N'
3379: AND plla.po_line_id = pla.po_line_id
3380: AND pa.po_line_location_id = plla.line_location_id

Line 3383: FROM po_line_locations_archive_all plla2

3379: AND plla.po_line_id = pla.po_line_id
3380: AND pa.po_line_location_id = plla.line_location_id
3381: AND pa.revision_num = c_revision_num
3382: AND plla.revision_num = (SELECT max(plla2.revision_num)
3383: FROM po_line_locations_archive_all plla2
3384: WHERE plla2.line_location_id = plla.line_location_id
3385: AND plla.revision_num <= c_revision_num);
3386:
3387:

Line 3401: po_line_locations_archive_all plla

3397: 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
3398: SELECT count(1)
3399: FROM po_acceptances pa,
3400: po_lines_archive_all pla,
3401: po_line_locations_archive_all plla
3402: WHERE plla.po_header_id = p_po_header_id_csr
3403: AND pa.po_release_id = p_po_release_id_csr
3404: AND pa.accepted_flag = 'N'
3405: AND plla.po_release_id = pa.po_release_id

Line 3410: FROM po_line_locations_archive_all plla2

3406: AND plla.po_line_id = pla.po_line_id
3407: AND pa.po_line_location_id = plla.line_location_id
3408: AND pa.revision_num = c_revision_num
3409: AND plla.revision_num = (SELECT max(plla2.revision_num)
3410: FROM po_line_locations_archive_all plla2
3411: WHERE plla2.line_location_id = plla.line_location_id
3412: AND plla.revision_num <= c_revision_num);
3413:
3414: -- Cursor for checking whether the signature is required or not