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_AR_IMPORT_POPU_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 41: FROM ra_customer_trx_all

37:
38:
39: CURSOR complete_flag_cur IS
40: SELECT complete_flag
41: FROM ra_customer_trx_all
42: WHERE customer_trx_id = v_header_id;
43:
44: CURSOR OLD_CUSTOMER_TRX_ID_CUR IS
45: SELECT Customer_Trx_Id

Line 208: FROM ra_customer_trx_all

204:
205: CURSOR CREATED_FROM_CUR IS
206: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
207: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate
208: FROM ra_customer_trx_all
209: WHERE customer_trx_id = pr_new.customer_trx_id;
210:
211: CURSOR SO_PICKING_TAX_RECORD_CHECK IS
212: SELECT DISTINCT 1

Line 449: from ra_customer_trx_all

445: created_from ,
446: nvl(bill_to_customer_id,ship_to_customer_id) customer_id ,
447: complete_flag,--Added by Zhiwei for ZX integration
448: trx_date
449: from ra_customer_trx_all
450: where customer_trx_id = pr_new.customer_trx_id;
451:
452: CURSOR JA_SO_LINES_INFO IS
453: SELECT tax_category_id ,

Line 2981: FROM ra_customer_trx_all

2977: is
2978: --Cursor
2979: CURSOR GET_EXCHANGE_RATE IS
2980: SELECT exchange_rate
2981: FROM ra_customer_trx_all
2982: WHERE customer_trx_id = pr_new.customer_trx_id;
2983:
2984: CURSOR DUPLICATE_HDR_CUR IS
2985: SELECT 1

Line 2993: RA_CUSTOMER_TRX_ALL C,

2989: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
2990: SELECT 1
2991: FROM JAI_AR_SUP_LINES A,
2992: JAI_AR_SUP_HDRS_ALL B,
2993: RA_CUSTOMER_TRX_ALL C,
2994: RA_CUST_TRX_TYPES_ALL D
2995: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
2996: AND c.cust_trx_type_id = D.cust_trx_type_id
2997: AND c.trx_number = TO_CHAR(b.SUPPLEMENTARY_NUM)

Line 3012: RA_CUSTOMER_TRX_ALL C

3008: SELECT A.organization_id,
3009: A.Location_id
3010: FROM JAI_AR_TRXS A,
3011: JAI_AR_SUP_HDRS_ALL B,
3012: RA_CUSTOMER_TRX_ALL C
3013: WHERE pr_new.customer_trx_id = c.customer_trx_id
3014: AND c.trx_number = TO_CHAR(B.SUPPLEMENTARY_NUM)
3015: AND B.customer_trx_id = A.customer_trx_id;
3016:

Line 3027: FROM ra_customer_trx_all

3023:
3024: CURSOR CREATED_FROM_CUR IS
3025: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
3026: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate
3027: FROM ra_customer_trx_all
3028: WHERE customer_trx_id = pr_new.customer_trx_id;
3029:
3030: v_customer_trx_line_id NUMBER;
3031:

Line 3042: RA_CUSTOMER_TRX_ALL C,

3038: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
3039: SELECT 1
3040: FROM JAI_AR_SUP_LINES A,
3041: JAI_AR_SUP_HDRS_ALL B,
3042: RA_CUSTOMER_TRX_ALL C,
3043: RA_CUST_TRX_TYPES_ALL D,
3044: JAI_AR_SUP_TAXES E
3045: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
3046: AND c.cust_trx_type_id = D.cust_trx_type_id

Line 3067: ra_customer_trx_all C,

3063: t.tax_type,
3064: t.stform_type
3065: FROM JAI_AR_SUP_TAXES A,
3066: JAI_AR_SUP_LINES b,
3067: ra_customer_trx_all C,
3068: ra_cust_trx_types_all D,
3069: JAI_CMN_TAXES_ALL t
3070: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
3071: AND A.sup_inv_type = b.sup_inv_type

Line 3092: ra_customer_trx_all D,

3088: t.stform_type
3089: FROM JAI_AR_SUP_TAXES A,
3090: JAI_AR_SUP_LINES b,
3091: JAI_AR_SUP_HDRS_ALL c,
3092: ra_customer_trx_all D,
3093: ra_cust_trx_types_all e,
3094: JAI_CMN_TAXES_ALL t
3095: WHERE pr_new.customer_trx_id = D.customer_trx_id
3096: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)

Line 3119: FROM RA_CUSTOMER_TRX_ALL

3115: SELECT bill_to_customer_id,
3116: bill_to_site_use_id,
3117: trx_number,
3118: batch_source_id
3119: FROM RA_CUSTOMER_TRX_ALL
3120: WHERE customer_trx_id = pr_new.customer_trx_id;
3121:
3122: CURSOR GET_SITE(P_TRX_NUMBER VARCHAR2) IS
3123: SELECT customer_site

Line 3133: ra_customer_trx_all b,

3129: (NVL(A.excise_diff_amt,0)+NVL(A.other_diff_amt,0)) TAX_AMT,
3130: NVL(A.excise_diff_amt,0) excise_diff,
3131: A.new_assessable_value
3132: FROM JAI_AR_SUP_LINES A,
3133: ra_customer_trx_all b,
3134: ra_cust_trx_types_all c
3135: WHERE B.CUST_TRX_TYPE_ID = C.CUST_TRX_TYPE_ID
3136: AND A.SUP_INV_TYPE = DECODE(C.TYPE,'DM','DB','CM','CR','INV','SI')
3137: AND A.customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3)

Line 3146: ra_customer_trx_all c,

3142: NVL(A.excise_diff_amt,0) excise_diff,
3143: A.new_assessable_value
3144: FROM JAI_AR_SUP_LINES A,
3145: JAI_AR_SUP_HDRS_ALL b,
3146: ra_customer_trx_all c,
3147: ra_cust_trx_types_all e
3148: WHERE pr_new.customer_trx_id = c.customer_trx_id
3149: AND c.trx_number = TO_CHAR( b.SUPPLEMENTARY_NUM)
3150: AND B.customer_trx_id = A.customer_trx_id

Line 3164: ra_customer_trx_all c,

3160: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
3161: SELECT A.tax_category_id
3162: FROM JAI_AR_SUP_LINES A,
3163: JAI_AR_SUP_HDRS_ALL b,
3164: ra_customer_trx_all c,
3165: ra_cust_trx_types_all D
3166: WHERE pr_new.customer_trx_id = c.customer_trx_id
3167: AND c.trx_number =TO_CHAR( b.SUPPLEMENTARY_NUM)
3168: AND B.customer_trx_id = A.customer_trx_id

Line 3253: FROM ra_customer_trx_all

3249: AND B.Location_Id = p_location_id);
3250:
3251: CURSOR site_cur IS
3252: SELECT SHIP_TO_CUSTOMER_ID,SHIP_TO_SITE_USE_ID
3253: FROM ra_customer_trx_all
3254: WHERE customer_trx_id = pr_new.customer_trx_id
3255: AND org_id = pr_new.org_id;
3256:
3257: t_jai_line_rec_old JAI_AR_TRX_LINES%ROWTYPE;

Line 4358: FROM ra_customer_trx_all

4354:
4355: CURSOR CREATED_FROM_CUR IS
4356: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
4357: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate
4358: FROM ra_customer_trx_all
4359: WHERE customer_trx_id = v_header_id;
4360:
4361: CURSOR so_picking_hdr_info_1 IS
4362: SELECT a.organization_id, a.location_id

Line 4378: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

4374: v_trans_type VARCHAR2(30);
4375:
4376: CURSOR transaction_type_cur IS
4377: SELECT A.TYPE
4378: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
4379: WHERE A.cust_trx_type_id = b.cust_trx_type_id
4380: AND b.customer_trx_id = v_header_id
4381: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
4382:

Line 4843: FROM ra_customer_trx_all

4839: CURSOR CREATED_FROM_CUR IS
4840: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
4841: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate,
4842: legal_entity_id
4843: FROM ra_customer_trx_all
4844: WHERE customer_trx_id = v_header_id;
4845:
4846:
4847:

Line 4911: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

4907:
4908: v_trans_type VARCHAR2(30);
4909: CURSOR transaction_type_cur IS
4910: SELECT A.TYPE
4911: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
4912: WHERE A.cust_trx_type_id = b.cust_trx_type_id
4913: AND b.customer_trx_id = v_header_id
4914: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
4915:

Line 4933: ra_customer_trx_all rct,

4929: IS
4930: SELECT
4931: ott.transaction_type_id
4932: FROM
4933: ra_customer_trx_all rct,
4934: oe_transaction_types_tl ott
4935: WHERE
4936: rct.customer_trx_id = pr_new.previous_customer_trx_id
4937: AND rct.interface_header_attribute2 = ott.name ;

Line 5039: from ra_customer_trx_all

5035: exchange_rate ,
5036: created_from ,
5037: nvl(bill_to_customer_id,ship_to_customer_id) customer_id ,
5038: trx_date
5039: from ra_customer_trx_all
5040: where customer_trx_id = pr_new.customer_trx_id;
5041:
5042: CURSOR SO_RMA_LINES_INFO IS
5043: --added unit_code,line_amount

Line 6247: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

6243:
6244: -- cursor to get transaction type
6245: CURSOR c_transaction_type IS
6246: SELECT A.TYPE
6247: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
6248: WHERE A.cust_trx_type_id = b.cust_trx_type_id
6249: AND b.customer_trx_id = r_new.customer_trx_id
6250: AND NVL(A.org_id,0) = NVL(r_new.org_id,0);
6251:

Line 6262: from ra_customer_trx_all

6258: , primary_salesrep_id ,invoice_currency_code, exchange_rate_type
6259: , exchange_date, exchange_rate
6260: , legal_entity_id
6261: , complete_flag --Added by Zhiwei for ZX integration of AR
6262: from ra_customer_trx_all
6263: where customer_trx_id = r_new.customer_trx_id;
6264: r_ra_customer_trx c_ra_customer_trx%rowtype;
6265:
6266: cursor c_jai_ra_customer_trx is

Line 6734: FROM RA_CUSTOMER_TRX_ALL

6730: IS
6731:
6732: CURSOR cur_legal_entity_id IS
6733: SELECT legal_entity_id
6734: FROM RA_CUSTOMER_TRX_ALL
6735: WHERE customer_trx_id = pn_customer_trx_id;
6736:
6737: ln_legal_entity_id NUMBER ;
6738: