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_AP_STND_TAX_PROCESS dependencies on AP_INVOICE_LINES_ALL

Line 74: AP_INVOICE_LINES_ALL aila

70: CURSOR get_dist_line_number_cur IS
71: SELECT
72: aila.line_number
73: FROM
74: AP_INVOICE_LINES_ALL aila
75: , Ap_Invoice_Distributions_All aida
76: WHERE aila.INVOICE_ID = aida.invoice_id (+) --rollback to original logic
77: AND aila.line_number = aida.invoice_line_number (+) --rollback to original logic
78: AND aila.invoice_id = pn_invoice_id

Line 959: ap_invoice_lines_all

955: SELECT
956: line_number
957: , amount
958: FROM
959: ap_invoice_lines_all
960: WHERE invoice_id = ln_invoice_id
961: AND line_number = NVL(ln_invoice_item_line_number,line_number)
962: AND line_type_lookup_code = GV_CONSTANT_ITEM;
963:

Line 993: , ap_invoice_lines_all aila

989: , aila.base_amount base_amount
990: FROM
991: jai_ap_invoice_lines jail
992: , jai_cmn_document_taxes jcdt
993: , ap_invoice_lines_all aila
994: WHERE jcdt.source_doc_id = jail.invoice_id
995: AND jcdt.source_doc_line_id = jail.invoice_line_number
996: AND aila.invoice_id = jail.invoice_id
997: AND aila.line_number = jail.invoice_line_number

Line 1651: UPDATE ap_invoice_lines_all

1647: );
1648: END IF;
1649:
1650: -- add row level lock to the table ,to avoid duplicated lines created
1651: UPDATE ap_invoice_lines_all
1652: SET invoice_id = pn_invoice_id
1653: WHERE invoice_id = pn_invoice_id;
1654:
1655: SELECT

Line 1660: ap_invoice_lines_all

1656: NVL(MAX (line_number), 0)
1657: INTO
1658: ln_max_line_number
1659: FROM
1660: ap_invoice_lines_all
1661: WHERE invoice_id = pn_invoice_id;
1662:
1663: IF ( ln_proc_level >= ln_dbg_level)
1664: THEN

Line 2263: --invoice will be deleted from ap_invoice_lines_all

2259: END IF; --(lv_modified_only_flag = 'N')
2260:
2261: --Delete all exclusive taxes lines for the specified invoice id and item line
2262: --number. If invoice line number is null, all exclusive tax lines for the
2263: --invoice will be deleted from ap_invoice_lines_all
2264: DELETE
2265: FROM
2266: ap_invoice_lines_all aila
2267: WHERE aila.invoice_id = ln_invoice_id

Line 2266: ap_invoice_lines_all aila

2262: --number. If invoice line number is null, all exclusive tax lines for the
2263: --invoice will be deleted from ap_invoice_lines_all
2264: DELETE
2265: FROM
2266: ap_invoice_lines_all aila
2267: WHERE aila.invoice_id = ln_invoice_id
2268: AND EXISTS
2269: (
2270: SELECT

Line 2287: || '.Delete from ap_invoice_lines_all'

2283: IF ( ln_proc_level >= ln_dbg_level)
2284: THEN
2285: FND_LOG.STRING( ln_proc_level
2286: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2287: || '.Delete from ap_invoice_lines_all'
2288: , SQL%ROWCOUNT||' ROWS DELETED '
2289: );
2290: END IF;--( ln_proc_level >= ln_dbg_level)
2291:

Line 2424: ap_invoice_lines_all aila

2420: (
2421: SELECT
2422: 'X'
2423: FROM
2424: ap_invoice_lines_all aila
2425: WHERE aila.invoice_id = ln_invoice_id
2426: AND aila.line_number = jcdt.source_doc_parent_line_no
2427: );
2428: --end of modification by eric for inclusive taxes-----------------

Line 2445: ap_invoice_lines_all aila

2441: (
2442: SELECT
2443: 'X'
2444: FROM
2445: ap_invoice_lines_all aila
2446: WHERE aila.invoice_id = ln_invoice_id
2447: AND aila.line_number =jail.parent_invoice_line_number
2448: )
2449: );

Line 2471: ap_invoice_lines_all aila

2467: (
2468: SELECT
2469: 'X'
2470: FROM
2471: ap_invoice_lines_all aila
2472: WHERE aila.invoice_id = ln_invoice_id
2473: AND aila.line_number =jail.parent_invoice_line_number
2474: )
2475: )

Line 2478: --delete miscellaneous lines in ap_invoice_lines_all

2474: )
2475: )
2476: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS;
2477:
2478: --delete miscellaneous lines in ap_invoice_lines_all
2479: DELETE
2480: FROM
2481: ap_invoice_lines_all aila
2482: WHERE aila.invoice_id = ln_invoice_id

Line 2481: ap_invoice_lines_all aila

2477:
2478: --delete miscellaneous lines in ap_invoice_lines_all
2479: DELETE
2480: FROM
2481: ap_invoice_lines_all aila
2482: WHERE aila.invoice_id = ln_invoice_id
2483: AND EXISTS
2484: (
2485: SELECT

Line 2496: ap_invoice_lines_all aila

2492: (
2493: SELECT
2494: 'X'
2495: FROM
2496: ap_invoice_lines_all aila
2497: WHERE aila.invoice_id =ln_invoice_id
2498: AND aila.line_number = jail.parent_invoice_line_number
2499: )
2500: )

Line 2513: ap_invoice_lines_all aila

2509: (
2510: SELECT
2511: line_number
2512: FROM
2513: ap_invoice_lines_all aila
2514: WHERE aila.invoice_id = ln_invoice_id
2515: AND aila.line_number = jail.invoice_line_number
2516: )
2517: AND line_type_lookup_code = GV_CONSTANT_ITEM;

Line 2530: ap_invoice_lines_all aila

2526: (
2527: SELECT
2528: 'X'
2529: FROM
2530: ap_invoice_lines_all aila
2531: WHERE aila.invoice_id =ln_invoice_id
2532: AND aila.line_number = jail.parent_invoice_line_number
2533: )
2534: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS;

Line 2861: ap_invoice_lines_all apia

2857: SELECT
2858: apia.line_number line_number
2859: , apia.amount line_amount
2860: FROM
2861: ap_invoice_lines_all apia
2862: , jai_ap_invoice_lines jail
2863: WHERE apia.invoice_id = jail.invoice_id
2864: AND apia.line_number = jail.invoice_line_number
2865: AND apia.invoice_id = ln_std_invoice_id

Line 2876: ap_invoice_lines_all apia

2872: SELECT
2873: apia.line_number line_number
2874: , apia.amount line_amount
2875: FROM
2876: ap_invoice_lines_all apia
2877: , jai_ap_invoice_lines jail
2878: WHERE apia.invoice_id = jail.invoice_id (+)
2879: AND apia.line_number = jail.invoice_line_number(+)
2880: AND apia.invoice_id = ln_std_invoice_id

Line 3365: invoice_amount = (SELECT SUM(amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id ),

3361: /* Error msg will be populated AP Invoice workbench when changing the data in header
3362: UPDATE
3363: AP_INVOICES_ALL
3364: SET
3365: invoice_amount = (SELECT SUM(amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id ),
3366: base_amount = (SELECT SUM(base_amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id )
3367: WHERE invoice_id =pn_invoice_id;
3368: */
3369:

Line 3366: base_amount = (SELECT SUM(base_amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id )

3362: UPDATE
3363: AP_INVOICES_ALL
3364: SET
3365: invoice_amount = (SELECT SUM(amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id ),
3366: base_amount = (SELECT SUM(base_amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id )
3367: WHERE invoice_id =pn_invoice_id;
3368: */
3369:
3370: --log for debug

Line 3805: ap_invoice_lines_all

3801: , expenditure_type
3802: , expenditure_item_date
3803: , expenditure_organization_id
3804: FROM
3805: ap_invoice_lines_all
3806: WHERE invoice_id = ln_invoice_id
3807: AND line_type_lookup_code = GV_CONSTANT_ITEM
3808: AND match_type = GV_NOT_MATCH_TYPE
3809: AND line_number = NVL (ln_line_number, line_number);

Line 4015: ap_invoice_lines_all a

4011: , expenditure_type
4012: , expenditure_item_date
4013: , expenditure_organization_id
4014: FROM
4015: ap_invoice_lines_all a
4016: WHERE invoice_id = ln_invoice_id
4017: AND line_number = pn_inovoice_line_num
4018: AND NOT EXISTS
4019: (

Line 4060: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;

4056: lv_insert_ap_inv_ln_sql VARCHAR2(32000);
4057: lv_insert_ap_inv_dist_ln_sql VARCHAR2(32000);
4058: lv_pr_processed_flag VARCHAR2(1); --added by eric on jan 29,2008
4059: ln_max_source_line_id NUMBER; --added by eric on jan 29,2008
4060: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4061: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4062: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4063: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4064: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;

Line 4061: ln_project_id ap_invoice_lines_all.project_id%TYPE;

4057: lv_insert_ap_inv_dist_ln_sql VARCHAR2(32000);
4058: lv_pr_processed_flag VARCHAR2(1); --added by eric on jan 29,2008
4059: ln_max_source_line_id NUMBER; --added by eric on jan 29,2008
4060: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4061: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4062: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4063: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4064: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4065: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;

Line 4062: ln_task_id ap_invoice_lines_all.task_id%TYPE;

4058: lv_pr_processed_flag VARCHAR2(1); --added by eric on jan 29,2008
4059: ln_max_source_line_id NUMBER; --added by eric on jan 29,2008
4060: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4061: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4062: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4063: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4064: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4065: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4066: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857

Line 4063: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;

4059: ln_max_source_line_id NUMBER; --added by eric on jan 29,2008
4060: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4061: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4062: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4063: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4064: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4065: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4066: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857
4067:

Line 4064: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;

4060: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4061: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4062: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4063: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4064: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4065: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4066: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857
4067:
4068: ln_dist_asst_add_flag

Line 4065: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;

4061: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4062: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4063: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4064: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4065: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4066: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857
4067:
4068: ln_dist_asst_add_flag
4069: ap_invoice_distributions_all.assets_addition_flag%TYPE;

Line 4221: 'INSERT INTO ap_invoice_lines_all

4217: , :36
4218: )';
4219:
4220: lv_insert_ap_inv_ln_sql :=
4221: 'INSERT INTO ap_invoice_lines_all
4222: ( invoice_id
4223: , line_number
4224: , line_type_lookup_code
4225: , description

Line 4490: --into jai_ap_invoice_lines if item line exists in ap_invoice_lines_all

4486: , pn_tax_category_id => ln_tax_category_id
4487: , pv_tax_modified => lv_tax_modified
4488: );
4489:
4490: --into jai_ap_invoice_lines if item line exists in ap_invoice_lines_all
4491: --and not in jai_ap_invoice_lines
4492:
4493: FOR item_line_rec IN
4494: new_invoice_lines_cur (ap_invoice_lines_rec.line_number)

Line 4948: --insert into ap_invoice_lines_all

4944: , 'Table jai_ap_invoice_lines inserted '
4945: );
4946: END IF; --( ln_proc_level >= ln_dbg_level )
4947:
4948: --insert into ap_invoice_lines_all
4949: EXECUTE IMMEDIATE lv_insert_ap_inv_ln_sql
4950: USING jai_doc_taxes_rec.source_doc_id
4951: , jai_doc_taxes_rec.source_doc_line_id
4952: , GV_CONSTANT_MISCELLANEOUS

Line 4986: , 'Table ap_invoice_lines_all inserted '

4982: THEN
4983: FND_LOG.STRING ( ln_proc_level
4984: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
4985: || '.debug Info.'
4986: , 'Table ap_invoice_lines_all inserted '
4987: );
4988: END IF; --( ln_proc_level >= ln_dbg_level )
4989:
4990: ln_dist_acct_ccid :=

Line 5100: -- or max ap_invoice_lines_all.line_number

5096: --insert into eric_log values (7.91,'jai_doc_taxes_rec.inc_tax_flag =''Y'' AND recoverable with project case ',sysdate);
5097:
5098: -- Insert negative line with project info
5099: -- Line number got from max jai_cmn_document_taxes.source_doc_line_id
5100: -- or max ap_invoice_lines_all.line_number
5101: ln_max_inv_line_num := Get_Max_Invoice_Line_Number(ln_invoice_id);
5102:
5103: -- deleted by eric for fixing the bug of bug#6784111 on 29-JAN,2008,begin
5104: /*