DBA Data[Home] [Help]

APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_LINES_ARCHIVE_ALL

Line 3375: po_lines_archive_all pla,

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

Line 3400: po_lines_archive_all pla,

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