APPS.JAI_TAX_PROCESSING_PKG dependencies on AP_INVOICE_LINES_ALL

Line 165: cursor c_get_inv_line(cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE,

161: and RMA_LINE_ID = cp_line_id;
162: --Added by Zhiwei.xin for ZX integration of OM part end.
163:
164: --Added by Junjian for ZX integration of Invoice lines discard begin
165: cursor c_get_inv_line(cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE,
166: cp_line_id AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE)
167: is
168: select * from AP_INVOICE_LINES_ALL
169: where invoice_id = cp_invoice_id

Line 166: cp_line_id AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE)

162: --Added by Zhiwei.xin for ZX integration of OM part end.
163:
164: --Added by Junjian for ZX integration of Invoice lines discard begin
165: cursor c_get_inv_line(cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE,
166: cp_line_id AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE)
167: is
168: select * from AP_INVOICE_LINES_ALL
169: where invoice_id = cp_invoice_id
170: and line_number= cp_line_id;

Line 168: select * from AP_INVOICE_LINES_ALL

164: --Added by Junjian for ZX integration of Invoice lines discard begin
165: cursor c_get_inv_line(cp_invoice_id AP_INVOICE_LINES_ALL.INVOICE_ID%TYPE,
166: cp_line_id AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE)
167: is
168: select * from AP_INVOICE_LINES_ALL
169: where invoice_id = cp_invoice_id
170: and line_number= cp_line_id;
171:
172: t_ap_inv_line_rec c_get_inv_line%rowtype;

Line 1563: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt

1559: AND jrd.regime_code = jai_constants.service_regime;
1560:
1561: CURSOR get_match_item_cur IS
1562: SELECT line.match_type,line.line_number
1563: FROM ap_invoice_lines_all line, jai_ap_match_inv_taxes jamt
1564: WHERE line.invoice_id = pr_rec.invoice_id
1565: and jamt.invoice_id=line.invoice_id
1566: and jamt.invoice_distribution_id=pr_rec.invoice_distribution_id
1567: and jamt.po_distribution_id=pr_rec.po_distribution_id

Line 1600: FROM po_line_locations_all po,ap_invoice_lines_all ap

1596: AND parent_invoice_line_number IS NULL;
1597:
1598: CURSOR get_po_matched_org_cur(pn_line_number NUMBER) IS
1599: SELECT po.ship_to_organization_id, po.ship_to_location_id
1600: FROM po_line_locations_all po,ap_invoice_lines_all ap
1601: WHERE po.line_location_id = ap.po_line_location_id
1602: AND ap.invoice_id = pr_rec.invoice_id
1603: AND ap.line_number = pn_line_number;
1604:

Line 1607: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap

1603: AND ap.line_number = pn_line_number;
1604:
1605: CURSOR get_rcpt_matched_org_cur(pn_line_number NUMBER) IS
1606: SELECT rcv.organization_id, rcv.location_id
1607: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap
1608: WHERE ap.rcv_transaction_id = rcv.transaction_id
1609: AND ap.invoice_id = pr_rec.invoice_id
1610: AND ap.line_number = pn_line_number;
1611:

Line 1995: from ap_invoice_lines_all ail

1991: -- cursor to get PO/RCV match invoice line detail
1992: cursor c_get_inv_lines(cp_invoice_id ap_invoices_all.INVOICE_ID%TYPE)
1993: IS
1994: select ail.*
1995: from ap_invoice_lines_all ail
1996: where ail.invoice_id = cp_invoice_id
1997: and ail.match_type in ('ITEM_TO_RECEIPT', 'ITEM_TO_PO', 'PO_PRICE_ADJUSTMENT')
1998: and ail.discarded_flag = 'N';
1999:

Line 2024: from ap_invoice_lines_all

2020: and jpr.vendor_id = cp_vendor_id;
2021:
2022: cursor c_get_total_line_amount(cp_trx_id ap_invoices_all.INVOICE_ID%TYPE) is
2023: select sum(nvl(amount,0))
2024: from ap_invoice_lines_all
2025: where invoice_id=cp_trx_id
2026: and line_type_lookup_code in ('ITEM', 'MISCELLANEOUS', 'FREIGHT') --Added by Chong for bug#16743694 2013/05/07
2027: ;
2028:

Line 2031: inv_line_rec AP_INVOICE_LINES_ALL%ROWTYPE;

2027: ;
2028:
2029: ln_parent_inv_payment_priority jai_ap_tds_thhold_trxs.parent_inv_payment_priority%type;
2030: inv_rec AP_INVOICES_ALL%ROWTYPE;
2031: inv_line_rec AP_INVOICE_LINES_ALL%ROWTYPE;
2032: inv_dist_rec AP_INVOICE_DISTRIBUTIONS_ALL%ROWTYPE;
2033: inv_ps_rec AP_PAYMENT_SCHEDULES%ROWTYPE;
2034: lv_action VARCHAR2(100);
2035: lv_return_code VARCHAR2(100);