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

Line 909: ra_customer_trx_all h

905: END IF;
906:
907: l_select_sql := 'SELECT h.customer_trx_id
908: FROM
909: ra_customer_trx_all h
910: , ra_cust_trx_types_all ctt
911: , ra_batches_all b
912: , Ra_Cust_Trx_Line_Gl_Dist_All gd
913: , Hz_Parties RAC_BILL_PARTY

Line 1768: l_ar_currency_code ra_customer_trx_all.Invoice_Currency_Code%TYPE;

1764: l_procedure_name VARCHAR2(50) := 'Get_AR_Currency_Cond';
1765: l_error_string VARCHAR2(500);
1766:
1767: l_parameter_token VARCHAR2(10) := ':currency';
1768: l_ar_currency_code ra_customer_trx_all.Invoice_Currency_Code%TYPE;
1769:
1770: l_specific_currency_code jmf_gta_rule_headers_all.specific_currency_code%TYPE;
1771: l_gta_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1772:

Line 2015: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;

2011: -- a flag which adjust the trx record is new,
2012: -- if dul_flag>1, the trx record is old ,else is new
2013: l_dul_flag NUMBER := 0;
2014:
2015: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2016: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2017: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2018: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

Line 2016: l_trx_number ra_customer_trx_all.trx_number%TYPE;

2012: -- if dul_flag>1, the trx record is old ,else is new
2013: l_dul_flag NUMBER := 0;
2014:
2015: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2016: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2017: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2018: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;

Line 2018: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;

2014:
2015: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2016: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2017: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2018: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;

Line 2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;

2015: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2016: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2017: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2018: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;

Line 2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;

2016: l_trx_number ra_customer_trx_all.trx_number%TYPE;
2017: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2018: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;

Line 2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

2017: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;
2018: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2025: l_period_name GL_PERIODS.Period_Name%TYPE;

Line 2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;

2018: l_set_of_books_id ra_customer_trx_all.Set_Of_Books_Id%TYPE;
2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2025: l_period_name GL_PERIODS.Period_Name%TYPE;
2026: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;

Line 2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;

2019: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2025: l_period_name GL_PERIODS.Period_Name%TYPE;
2026: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2027:

Line 2026: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;

2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2025: l_period_name GL_PERIODS.Period_Name%TYPE;
2026: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2027:
2028: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;
2029:
2030: l_raa_bill_to_concat_address VARCHAR2(500);

Line 2075: l_legal_entity_id ra_customer_trx_all.legal_entity_id%TYPE;

2071: l_quantity_invoiced NUMBER;
2072: l_unit_selling_price NUMBER;
2073:
2074: l_tax_line_count NUMBER;
2075: l_legal_entity_id ra_customer_trx_all.legal_entity_id%TYPE;
2076:
2077: -- the data get from ebtax
2078: l_tax_amount_func_curr zx_lines.tax_amt_funcl_curr%TYPE;
2079: l_taxable_amount_func_curr zx_lines.taxable_amt_funcl_curr%TYPE;

Line 2391: FROM ra_customer_trx_all h,

2387: l_legal_entity_id,
2388: l_ct_reference,
2389: l_ctt_class,
2390: l_period_name
2391: FROM ra_customer_trx_all h,
2392: ra_cust_trx_types_all ctt,
2393: ra_batches_all b,
2394: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2395: Hz_Parties RAC_BILL_PARTY,

Line 2455: ra_customer_trx_all h

2451: Hz_Cust_Acct_Sites_All RAA_BILL,
2452: HZ_PARTY_SITES RAA_BILL_PS,
2453: Hz_Locations RAA_BILL_LOC,
2454: FND_TERRITORIES_VL FT_BILL,
2455: ra_customer_trx_all h
2456: WHERE h.BILL_TO_SITE_USE_ID = SU_BILL.SITE_USE_ID
2457: AND SU_BILL.CUST_ACCT_SITE_ID = RAA_BILL.CUST_ACCT_SITE_ID
2458: AND RAA_BILL.PARTY_SITE_ID = RAA_BILL_PS.PARTY_SITE_ID
2459: AND RAA_BILL_PS.LOCATION_ID = RAA_BILL_LOC.LOCATION_ID

Line 2496: ra_customer_trx_all h

2492: INTO l_phone_number
2493: FROM Hz_Contact_Points p,
2494: Hz_Cust_Accounts RAC_BILL,
2495: Hz_Parties RAC_BILL_PARTY,
2496: ra_customer_trx_all h
2497: WHERE -- h.bill_to_customer_id can find by customer trx id
2498: h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID
2499: AND rac_bill.party_id = RAC_BILL_PARTY.Party_Id
2500: AND RAC_BILL_PARTY.Party_Id = p.owner_table_id(+)

Line 2527: FROM ra_customer_trx_all h,

2523: RAC_BILL_PARTY.JGZZ_FISCAL_CODE
2524: INTO l_rac_bill_to_customer_name,
2525: l_rac_bill_to_customer_num,
2526: l_bill_to_taxpayer_id
2527: FROM ra_customer_trx_all h,
2528: Hz_Cust_Accounts rac_bill,
2529: Hz_Parties rac_bill_party
2530: WHERE h.customer_trx_id = l_customer_trx_id
2531: AND h.bill_to_customer_id = RAC_BILL.CUST_ACCOUNT_ID

Line 2899: from ra_customer_trx_all

2895: END IF;
2896: --checking whether CM is associated with AR invoice or not
2897: select previous_customer_trx_id
2898: into l_pre_cus_trxid
2899: from ra_customer_trx_all
2900: where customer_trx_id = l_customer_trx_id;
2901: IF (l_pre_cus_trxid is not null) then
2902: -- this credit memo is credited with AR invoice
2903: --Select all AR invoices associated with credit memo.

Line 3126: FROM ra_cust_trx_types_all rctt, ra_customer_trx_all rct

3122: IF l_proce_error_buffer = 'JMF_GTA_MISSING_INVOICE_TYPE' THEN
3123:
3124: SELECT name
3125: INTO l_trx_typ
3126: FROM ra_cust_trx_types_all rctt, ra_customer_trx_all rct
3127: WHERE rct.cust_trx_type_id = rctt.cust_trx_type_id(+)
3128: AND rct.org_id = rctt.org_id(+)
3129: AND rct.customer_trx_id = l_customer_trx_id
3130: AND rct.org_id = p_org_id;