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 59: --| Fix: Commented update statement on ap_invoice_lines_all

55: --| Description:0 tax lines are populated when a standalone invoice is cancelled for a vendor having default service tax category.
56: --| Fix: call to Create_tax_lines procedure is restricted incase of cancelled invoices.Changes are done in Populate_Stnd_Inv_Taxes
57: --| 2012/10/29 anupgupt Bug:14681650
58: --| Description: R12 AP INVOICE NAVIGATION PERFORMANCE ISSUE
59: --| Fix: Commented update statement on ap_invoice_lines_all
60: --+======================================================================*/
61:
62: --==========================================================================
63: -- FUNCTION NAME:

Line 120: AP_INVOICE_LINES_ALL aila

116: CURSOR get_dist_line_number_cur IS
117: SELECT
118: aila.line_number
119: FROM
120: AP_INVOICE_LINES_ALL aila
121: , Ap_Invoice_Distributions_All aida
122: WHERE aila.INVOICE_ID = aida.invoice_id (+) --rollback to original logic
123: AND aila.line_number = aida.invoice_line_number (+) --rollback to original logic
124: AND aila.invoice_id = pn_invoice_id

Line 134: FROM AP_INVOICE_LINES_ALL

130:
131: /*To check whether User has provided Distribution Account at the Lines Leve for bug 9341898*/
132: Cursor get_dist_line_number_lines_cur IS
133: Select 1
134: FROM AP_INVOICE_LINES_ALL
135: WHERE invoice_id = pn_invoice_id
136: and default_dist_ccid is not null;
137:
138: ln_line_number NUMBER ;

Line 1147: ap_invoice_lines_all

1143: SELECT
1144: line_number
1145: , amount
1146: FROM
1147: ap_invoice_lines_all
1148: WHERE invoice_id = ln_invoice_id
1149: AND line_number = NVL(ln_invoice_item_line_number,line_number)
1150: AND line_type_lookup_code = GV_CONSTANT_ITEM;
1151:

Line 1181: , ap_invoice_lines_all aila

1177: , aila.base_amount base_amount
1178: FROM
1179: jai_ap_invoice_lines jail
1180: , jai_cmn_document_taxes jcdt
1181: , ap_invoice_lines_all aila
1182: WHERE jcdt.source_doc_id = jail.invoice_id
1183: AND jcdt.source_doc_line_id = jail.invoice_line_number
1184: AND aila.invoice_id = jail.invoice_id
1185: AND aila.line_number = jail.invoice_line_number

Line 1722: FROM AP_INVOICE_LINES_ALL

1718:
1719: --start additions for bug#9775984
1720: Cursor get_dflt_ccid IS
1721: Select default_dist_ccid
1722: FROM AP_INVOICE_LINES_ALL
1723: WHERE invoice_id = pn_invoice_id
1724: and line_number = pn_item_line_number;
1725: --end additions for bug#9775984
1726:

Line 1976: /*UPDATE ap_invoice_lines_all

1972: );
1973: END IF;
1974:
1975: -- add row level lock to the table ,to avoid duplicated lines created
1976: /*UPDATE ap_invoice_lines_all
1977: SET invoice_id = pn_invoice_id
1978: WHERE invoice_id = pn_invoice_id;*/ -- for bug 14681650 by anupgupt
1979:
1980: SELECT

Line 1985: ap_invoice_lines_all

1981: NVL(MAX (line_number), 0)
1982: INTO
1983: ln_max_line_number
1984: FROM
1985: ap_invoice_lines_all
1986: WHERE invoice_id = pn_invoice_id;
1987:
1988: IF ( ln_proc_level >= ln_dbg_level)
1989: THEN

Line 2588: --invoice will be deleted from ap_invoice_lines_all

2584: END IF; --(lv_modified_only_flag = 'N')
2585:
2586: --Delete all exclusive taxes lines for the specified invoice id and item line
2587: --number. If invoice line number is null, all exclusive tax lines for the
2588: --invoice will be deleted from ap_invoice_lines_all
2589: DELETE
2590: FROM
2591: ap_invoice_lines_all aila
2592: WHERE aila.invoice_id = ln_invoice_id

Line 2591: ap_invoice_lines_all aila

2587: --number. If invoice line number is null, all exclusive tax lines for the
2588: --invoice will be deleted from ap_invoice_lines_all
2589: DELETE
2590: FROM
2591: ap_invoice_lines_all aila
2592: WHERE aila.invoice_id = ln_invoice_id
2593: AND EXISTS
2594: (
2595: SELECT

Line 2612: || '.Delete from ap_invoice_lines_all'

2608: IF ( ln_proc_level >= ln_dbg_level)
2609: THEN
2610: FND_LOG.STRING( ln_proc_level
2611: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2612: || '.Delete from ap_invoice_lines_all'
2613: , SQL%ROWCOUNT||' ROWS DELETED '
2614: );
2615: END IF;--( ln_proc_level >= ln_dbg_level)
2616:

Line 2749: ap_invoice_lines_all aila

2745: (
2746: SELECT
2747: 'X'
2748: FROM
2749: ap_invoice_lines_all aila
2750: WHERE aila.invoice_id = ln_invoice_id
2751: AND aila.line_number = jcdt.source_doc_parent_line_no
2752: );
2753: --end of modification by eric for inclusive taxes-----------------

Line 2770: ap_invoice_lines_all aila

2766: (
2767: SELECT
2768: 'X'
2769: FROM
2770: ap_invoice_lines_all aila
2771: WHERE aila.invoice_id = ln_invoice_id
2772: AND aila.line_number =jail.parent_invoice_line_number
2773: )
2774: );

Line 2796: ap_invoice_lines_all aila

2792: (
2793: SELECT
2794: 'X'
2795: FROM
2796: ap_invoice_lines_all aila
2797: WHERE aila.invoice_id = ln_invoice_id
2798: AND (aila.line_number =jail.parent_invoice_line_number OR aila.line_type_lookup_code = GV_CONSTANT_ITEM) --added by Bgowrava for Bug#9387830
2799: )
2800: )

Line 2803: --delete miscellaneous lines in ap_invoice_lines_all

2799: )
2800: )
2801: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS;
2802:
2803: --delete miscellaneous lines in ap_invoice_lines_all
2804: DELETE
2805: FROM
2806: ap_invoice_lines_all aila
2807: WHERE aila.invoice_id = ln_invoice_id

Line 2806: ap_invoice_lines_all aila

2802:
2803: --delete miscellaneous lines in ap_invoice_lines_all
2804: DELETE
2805: FROM
2806: ap_invoice_lines_all aila
2807: WHERE aila.invoice_id = ln_invoice_id
2808: AND EXISTS
2809: (
2810: SELECT

Line 2821: ap_invoice_lines_all aila

2817: (
2818: SELECT
2819: 'X'
2820: FROM
2821: ap_invoice_lines_all aila
2822: WHERE aila.invoice_id =ln_invoice_id
2823: AND aila.line_number = jail.parent_invoice_line_number
2824: )
2825: )

Line 2838: ap_invoice_lines_all aila

2834: (
2835: SELECT
2836: line_number
2837: FROM
2838: ap_invoice_lines_all aila
2839: WHERE aila.invoice_id = ln_invoice_id
2840: AND aila.line_number = jail.invoice_line_number
2841: )
2842: AND line_type_lookup_code = GV_CONSTANT_ITEM;

Line 2855: ap_invoice_lines_all aila

2851: (
2852: SELECT
2853: 'X'
2854: FROM
2855: ap_invoice_lines_all aila
2856: WHERE aila.invoice_id =ln_invoice_id
2857: AND aila.line_number = jail.parent_invoice_line_number
2858: )
2859: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS;

Line 3356: ap_invoice_lines_all apia

3352: SELECT
3353: apia.line_number line_number
3354: , apia.amount line_amount
3355: FROM
3356: ap_invoice_lines_all apia
3357: , jai_ap_invoice_lines jail
3358: WHERE apia.invoice_id = jail.invoice_id
3359: AND apia.line_number = jail.invoice_line_number
3360: AND apia.invoice_id = ln_std_invoice_id

Line 3379: ap_invoice_lines_all apia

3375: SELECT
3376: apia.line_number line_number
3377: , apia.amount line_amount
3378: FROM
3379: ap_invoice_lines_all apia
3380: , jai_ap_invoice_lines jail
3381: WHERE apia.invoice_id = jail.invoice_id (+)
3382: AND apia.line_number = jail.invoice_line_number(+)
3383: AND apia.invoice_id = ln_std_invoice_id

Line 3404: FROM ap_invoice_lines_all

3400: where invoice_id = p_invoice_id;
3401:
3402: CURSOR c_invoice_id IS -- for bug 14681650 by anupgupt
3403: SELECT invoice_id
3404: FROM ap_invoice_lines_all
3405: WHERE invoice_id = pn_invoice_id
3406: FOR UPDATE;
3407:
3408: v_invoice_amount NUMBER;

Line 3888: from ap_invoice_lines_all

3884:
3885: --start additions for bug#10044104
3886: select count(*)
3887: INTO LN_CANCEL_CNT
3888: from ap_invoice_lines_all
3889: where cancelled_flag='Y'
3890: AND INVOICE_ID= ln_std_invoice_id
3891: and line_number = diff_inv_lines_rec.line_number; /* Added and condition for bug 14650698 */
3892:

Line 3974: from ap_invoice_lines_all

3970: FOR diff_inv_lines_rec IN diff_inv_lines_cur
3971: LOOP
3972: select count(*)
3973: INTO LN_CANCEL_CNT
3974: from ap_invoice_lines_all
3975: where cancelled_flag='Y'
3976: AND INVOICE_ID= ln_std_invoice_id;
3977:
3978: IF LN_CANCEL_CNT>0

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

4001: /* Error msg will be populated AP Invoice workbench when changing the data in header
4002: UPDATE
4003: AP_INVOICES_ALL
4004: SET
4005: invoice_amount = (SELECT SUM(amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id ),
4006: base_amount = (SELECT SUM(base_amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id )
4007: WHERE invoice_id =pn_invoice_id;
4008: */
4009:

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

4002: UPDATE
4003: AP_INVOICES_ALL
4004: SET
4005: invoice_amount = (SELECT SUM(amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id ),
4006: base_amount = (SELECT SUM(base_amount) FROM AP_INVOICE_LINES_ALL WHERE invoice_id =pn_invoice_id )
4007: WHERE invoice_id =pn_invoice_id;
4008: */
4009:
4010: CLOSE c_invoice_id; -- for bug 14681650 by anupgupt

Line 4489: ap_invoice_lines_all

4485: , expenditure_type
4486: , expenditure_item_date
4487: , expenditure_organization_id
4488: FROM
4489: ap_invoice_lines_all
4490: WHERE invoice_id = ln_invoice_id
4491: AND line_type_lookup_code = GV_CONSTANT_ITEM
4492: AND match_type = GV_NOT_MATCH_TYPE
4493: AND line_number = NVL (ln_line_number, line_number);

Line 4711: ap_invoice_lines_all a

4707: , expenditure_type
4708: , expenditure_item_date
4709: , expenditure_organization_id
4710: FROM
4711: ap_invoice_lines_all a
4712: WHERE invoice_id = ln_invoice_id
4713: AND line_number = pn_inovoice_line_num
4714: AND NOT EXISTS
4715: (

Line 4765: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;

4761: lv_insert_ap_inv_ln_sql VARCHAR2(32000);
4762: lv_insert_ap_inv_dist_ln_sql VARCHAR2(32000);
4763: lv_pr_processed_flag VARCHAR2(1); --added by eric on jan 29,2008
4764: ln_max_source_line_id NUMBER; --added by eric on jan 29,2008
4765: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4766: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4767: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4768: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4769: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;

Line 4766: ln_project_id ap_invoice_lines_all.project_id%TYPE;

4762: lv_insert_ap_inv_dist_ln_sql VARCHAR2(32000);
4763: lv_pr_processed_flag VARCHAR2(1); --added by eric on jan 29,2008
4764: ln_max_source_line_id NUMBER; --added by eric on jan 29,2008
4765: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4766: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4767: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4768: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4769: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4770: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;

Line 4767: ln_task_id ap_invoice_lines_all.task_id%TYPE;

4763: lv_pr_processed_flag VARCHAR2(1); --added by eric on jan 29,2008
4764: ln_max_source_line_id NUMBER; --added by eric on jan 29,2008
4765: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4766: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4767: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4768: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4769: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4770: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4771: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857

Line 4768: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;

4764: ln_max_source_line_id NUMBER; --added by eric on jan 29,2008
4765: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4766: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4767: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4768: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4769: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4770: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4771: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857
4772: /* Start bug-13535569 */

Line 4769: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;

4765: ln_asset_track_flag ap_invoice_lines_all.assets_tracking_flag%TYPE;
4766: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4767: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4768: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4769: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4770: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4771: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857
4772: /* Start bug-13535569 */
4773: cursor c_exists_jai_ap_invoice_lines (p_invoice_id number, p_invoice_line_number number) is

Line 4770: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;

4766: ln_project_id ap_invoice_lines_all.project_id%TYPE;
4767: ln_task_id ap_invoice_lines_all.task_id%TYPE;
4768: lv_expenditure_type ap_invoice_lines_all.expenditure_type%TYPE;
4769: ld_exp_item_date ap_invoice_lines_all.expenditure_item_date%TYPE;
4770: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4771: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857
4772: /* Start bug-13535569 */
4773: cursor c_exists_jai_ap_invoice_lines (p_invoice_id number, p_invoice_line_number number) is
4774: select count(*)

Line 4781: from ap_invoice_lines_all

4777: and invoice_line_number=p_invoice_line_number;
4778:
4779: cursor c_exists_ap_invoice_lines (p_invoice_id number, p_invoice_line_number number) is
4780: select count(*)
4781: from ap_invoice_lines_all
4782: where invoice_id=p_invoice_id
4783: and line_number=p_invoice_line_number;
4784:
4785: cursor c_exists_ap_invoice_dist_lines (p_invoice_id number, p_invoice_line_number number, p_distribution_line_number number) is

Line 4849: ln_invoice_line_amt ap_invoice_lines_all.amount%type;

4845: AND NVL(posted_flag, 'N') = 'N';
4846: --start additions for bug#12946186
4847: ln_dist_taxamt ap_invoice_distributions_all.amount%type;
4848: ln_dist_lineno number;
4849: ln_invoice_line_amt ap_invoice_lines_all.amount%type;
4850:
4851:
4852: --Added by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011, begin
4853: ------------------------------------------------------------------------------

Line 4856: FROM ap_invoice_lines_all lines,

4852: --Added by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011, begin
4853: ------------------------------------------------------------------------------
4854: CURSOR get_external_flag_cur(pn_invoice_id NUMBER, pn_line_number NUMBER) IS
4855: SELECT COUNT(lines.invoice_id)
4856: FROM ap_invoice_lines_all lines,
4857: jai_interface_lines_all intfs
4858: WHERE lines.line_number = intfs.internal_trx_line_id
4859: AND lines.invoice_id = intfs.internal_trx_id
4860: AND lines.line_number = pn_line_number

Line 4867: FROM ap_invoice_lines_all lines,

4863: AND intfs.taxable_event = 'EXTERNAL';
4864:
4865: CURSOR get_open_source_cur(pn_invoice_id NUMBER, pn_line_number NUMBER) IS
4866: SELECT COUNT(lines.invoice_id)
4867: FROM ap_invoice_lines_all lines,
4868: jai_interface_lines_all intfs
4869: WHERE lines.line_number = intfs.internal_trx_line_id
4870: AND lines.invoice_id = intfs.internal_trx_id
4871: AND lines.line_number = pn_line_number

Line 4885: FROM ap_invoice_lines_all lines

4881: --Added by zhiwei for Bug#12588962 on 20110610 begin
4882: ------------------------------------------------------------
4883: CURSOR chk_from_open_api(pn_invoice_id NUMBER, pn_line_number NUMBER) IS
4884: SELECT COUNT(lines.invoice_id)
4885: FROM ap_invoice_lines_all lines
4886: WHERE 1=1
4887: AND lines.line_number = pn_line_number
4888: AND lines.invoice_id = pn_invoice_id
4889: AND lines.reference_key3 = 'OFI TAX IMPORT';

Line 5057: 'INSERT INTO ap_invoice_lines_all

5053: , :36
5054: )';
5055:
5056: lv_insert_ap_inv_ln_sql :=
5057: 'INSERT INTO ap_invoice_lines_all
5058: ( invoice_id
5059: , line_number
5060: , line_type_lookup_code
5061: , description

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

5347: , pn_tax_category_id => ln_tax_category_id
5348: , pv_tax_modified => lv_tax_modified
5349: );
5350: END IF; --ln_open_source = 0, Added by Xiao for Open Interface ER bug#11683927 on 10-Feb-2011
5351: --into jai_ap_invoice_lines if item line exists in ap_invoice_lines_all
5352: --and not in jai_ap_invoice_lines
5353:
5354: FOR item_line_rec IN
5355: new_invoice_lines_cur (ap_invoice_lines_rec.line_number)

Line 5876: --insert into ap_invoice_lines_all

5872: , 'Table jai_ap_invoice_lines inserted '
5873: );
5874: END IF; --( ln_proc_level >= ln_dbg_level )
5875: end if;
5876: --insert into ap_invoice_lines_all
5877: /* Bug 13535569 */
5878: open c_exists_ap_invoice_lines(jai_doc_taxes_rec.source_doc_id,jai_doc_taxes_rec.source_doc_line_id);
5879: fetch c_exists_ap_invoice_lines into ln_exists;
5880: close c_exists_ap_invoice_lines;

Line 5919: , 'Table ap_invoice_lines_all inserted '

5915: THEN
5916: FND_LOG.STRING ( ln_proc_level
5917: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
5918: || '.debug Info.'
5919: , 'Table ap_invoice_lines_all inserted '
5920: );
5921: END IF; --( ln_proc_level >= ln_dbg_level )
5922: end if;
5923: ln_dist_acct_ccid :=

Line 6137: -- or max ap_invoice_lines_all.line_number

6133: --insert into eric_log values (7.91,'jai_doc_taxes_rec.inc_tax_flag =''Y'' AND recoverable with project case ',sysdate);
6134:
6135: -- Insert negative line with project info
6136: -- Line number got from max jai_cmn_document_taxes.source_doc_line_id
6137: -- or max ap_invoice_lines_all.line_number
6138: ln_max_inv_line_num := Get_Max_Invoice_Line_Number(ln_invoice_id);
6139:
6140: -- deleted by eric for fixing the bug of bug#6784111 on 29-JAN,2008,begin
6141: /*

Line 6319: from ap_invoice_lines_all

6315: --start additions for bug#12946186
6316: ln_dist_lineno :=nvl(ln_dist_lineno,0)+1;
6317: select amount
6318: into ln_invoice_line_amt
6319: from ap_invoice_lines_all
6320: where invoice_id=ln_invoice_id
6321: and line_number =ap_invoice_lines_rec.line_number;
6322:
6323: ln_dist_taxamt := jai_doc_taxes_rec.tax_amt*ap_invoice_dist_rec.amount/ln_invoice_line_amt ;