DBA Data[Home] [Help]

APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 3487: po_lines_archive_all pla,

3483: -- Cursor for checking the acknowledgement status of the shipment
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

Line 3512: po_lines_archive_all pla,

3508: -- Cursor for checking the acknowledgement status of the shipment
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'