APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_ACCEPTANCES

Line 3374: FROM po_acceptances pa,

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

Line 3399: FROM po_acceptances pa,

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

Line 3423: FROM po_acceptances

3419: WHERE po_header_id = p_po_header_id_csr;
3420: */
3421: cursor c_sgn_req_flag_po(p_po_header_id_csr IN NUMBER,c_revision_num IN NUMBER ) IS
3422: SELECT count(1)
3423: FROM po_acceptances
3424: WHERE po_header_id = p_po_header_id_csr
3425: and revision_num=c_revision_num
3426: and signature_flag='Y';
3427: /*

Line 3430: FROM po_acceptances

3426: and signature_flag='Y';
3427: /*
3428: cursor c_sgn_req_flag_rel(p_po_release_id_csr IN NUMBER, c_revision_num IN NUMBER) IS
3429: SELECT count(1)
3430: FROM po_acceptances
3431: WHERE po_release_id =p_po_release_id_csr
3432: and revision_num=c_revision_num
3433: and signature_flag='Y';
3434: */