DBA Data[Home] [Help]

APPS.JMF_GTA_ARTRX_PROC dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 912: , Ra_Cust_Trx_Line_Gl_Dist_All gd

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
914: , Hz_Cust_Accounts RAC_BILL
915: , GL_PERIODS GP
916: WHERE h.complete_flag = ''Y''

Line 2017: l_gl_date Ra_Cust_Trx_Line_Gl_Dist_All.Gl_Date%TYPE;

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;
2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;

Line 2394: Ra_Cust_Trx_Line_Gl_Dist_All gd,

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,
2396: Hz_Cust_Accounts RAC_BILL,
2397: GL_PERIODS GP -- period
2398: WHERE h.complete_flag = 'Y'