eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OPEN_API_PKG dependencies on AP_INVOICE_LINES

Line 2650: FROM AP_INVOICE_LINES

2646: --Get AP transaction lines count
2647: CURSOR get_ap_lines_count_cur(
2648: cn_trx_id IN JAI_INTERFACE_LINES_ALL.INTERNAL_TRX_ID%TYPE) IS
2649: SELECT COUNT(line_number)
2650: FROM AP_INVOICE_LINES
2651: WHERE INVOICE_ID = cn_trx_id;
2652:
2653: --Get error lines
2654: CURSOR get_err_lines_cur(

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 10867: , 'JAI_AP_INVOICE_LINES' --Source_Table_Name

10863: , v_modvat_flag --Modvat_Flag
10864: , 'STANDALONE_INVOICE' --Source_Doc_Type
10865: , tax_lines_rec.internal_trx_id --Source_Doc_ID
10866: , tax_lines_rec.internal_trx_line_id --Source_Doc_Line_ID, will update with real invoice line number in later program.
10867: , 'JAI_AP_INVOICE_LINES' --Source_Table_Name
10868: , 'SYSTEM' --Tax_Modified_By
10869: , tax_lines_rec.adhoc_flag
10870: , ln_p1
10871: , ln_p2

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 11224: /* For item lines in jai_ap_invoice_lines, organization_id, location_id,

11220: , lv_service_type_code
11221: , ln_tax_category_id;
11222: CLOSE interface_lines_cur;
11223:
11224: /* For item lines in jai_ap_invoice_lines, organization_id, location_id,
11225: * service_type_code, tax_category will leave as NULL after Open API importing.
11226: * So, following code manually update organization_id, location_id, service_type_code
11227: * tax_category column on table jai_ap_invoice_lines.
11228: */

Line 11227: * tax_category column on table jai_ap_invoice_lines.

11223:
11224: /* For item lines in jai_ap_invoice_lines, organization_id, location_id,
11225: * service_type_code, tax_category will leave as NULL after Open API importing.
11226: * So, following code manually update organization_id, location_id, service_type_code
11227: * tax_category column on table jai_ap_invoice_lines.
11228: */
11229: UPDATE jai_ap_invoice_lines
11230: SET organization_id = ln_organization_id
11231: , location_id = ln_location_id

Line 11229: UPDATE jai_ap_invoice_lines

11225: * service_type_code, tax_category will leave as NULL after Open API importing.
11226: * So, following code manually update organization_id, location_id, service_type_code
11227: * tax_category column on table jai_ap_invoice_lines.
11228: */
11229: UPDATE jai_ap_invoice_lines
11230: SET organization_id = ln_organization_id
11231: , location_id = ln_location_id
11232: , service_type_code = nvl(lv_service_type_code,service_type_code) --Changed by zhiwei for Bug#12537533 on 20110510
11233: , tax_category_id = ln_tax_category_id

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