APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_ACCEPTANCES

Line 3486: FROM po_acceptances pa,

3482:
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'

Line 3511: FROM po_acceptances pa,

3507:
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

Line 3535: FROM po_acceptances

3531: WHERE po_header_id = p_po_header_id_csr;
3532: */
3533: cursor c_sgn_req_flag_po(p_po_header_id_csr IN NUMBER,c_revision_num IN NUMBER ) IS
3534: SELECT count(1)
3535: FROM po_acceptances
3536: WHERE po_header_id = p_po_header_id_csr
3537: and revision_num=c_revision_num
3538: and signature_flag='Y';
3539: /*

Line 3542: FROM po_acceptances

3538: and signature_flag='Y';
3539: /*
3540: cursor c_sgn_req_flag_rel(p_po_release_id_csr IN NUMBER, c_revision_num IN NUMBER) IS
3541: SELECT count(1)
3542: FROM po_acceptances
3543: WHERE po_release_id =p_po_release_id_csr
3544: and revision_num=c_revision_num
3545: and signature_flag='Y';
3546: */