APPS.JAI_CMN_REVERSE_CHARGE_PKG dependencies on AP_INVOICE_LINES_ALL

Line 678: FROM ap_invoice_lines_all ap_line,

674: ap_dist.invoice_id,
675: abs(ap_dist.amount) tax_amt,
676: tax.tax_rate,
677: tax.tax_type
678: FROM ap_invoice_lines_all ap_line,
679: ap_invoice_distributions_all ap_dist,
680: jai_cmn_taxes_all tax
681: WHERE ap_line.invoice_id = ap_dist.invoice_id
682: AND ap_dist.invoice_distribution_id = pn_distribution_id

Line 1233: FROM AP_INVOICE_LINES_ALL ap_line,

1229:
1230: lv_flag VARCHAR2(1) := 'N';
1231: CURSOR c_reverse_charge_flag IS
1232: SELECT 'Y'
1233: FROM AP_INVOICE_LINES_ALL ap_line,
1234: AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,
1235: JAI_CMN_TAXES_ALL tax
1236: WHERE ap_line.invoice_id = ap_dist.invoice_id
1237: AND ap_dist.invoice_distribution_id = pn_distribution_id

Line 1281: FROM AP_INVOICE_LINES_ALL ap_line,

1277: PRAGMA AUTONOMOUS_TRANSACTION;
1278: lv_flag VARCHAR2(1) := 'N';
1279: CURSOR c_reverse_charge_flag IS
1280: SELECT 'Y'
1281: FROM AP_INVOICE_LINES_ALL ap_line,
1282: AP_INVOICE_DISTRIBUTIONS_ALL ap_dist,
1283: JAI_CMN_TAXES_ALL tax
1284: WHERE ap_line.invoice_id = ap_dist.invoice_id
1285: AND ap_dist.invoice_distribution_id = pn_distribution_id

Line 1400: FROM ap_invoice_lines_all line

1396: p_organization_id OUT NOCOPY NUMBER,
1397: p_location_id OUT NOCOPY NUMBER) IS
1398: CURSOR get_match_item_cur IS
1399: SELECT line.match_type, line.line_number
1400: FROM ap_invoice_lines_all line
1401: WHERE line.invoice_id = p_invoice_id
1402: AND line.po_distribution_id = line.po_distribution_id
1403: AND line.line_type_lookup_code = 'ITEM'
1404: AND line.match_type IS NOT NULL;

Line 1419: FROM po_line_locations_all po, ap_invoice_lines_all ap

1415: AND parent_invoice_line_number IS NULL;
1416:
1417: CURSOR get_po_matched_org_cur(pn_line_number NUMBER) IS
1418: SELECT po.ship_to_organization_id, po.ship_to_location_id
1419: FROM po_line_locations_all po, ap_invoice_lines_all ap
1420: WHERE po.line_location_id = ap.po_line_location_id
1421: AND ap.invoice_id = p_invoice_id
1422: AND ap.line_number = pn_line_number;
1423:

Line 1426: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap

1422: AND ap.line_number = pn_line_number;
1423:
1424: CURSOR get_rcpt_matched_org_cur(pn_line_number NUMBER) IS
1425: SELECT rcv.organization_id, rcv.location_id
1426: FROM jai_rcv_transactions rcv, ap_invoice_lines_all ap
1427: WHERE ap.rcv_transaction_id = rcv.transaction_id
1428: AND ap.invoice_id = p_invoice_id
1429: AND ap.line_number = pn_line_number;
1430:

Line 1927: ap_invoice_lines_all aila,

1923:
1924: CURSOR c_get_reference_id ( pn_invoice_id NUMBER, pn_invoice_line_id NUMBER, pn_tax_id NUMBER )IS
1925: SELECT jrf.reference_id
1926: FROM jai_rgm_trx_refs jrf,
1927: ap_invoice_lines_all aila,
1928: ap_invoice_distributions_all aida
1929: Where aida.invoice_id = aila.invoice_id
1930: AND aida.INVOICE_LINE_NUMBER = aila.line_number
1931: AND aida.invoice_distribution_id <> pn_invoice_line_id

Line 1936: from ap_invoice_lines_all al,

1932: AND aila.reference_key1 = pn_tax_id
1933: AND aila.reference_key2 =
1934: (
1935: SELECT al.reference_key2
1936: from ap_invoice_lines_all al,
1937: ap_invoice_distributions_all ad
1938: where al.invoice_id = ad.invoice_id
1939: and ad.INVOICE_LINE_NUMBER = al.line_number
1940: and al.invoice_id = pn_invoice_id