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 RA_CUSTOMER_TRX_LINES_ALL

Line 993: FROM ra_customer_trx_lines_all

989: --Added by zhiwei for bug#12560873 begin
990: ----------------------------------------
991: IN (
992: SELECT customer_trx_line_id
993: FROM ra_customer_trx_lines_all
994: WHERE customer_trx_id = pn_trx_id
995: );
996: ----------------------------------------
997: --Added by zhiwei for bug#12560873 end

Line 2643: FROM RA_CUSTOMER_TRX_LINES_ALL

2639: --Get AR transaction lines count
2640: CURSOR get_ar_lines_count_cur(
2641: cn_trx_id IN JAI_INTERFACE_LINES_ALL.INTERNAL_TRX_ID%TYPE) IS
2642: SELECT COUNT(CUSTOMER_TRX_LINE_ID)
2643: FROM RA_CUSTOMER_TRX_LINES_ALL
2644: WHERE CUSTOMER_TRX_ID = cn_trx_id;
2645:
2646: --Get AP transaction lines count
2647: CURSOR get_ap_lines_count_cur(

Line 3421: FROM ra_customer_trx_lines_all

3417: SELECT 'Y'
3418: INTO lv_import_flag
3419: FROM dual
3420: WHERE EXISTS (SELECT 1
3421: FROM ra_customer_trx_lines_all
3422: WHERE customer_trx_id = pn_trx_id
3423: AND customer_trx_line_id = pn_trx_line_id
3424: --AND upper(interface_line_context) = 'OFI TAX IMPORT' --DFF
3425: AND upper(global_attribute_category) = 'JG.IN.ARXTWMAI.OFI TAX IMPORT' --GDF

Line 3435: FROM ra_customer_trx_all head, ra_customer_trx_lines_all line

3431: SELECT 'Y'
3432: INTO lv_import_flag
3433: FROM dual
3434: WHERE EXISTS (SELECT 1
3435: FROM ra_customer_trx_all head, ra_customer_trx_lines_all line
3436: WHERE line.customer_trx_id = pn_trx_id
3437: AND line.customer_trx_line_id = pn_trx_line_id
3438: AND head.customer_trx_id = line.customer_trx_id
3439: AND head.createD_from = 'RAXTRX'

Line 3835: CURSOR get_inventory_item_id(cn_customer_trx_line_id IN RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE)

3831: SELECT created_from , trx_date
3832: FROM ra_customer_trx_all
3833: WHERE customer_trx_id = cn_customer_trx_id;
3834:
3835: CURSOR get_inventory_item_id(cn_customer_trx_line_id IN RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE)
3836: IS
3837: SELECT
3838: inventory_item_id
3839: FROM RA_CUSTOMER_TRX_LINES_ALL

Line 3839: FROM RA_CUSTOMER_TRX_LINES_ALL

3835: CURSOR get_inventory_item_id(cn_customer_trx_line_id IN RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE)
3836: IS
3837: SELECT
3838: inventory_item_id
3839: FROM RA_CUSTOMER_TRX_LINES_ALL
3840: WHERE CUSTOMER_TRX_LINE_ID = cn_customer_trx_line_id;
3841: --Variable define here
3842: ln_tax_category_id NUMBER;
3843: lv_enable_gst_flag varchar2(5);

Line 4020: FROM ra_customer_trx_lines_all

4016: SELECT
4017: customer_trx_id,customer_trx_line_id,
4018: global_attribute19 transaction_id,
4019: global_attribute20 transaction_line_id
4020: FROM ra_customer_trx_lines_all
4021: WHERE 1=1
4022: AND line_type = 'LINE'
4023: --AND upper(interface_line_context) = 'OFI TAX IMPORT' --DFF
4024: AND upper(global_attribute_category) = 'JG.IN.ARXTWMAI.OFI TAX IMPORT' --GDF

Line 5521: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;

5517: v_salesrep_id NUMBER;
5518: v_line_type VARCHAR2(30);
5519: v_vat_tax NUMBER;
5520: v_ccid NUMBER;
5521: v_cust_trx_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE;
5522: v_counter NUMBER;
5523: v_customer_trx_id NUMBER;
5524: c_from_currency_code VARCHAR2(15);
5525: c_conversion_type VARCHAR2(30);

Line 5712: from ra_customer_trx_lines_all

5708: p_customer_trx_line_id IN NUMBER) RETURN VARCHAR2 IS
5709: PRAGMA AUTONOMOUS_TRANSACTION;
5710: cursor c_get_hdr_ctx is
5711: select distinct interface_line_context
5712: from ra_customer_trx_lines_all
5713: where customer_trx_id = p_customer_trx_id
5714: and customer_trx_line_id = p_customer_trx_line_id --added for bug#5597146
5715: and interface_line_context is not null
5716: and rownum = 1;

Line 5717: lv_hdr_ctx ra_customer_trx_lines_all.INTERFACE_LINE_CONTEXT%type;

5713: where customer_trx_id = p_customer_trx_id
5714: and customer_trx_line_id = p_customer_trx_line_id --added for bug#5597146
5715: and interface_line_context is not null
5716: and rownum = 1;
5717: lv_hdr_ctx ra_customer_trx_lines_all.INTERFACE_LINE_CONTEXT%type;
5718: BEGIN
5719: OPEN c_get_hdr_ctx;
5720: FETCH c_get_hdr_ctx
5721: into lv_hdr_ctx;

Line 6191: || Delete TAX OR FREIGHT LINE IN RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIS_ALL

6187:
6188: END populate_temp_table;
6189:
6190: /*
6191: || Delete TAX OR FREIGHT LINE IN RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIS_ALL
6192: */
6193: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
6194: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
6195: p_process_status OUT NOCOPY VARCHAR2,

Line 6194: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,

6190: /*
6191: || Delete TAX OR FREIGHT LINE IN RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIS_ALL
6192: */
6193: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
6194: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
6195: p_process_status OUT NOCOPY VARCHAR2,
6196: p_process_message OUT NOCOPY VARCHAR2) IS
6197: lv_object_name user_procedures.object_name%type;
6198: lv_procedure_name user_procedures.procedure_name%type;

Line 6251: FROM ra_customer_trx_lines_all

6247: WHERE customer_trx_id = p_customer_trx_id
6248: AND account_class IN ('TAX', 'FREIGHT')
6249: AND customer_trx_line_id IN
6250: (SELECT customer_trx_line_id
6251: FROM ra_customer_trx_lines_all
6252: WHERE customer_trx_id = p_customer_trx_id
6253: AND link_to_cust_trx_line_id =
6254: NVL(p_link_to_cust_trx_line_id,
6255: link_to_cust_trx_line_id)

Line 6277: FROM ra_customer_trx_lines_all

6273: WHERE customer_trx_id = p_customer_trx_id
6274: AND account_class IN ('TAX', 'FREIGHT')
6275: AND customer_trx_line_id IN
6276: (SELECT customer_trx_line_id
6277: FROM ra_customer_trx_lines_all
6278: WHERE customer_trx_id = p_customer_trx_id
6279: AND link_to_cust_trx_line_id =
6280: NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
6281: AND line_type in ('TAX', 'FREIGHT'));

Line 6283: --delete the data from ra_customer_trx_lines_all

6279: AND link_to_cust_trx_line_id =
6280: NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
6281: AND line_type in ('TAX', 'FREIGHT'));
6282:
6283: --delete the data from ra_customer_trx_lines_all
6284: DELETE ra_customer_trx_lines_all
6285: WHERE customer_trx_id = p_customer_trx_id
6286: AND link_to_cust_trx_line_id =
6287: NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)

Line 6284: DELETE ra_customer_trx_lines_all

6280: NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
6281: AND line_type in ('TAX', 'FREIGHT'));
6282:
6283: --delete the data from ra_customer_trx_lines_all
6284: DELETE ra_customer_trx_lines_all
6285: WHERE customer_trx_id = p_customer_trx_id
6286: AND link_to_cust_trx_line_id =
6287: NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
6288: AND line_type IN ('TAX', 'FREIGHT');

Line 6481: FROM ra_customer_trx_lines_all

6477:
6478: CURSOR get_item_info_cur
6479: IS
6480: SELECT inventory_item_id, org_id
6481: FROM ra_customer_trx_lines_all
6482: WHERE customer_trx_id = pn_customer_trx_id
6483: AND line_type = 'LINE';
6484:
6485: cursor item_class_cur(P_ORG_ID IN NUMBER,P_INVENTORY_ITEM_ID IN NUMBER) IS

Line 6689: GET DATA FROM LINE_T , POPULATE INTO RA_CUSTOMER_TRX_LINES_ALL TAX LINE,

6685:
6686:
6687: /*
6688: LOGIC COME FROM AR FRIGHT CONCURRENT for manual AR. JAI_AR_MATCH_TAX_PKG.PROCESS_MANUAL_INVOICE
6689: GET DATA FROM LINE_T , POPULATE INTO RA_CUSTOMER_TRX_LINES_ALL TAX LINE,
6690: POPULATE INTO RA_CUSTOMER_TRX_GL_DIS_ALL
6691: */
6692: PROCEDURE process_trx_dis_bal_lines(pv_type IN VARCHAR2,
6693: pv_event IN VARCHAR2,

Line 6815: FROM RA_CUSTOMER_TRX_LINES_ALL

6811:
6812:
6813: CURSOR MAX_LINE_CUR(p_cust_link_line_id IN NUMBER, p_line_type IN VARCHAR2) IS
6814: SELECT NVL(MAX(line_number), 0)
6815: FROM RA_CUSTOMER_TRX_LINES_ALL
6816: WHERE link_to_cust_trx_line_id = p_cust_link_line_id
6817: and line_type = p_line_type;
6818:
6819:

Line 6830: RA_CUSTOMER_TRX_LINES_ALL B,

6826:
6827: CURSOR PREVIOUS_AMOUNT_CUR IS
6828: SELECT A.AMOUNT, A.ACCTD_AMOUNT
6829: FROM RA_CUST_TRX_LINE_GL_DIST_ALL A,
6830: RA_CUSTOMER_TRX_LINES_ALL B,
6831: JAI_AR_TRX_INS_LINES_T C
6832: WHERE A.CUSTOMER_TRX_LINE_ID = B.CUSTOMER_TRX_LINE_ID
6833: AND B.LINK_TO_CUST_TRX_LINE_ID = C.LINK_TO_CUST_TRX_LINE_ID
6834: AND C.CUSTOMER_TRX_ID = pn_customer_trx_id

Line 6858: From Ra_Customer_Trx_Lines_All

6854: /* AR Transactions with Invoicing Acctg Rules not supported by Localization, Enhancement Done on 16th NOV */
6855:
6856: Cursor accounting_set_cur IS
6857: Select accounting_rule_id
6858: From Ra_Customer_Trx_Lines_All
6859: Where Customer_Trx_Line_Id = pn_customer_trx_line_id;
6860:
6861: v_accounting_rule_id Number;
6862: v_account_set_flag Char(1);

Line 6864: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE) is

6860:
6861: v_accounting_rule_id Number;
6862: v_account_set_flag Char(1);
6863:
6864: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE) is
6865: Select previous_customer_trx_id
6866: from ra_customer_trx_lines_all
6867: where customer_trx_id = pn_customer_trx_id
6868: and line_type = p_line_type;

Line 6866: from ra_customer_trx_lines_all

6862: v_account_set_flag Char(1);
6863:
6864: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE) is
6865: Select previous_customer_trx_id
6866: from ra_customer_trx_lines_all
6867: where customer_trx_id = pn_customer_trx_id
6868: and line_type = p_line_type;
6869:
6870: --AND customer_trx_line_id = pn_customer_trx_line_id; --Added this condition on 05-Apr-2002 as it should fetch only one value

Line 6884: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE) is

6880: v_interface_line_attribute6 Varchar2(30);
6881: v_return_reference_type_code Varchar2(30);
6882: v_credit_invoice_line_id Number;
6883:
6884: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE) is
6885: Select interface_line_attribute6
6886: From ra_customer_trx_lines_all
6887: Where customer_trx_id = pn_customer_trx_id
6888: and line_type = p_line_type;

Line 6886: From ra_customer_trx_lines_all

6882: v_credit_invoice_line_id Number;
6883:
6884: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE) is
6885: Select interface_line_attribute6
6886: From ra_customer_trx_lines_all
6887: Where customer_trx_id = pn_customer_trx_id
6888: and line_type = p_line_type;
6889:
6890:

Line 6949: CURSOR cur_chk_jai_tax_dtls(cp_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE, cp_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE) IS

6945: WHERE customer_trx_id = pn_customer_trx_id;
6946:
6947:
6948: --added the following cursor for bug#8476512
6949: CURSOR cur_chk_jai_tax_dtls(cp_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE, cp_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE) IS
6950: SELECT 1
6951: FROM jai_ar_trx_tax_lines
6952: WHERE customer_trx_line_id = cp_customer_trx_line_id
6953: AND link_to_cust_trx_line_id = cp_link_to_cust_trx_line_id;

Line 6968: from Ra_customer_trx_lines_all

6964: v_taxable_amt number := 0;
6965:
6966: Cursor get_ext_amt_ln(p_line_type ra_customer_trx_lines.line_type%TYPE) is
6967: Select extended_amount
6968: from Ra_customer_trx_lines_all
6969: where customer_trx_id = pn_customer_trx_id
6970: and customer_trx_line_id = pn_customer_trx_line_id
6971: and line_type = p_line_type; --rchandan for bug#4428980
6972:

Line 6975: from Ra_customer_trx_lines_all

6971: and line_type = p_line_type; --rchandan for bug#4428980
6972:
6973: Cursor get_ext_amt_tax is
6974: Select extended_amount, customer_trx_line_id
6975: from Ra_customer_trx_lines_all
6976: where customer_trx_id = pn_customer_trx_id
6977: and Link_to_cust_trx_line_id = pn_customer_trx_line_id
6978: and line_type = lv_tax_const; --rchandan for bug#4428980
6979:

Line 6984: from ra_customer_trx_lines_all

6980: get_ext_amt_tax_rec get_ext_amt_tax%rowtype;
6981:
6982: Cursor get_taxable_amt(cust_trx_ln_id number) Is
6983: Select nvl(taxable_amount, 0)
6984: from ra_customer_trx_lines_all
6985: where customer_trx_line_id = cust_trx_ln_id
6986: and customer_trx_id = pn_customer_trx_id
6987: and line_type = lv_tax_const; --rchandan for bug#4428980
6988:

Line 7045: CURSOR cur_total_amt_trx_lines(cpn_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL, cp_line_type ra_customer_trx_lines_all.line_type%TYPE) IS

7041: ln_taxable_amount NUMBER;
7042: ln_tax_amt NUMBER;
7043: ln_tax_acctd_amount NUMBER;
7044:
7045: CURSOR cur_total_amt_trx_lines(cpn_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL, cp_line_type ra_customer_trx_lines_all.line_type%TYPE) IS
7046: SELECT NVL(SUM(extended_amount), 0) extended_amount
7047: FROM ra_customer_trx_lines_all
7048: WHERE customer_trx_id = cpn_customer_trx_id
7049: AND customer_trx_line_id = NVL(cp_customer_trx_line_id, customer_trx_line_id)

Line 7047: FROM ra_customer_trx_lines_all

7043: ln_tax_acctd_amount NUMBER;
7044:
7045: CURSOR cur_total_amt_trx_lines(cpn_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE, cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL, cp_line_type ra_customer_trx_lines_all.line_type%TYPE) IS
7046: SELECT NVL(SUM(extended_amount), 0) extended_amount
7047: FROM ra_customer_trx_lines_all
7048: WHERE customer_trx_id = cpn_customer_trx_id
7049: AND customer_trx_line_id = NVL(cp_customer_trx_line_id, customer_trx_line_id)
7050: AND line_type = cp_line_type;
7051:

Line 7120: --DELETE THE TAX AND FRIGHT LINES IN RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIS_ALL--ADDED BY ZHIWEI FOR OPEN INTERFACE 20101116

7116: v_sql_num := 9;
7117:
7118: --start additions for bug#9177024
7119: --if v_upd_created_from = 'ARXTWMAI' then --commented by zhiwei for ER OPEN INTERFACE 20101110
7120: --DELETE THE TAX AND FRIGHT LINES IN RA_CUSTOMER_TRX_LINES_ALL AND RA_CUST_TRX_LINE_GL_DIS_ALL--ADDED BY ZHIWEI FOR OPEN INTERFACE 20101116
7121: delete_trx_data(p_customer_trx_id => pn_customer_trx_id,
7122: p_link_to_cust_trx_line_id => pn_customer_trx_line_id,
7123: p_process_status => lv_process_status,
7124: p_process_message => lv_process_message);

Line 7182: -- because this is wrong.We need to compare the ra_customer_trx_lines_all table

7178: FOR LINK_REC IN LINK_LINE_CUR LOOP
7179: v_sql_num := 13;
7180:
7181: -- the following select statement commented and using the next one instead
7182: -- because this is wrong.We need to compare the ra_customer_trx_lines_all table
7183: -- with the link_to_cust_trx_line_id column instead of based on the customer_trx_line_id
7184: -- column in the ra_cust_trx_line_gl_dist_all table. -- bug # 2784431
7185:
7186: /*

Line 7195: FROM ra_customer_trx_lines_all

7191:
7192:
7193: SELECT COUNT(Customer_trx_line_id)
7194: INTO v_rec_ctr
7195: FROM ra_customer_trx_lines_all
7196: where link_to_cust_trx_line_id = pn_customer_trx_line_id
7197: and line_type in (lv_tax_const, lv_freight_acc_class); --rchandan for bug#4428980
7198:
7199: IF v_rec_ctr > 0 THEN

Line 7207: FROM RA_CUSTOMER_TRX_LINES_ALL

7203:
7204: DELETE RA_CUST_TRX_LINE_GL_DIST_ALL
7205: WHERE CUSTOMER_TRX_LINE_ID IN
7206: (SELECT CUSTOMER_TRX_LINE_ID
7207: FROM RA_CUSTOMER_TRX_LINES_ALL
7208: WHERE LINK_TO_CUST_TRX_LINE_ID =
7209: LINK_REC.LINK_TO_CUST_TRX_LINE_ID)
7210: AND ACCOUNT_CLASS IN (lv_tax_const, lv_freight_acc_class); --rchandan for bug#4428980
7211:

Line 7221: FROM RA_CUSTOMER_TRX_LINES_ALL

7217: AND ACCOUNT_CLASS IN
7218: (lv_tax_const, lv_freight_acc_class) --rchandan for bug#4428980
7219: AND CUSTOMER_TRX_LINE_ID IN
7220: (SELECT CUSTOMER_TRX_LINE_ID
7221: FROM RA_CUSTOMER_TRX_LINES_ALL
7222: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id
7223: AND LINK_TO_CUST_TRX_LINE_ID =
7224: pn_customer_trx_line_id
7225: AND LINE_TYPE IN

Line 7241: DELETE RA_CUSTOMER_TRX_LINES_ALL

7237:
7238:
7239: v_sql_num := 15;
7240:
7241: DELETE RA_CUSTOMER_TRX_LINES_ALL
7242: WHERE LINK_TO_CUST_TRX_LINE_ID =
7243: LINK_REC.LINK_TO_CUST_TRX_LINE_ID;
7244:
7245: v_sql_num := 16;

Line 7351: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL

7347:
7348: IF ld_gl_posted_date is NULL THEN
7349:
7350:
7351: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL
7352: (extended_amount,
7353: customer_trx_line_id,
7354: last_update_date,
7355: last_updated_by,

Line 7720: UPDATE RA_CUSTOMER_TRX_LINES_ALL

7716:
7717:
7718: ELSE
7719:
7720: UPDATE RA_CUSTOMER_TRX_LINES_ALL
7721: SET EXTENDED_AMOUNT = TEMP_REC.EXTENDED_AMOUNT,
7722: LAST_UPDATE_DATE = TEMP_REC.LAST_UPDATE_DATE,
7723: LAST_UPDATED_BY = TEMP_REC.LAST_UPDATED_BY,
7724: CREATION_DATE = TEMP_REC.CREATION_DATE,

Line 7936: UPDATE ra_customer_trx_lines_all

7932: EXIT WHEN get_ext_amt_tax%NOTFOUND;
7933: OPEN get_taxable_amt(get_ext_amt_tax_rec.customer_trx_line_id);
7934: FETCH get_taxable_amt INTO v_taxable_amt;
7935: IF v_taxable_amt = 0 THEN
7936: UPDATE ra_customer_trx_lines_all
7937: SET Taxable_amount = (v_extended_amount_line -
7938: get_ext_amt_tax_rec.extended_amount)
7939: WHERE Customer_trx_line_id =
7940: get_ext_amt_tax_rec.customer_trx_line_id

Line 8355: after process above , RA_CUSTOMER_TRX_LINES_ALL LINES FOR 'TAX' HAVE BEEN POPULATE.

8351: ln_phase := 91;
8352:
8353:
8354: /*
8355: after process above , RA_CUSTOMER_TRX_LINES_ALL LINES FOR 'TAX' HAVE BEEN POPULATE.
8356: RA_CUST_TRX_GL_DIS_ALL LINES FOR 'TAX' HAVE BEEN POPULATE.
8357: BALANCE HAVE BEEN UPDATED.
8358: TOTAL AMOUNT AND TAX AMOUNT OF JAI_AR_TRX_LINES HAVE BEEN UPDATED.
8359: THE REST LOGIC IS MAINLY INCLUDE INVOICE GENERATION

Line 10996: FROM ra_customer_trx_lines_all rtla

10992: inventory_item_id,
10993: quantity_invoiced,
10994: uom_code,
10995: unit_selling_price
10996: FROM ra_customer_trx_lines_all rtla
10997: WHERE rtla.customer_trx_id = pn_customer_trx_id
10998: AND rtla.customer_trx_line_id = pn_customer_trx_line_id;
10999:
11000: CURSOR ar_header_info_cur(pn_customer_trx_id NUMBER) IS

Line 11026: ln_unit_selling_price ra_customer_trx_lines_all.unit_selling_price%TYPE;

11022:
11023: ln_party_id ra_customer_trx_all.ship_to_customer_id%TYPE ;
11024: ln_party_site_id ra_customer_trx_all.ship_to_site_use_id%TYPE ;
11025: ld_trx_date ra_customer_trx_all.trx_date%TYPE ;
11026: ln_unit_selling_price ra_customer_trx_lines_all.unit_selling_price%TYPE;
11027: lv_module VARCHAR2(30);
11028:
11029: lv_err_mess VARCHAR2(300);
11030: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;

Line 11812: -- 3.insert tax lines to ra_customer_trx_lines_all;

11808: --For AP Accounting
11809: --For AR Updating include the follow process
11810: -- 1.calculate balance;
11811: -- 2.update tax amount/totoal amount to jai_ar_trx_lines;
11812: -- 3.insert tax lines to ra_customer_trx_lines_all;
11813: -- 4.insert tax lines to ra_cust_trx_gl_dist_all;
11814: -------------------------------------------------------------------------------
11815: BEGIN
11816: IF lv_import_status = GV_IMPORT_SUCCESS THEN