APPS.JAI_OPEN_API_PKG dependencies on AP_INVOICE_LINES_ALL

Line 3409: FROM ap_invoice_lines_all

3405: SELECT 'Y'
3406: INTO lv_import_flag
3407: FROM dual
3408: WHERE EXISTS (SELECT 1
3409: FROM ap_invoice_lines_all
3410: WHERE invoice_id = pn_trx_id
3411: AND line_number = pn_trx_line_id
3412: AND upper(reference_key3) = 'OFI TAX IMPORT'
3413: );

Line 4043: FROM ap_invoice_lines_all

4039: SELECT
4040: invoice_id,line_number,
4041: reference_key1 transaction_id,
4042: reference_key2 transaction_line_id
4043: FROM ap_invoice_lines_all
4044: WHERE 1=1
4045: AND line_type_lookup_code = 'ITEM'
4046: AND reference_key3 = 'OFI TAX IMPORT'
4047: AND reference_key1 = pv_transaction_num

Line 11057: FROM ap_invoice_lines_all

11053: SELECT amount
11054: ,nvl(quantity_invoiced,1) --Added by zhiwei for Bug#12604133 on 20110623
11055: INTO ln_line_amount
11056: ,ln_quantity --Added by zhiwei for Bug#12604133 on 20110623
11057: FROM ap_invoice_lines_all
11058: WHERE invoice_id = ln_header_id
11059: AND line_number = ln_line_num;
11060:
11061: IF ln_vat_assessable_value = 0 THEN

Line 11747: --ap_invoice_lines_all.reference_key3 values 'OFI TAX IMPORT'

11743: INTO ln_invoice_id, ln_invoice_line_num
11744: FROM jai_interface_lines_all
11745: WHERE interface_line_id = ln_interface_line_id;
11746:
11747: --ap_invoice_lines_all.reference_key3 values 'OFI TAX IMPORT'
11748: /* The purpose is for distinguish Standard or External Case,
11749: * In External Case, when Service Taxes are imported and attached to AP lines,
11750: * the same will not be picked up and updated in the Service Tax Repository.
11751: */

Line 11752: /*UPDATE ap_invoice_lines_all

11748: /* The purpose is for distinguish Standard or External Case,
11749: * In External Case, when Service Taxes are imported and attached to AP lines,
11750: * the same will not be picked up and updated in the Service Tax Repository.
11751: */
11752: /*UPDATE ap_invoice_lines_all
11753: SET reference_key3 = 'OFI TAX IMPORT.' || upper(lv_taxable_event)
11754: WHERE invoice_id = ln_invoice_id
11755: AND line_number = ln_invoice_line_num;*/
11756:

Line 11827: /* UPDATE ap_invoice_lines_all aila

11823: process_ap_accounting_lines(ln_interface_line_id);
11824:
11825: --update reference_key3 as 'OFI TAX IMPORT.STANDARD' or 'OFI TAX IMPORT.EXTERNAL'
11826: --for all the Miscellaneous lines for each item line.
11827: /* UPDATE ap_invoice_lines_all aila
11828: SET reference_key3 = 'OFI TAX IMPORT.' || upper(lv_taxable_event)
11829: WHERE invoice_id = ln_invoice_id
11830: AND line_number IN (SELECT source_doc_line_id
11831: FROM jai_cmn_document_taxes

Line 11970: FROM ap_invoice_lines_all

11966: ELSIF (upper(GV_IMPORT_MODULE) = JAI_CONSTANTS.SOURCE_AP) THEN
11967:
11968: SELECT SUM(amount)
11969: INTO ln_total_amount
11970: FROM ap_invoice_lines_all
11971: WHERE invoice_id = rec_trx_id.trx_id;
11972:
11973: --Invoice amount should be updated after all invoice lines are generated.
11974: UPDATE ap_invoices_all