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.AR_GTA_ARTRX_PROC dependencies on RA_CUSTOMER_TRX_ALL

Line 946: ra_customer_trx_all h

942: END IF;
943:
944: l_select_sql := 'SELECT h.customer_trx_id
945: FROM
946: ra_customer_trx_all h
947: , ra_cust_trx_types_all ctt
948: , ra_batches_all b
949: , Ra_Cust_Trx_Line_Gl_Dist_All gd
950: , Hz_Parties RAC_BILL_PARTY

Line 1804: l_ar_currency_code ra_customer_trx_all.Invoice_Currency_Code%TYPE;

1800: l_procedure_name VARCHAR2(50) := 'Get_AR_Currency_Cond';
1801: l_error_string VARCHAR2(500);
1802:
1803: l_parameter_token VARCHAR2(10) := ':currency';
1804: l_ar_currency_code ra_customer_trx_all.Invoice_Currency_Code%TYPE;
1805:
1806: l_specific_currency_code ar_gta_rule_headers_all.specific_currency_code%TYPE;
1807: l_gta_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
1808:

Line 2071: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

2067: -- a flag which adjust the trx record is new,
2068: -- if dul_flag>1, the trx record is old ,else is new
2069: l_dul_flag NUMBER := 0;
2070:
2071: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2072: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2073: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

Line 2072: l_trx_number ra_customer_trx_all.trx_number%TYPE;

2068: -- if dul_flag>1, the trx record is old ,else is new
2069: l_dul_flag NUMBER := 0;
2070:
2071: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2072: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2073: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;

Line 2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;

2070:
2071: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2072: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2073: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;

Line 2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

2071: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2072: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2073: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;

Line 2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;

2072: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2073: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2080: l_ctt_class ra_cust_trx_types_all.type%TYPE;

Line 2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

2073: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2080: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2081: l_period_name GL_PERIODS.Period_Name%TYPE;

Line 2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;

2074: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2080: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2081: l_period_name GL_PERIODS.Period_Name%TYPE;
2082: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;

Line 2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;

2075: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2080: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2081: l_period_name GL_PERIODS.Period_Name%TYPE;
2082: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2083:

Line 2082: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;

2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2080: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2081: l_period_name GL_PERIODS.Period_Name%TYPE;
2082: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2083:
2084: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
2085: l_invoice_type_code ar_gta_tax_limits_all.invoice_type%TYPE; --added for bug 13942623
2086:

Line 2138: l_legal_entity_id ra_customer_trx_all.legal_entity_id%TYPE;

2134: l_quantity_invoiced NUMBER;
2135: l_unit_selling_price NUMBER;
2136:
2137: l_tax_line_count NUMBER;
2138: l_legal_entity_id ra_customer_trx_all.legal_entity_id%TYPE;
2139:
2140: -- the data get from ebtax
2141: l_tax_amount_func_curr zx_lines.tax_amt_funcl_curr%TYPE;
2142: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;

Line 2487: FROM ra_customer_trx_all h,

2483: l_legal_entity_id,
2484: l_ct_reference,
2485: l_ctt_class,
2486: l_period_name
2487: FROM ra_customer_trx_all h,
2488: ra_cust_trx_types_all ctt,
2489: ra_batches_all b,
2490: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2491: Hz_Parties RAC_BILL_PARTY,

Line 2556: ra_customer_trx_all h

2552: Hz_Cust_Acct_Sites_All RAA_BILL,
2553: HZ_PARTY_SITES RAA_BILL_PS,
2554: Hz_Locations RAA_BILL_LOC,
2555: FND_TERRITORIES_VL FT_BILL,
2556: ra_customer_trx_all h
2557: WHERE h.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID
2558: AND SU_BILL.CUST_ACCT_SITE_ID = RAA_BILL.CUST_ACCT_SITE_ID
2559: AND RAA_BILL.PARTY_SITE_ID = RAA_BILL_PS.PARTY_SITE_ID
2560: AND RAA_BILL_PS.LOCATION_ID = RAA_BILL_LOC.LOCATION_ID

Line 2600: ra_customer_trx_all h

2596: --,Hz_Cust_Accounts RAC_BILL
2597: --,Hz_Parties RAC_BILL_PARTY
2598: --Yao delete end for bug#8769687
2599: ,
2600: ra_customer_trx_all h
2601: --Yao add for bug#8769687
2602: ,
2603: hz_party_sites hps,
2604: hz_cust_acct_sites_all hcasa,

Line 2650: FROM ra_customer_trx_all h,

2646: RAC_BILL_PARTY.JGZZ_FISCAL_CODE
2647: INTO l_rac_bill_to_customer_name,
2648: l_rac_bill_to_customer_num,
2649: l_bill_to_taxpayer_id
2650: FROM ra_customer_trx_all h,
2651: Hz_Cust_Accounts rac_bill,
2652: Hz_Parties rac_bill_party
2653: WHERE h.customer_trx_id = l_customer_trx_id
2654: AND h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID

Line 2775: FROM ra_customer_trx_all

2771:
2772: --yao zhang add for bug 8234250 begin
2773: SELECT previous_customer_trx_id
2774: INTO l_origin_trx_id
2775: FROM ra_customer_trx_all
2776: WHERE customer_trx_id = l_customer_trx_id;
2777: --yao zhang add end for bug 8234250
2778:
2779: --29/06/2006 Added by Shujuan Yan for bug 5263131

Line 3228: FROM ra_customer_trx_all

3224: END IF; /*(l_invoice_type = '2' and l_ctt_class = 'CM')*/
3225: --checking whether CM is associated with AR invoice or not
3226: SELECT previous_customer_trx_id
3227: INTO l_pre_cus_trxid
3228: FROM ra_customer_trx_all
3229: WHERE customer_trx_id = l_customer_trx_id;
3230: IF (l_pre_cus_trxid is not null) then
3231: -- this credit memo is credited with AR invoice
3232: --Select all AR invoices associated with credit memo.

Line 3469: ra_customer_trx_all rct

3465:
3466: SELECT name
3467: INTO l_trx_typ
3468: FROM ra_cust_trx_types_all rctt,
3469: ra_customer_trx_all rct
3470: WHERE rct.cust_trx_type_id = rctt.cust_trx_type_id(+)
3471: AND rct.org_id = rctt.org_id(+)
3472: AND rct.customer_trx_id = l_customer_trx_id
3473: AND rct.org_id = p_org_id;