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

Line 1751: , RA_CUSTOMER_TRX_ALL RCT

1747: SELECT DISTINCT RCTT.type
1748: INTO lv_trx_type
1749: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
1750: , RA_CUST_TRX_TYPES_ALL RCTT
1751: , RA_CUSTOMER_TRX_ALL RCT
1752: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
1753: AND JGTH.source = 'AR'
1754: AND RCTT.org_id = p_GTA_trx_header.org_id
1755: AND RCT.customer_trx_id = p_GTA_trx_header.ra_trx_id;

Line 2287: l_AR_Trx_Num_From Ra_Customer_Trx_All.Trx_Number%TYPE

2283: IS
2284: l_procedure_name VARCHAR2(30):='export_Invoices_from_Conc';
2285: l_Customer_id NUMBER;
2286: l_cur_header c_trx_header_id_type;
2287: l_AR_Trx_Num_From Ra_Customer_Trx_All.Trx_Number%TYPE
2288: :=nvl(P_AR_Trx_Num_From,' ');
2289: l_AR_Trx_Num_To Ra_Customer_Trx_All.Trx_Number%TYPE
2290: :=nvl(p_AR_Trx_Num_To,lpad('z',20,'z'));
2291:

Line 2289: l_AR_Trx_Num_To Ra_Customer_Trx_All.Trx_Number%TYPE

2285: l_Customer_id NUMBER;
2286: l_cur_header c_trx_header_id_type;
2287: l_AR_Trx_Num_From Ra_Customer_Trx_All.Trx_Number%TYPE
2288: :=nvl(P_AR_Trx_Num_From,' ');
2289: l_AR_Trx_Num_To Ra_Customer_Trx_All.Trx_Number%TYPE
2290: :=nvl(p_AR_Trx_Num_To,lpad('z',20,'z'));
2291:
2292: l_AR_Trx_Date_From Ra_Customer_Trx_All.Trx_Date%TYPE
2293: :=nvl(P_AR_Trx_Date_From,to_date('1900/01/01','RRRR/MM/DD'));

Line 2292: l_AR_Trx_Date_From Ra_Customer_Trx_All.Trx_Date%TYPE

2288: :=nvl(P_AR_Trx_Num_From,' ');
2289: l_AR_Trx_Num_To Ra_Customer_Trx_All.Trx_Number%TYPE
2290: :=nvl(p_AR_Trx_Num_To,lpad('z',20,'z'));
2291:
2292: l_AR_Trx_Date_From Ra_Customer_Trx_All.Trx_Date%TYPE
2293: :=nvl(P_AR_Trx_Date_From,to_date('1900/01/01','RRRR/MM/DD'));
2294: l_AR_Trx_Date_To Ra_Customer_Trx_All.Trx_Date%TYPE
2295: :=nvl(P_AR_Trx_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2296:

Line 2294: l_AR_Trx_Date_To Ra_Customer_Trx_All.Trx_Date%TYPE

2290: :=nvl(p_AR_Trx_Num_To,lpad('z',20,'z'));
2291:
2292: l_AR_Trx_Date_From Ra_Customer_Trx_All.Trx_Date%TYPE
2293: :=nvl(P_AR_Trx_Date_From,to_date('1900/01/01','RRRR/MM/DD'));
2294: l_AR_Trx_Date_To Ra_Customer_Trx_All.Trx_Date%TYPE
2295: :=nvl(P_AR_Trx_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2296:
2297: l_AR_Trx_GL_Date_From RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2298: :=nvl(p_AR_Trx_GL_Date_From,to_date('1900/01/01','RRRR/MM/DD'));

Line 2382: , ra_customer_trx_all ar

2378: OPEN l_cur_header FOR
2379: SELECT
2380: h.*
2381: FROM JMF_GTA_TRX_HEADERS h
2382: , ra_customer_trx_all ar
2383: , Ra_Cust_Trx_Types_all ctt
2384: , RA_CUST_TRX_LINE_GL_DIST_all gd
2385: , ra_batches_all b
2386: WHERE h.org_id = p_ORG_ID

Line 2432: , ra_customer_trx_all ar

2428: AND JGTHA.status IN ('GENERATED', 'COMPLETED')
2429:
2430: AND JGTHA.description IN /*( SELECT h.description
2431: FROM JMF_GTA_TRX_HEADERS h
2432: , ra_customer_trx_all ar
2433: , Ra_Cust_Trx_Types_all ctt
2434: , RA_CUST_TRX_LINE_GL_DIST_all gd
2435: , ra_batches_all b
2436: WHERE ( h.org_id = p_ORG_ID

Line 2473: , ra_customer_trx_all ar

2469: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2470: INTERSECT
2471: SELECT h.description
2472: FROM JMF_GTA_TRX_HEADERS h
2473: , ra_customer_trx_all ar
2474: , Ra_Cust_Trx_Types_all ctt
2475: , RA_CUST_TRX_LINE_GL_DIST_all gd
2476: , ra_batches_all b
2477: WHERE h.org_id = p_ORG_ID

Line 2525: , ra_customer_trx_all ar

2521: , JGTHA.description
2522: , JGTHA.org_id
2523: , JGTHA.gta_trx_number
2524: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2525: , ra_customer_trx_all ar
2526: , Ra_Cust_Trx_Types_all ctt
2527: , RA_CUST_TRX_LINE_GL_DIST_all gd
2528: , ra_batches_all b
2529: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'

Line 2572: , ra_customer_trx_all ar

2568: AND JGTHA.invoice_type = P_Invoice_Type_ID
2569:
2570: AND JGTHA.description IN /*( SELECT h.description
2571: FROM JMF_GTA_TRX_HEADERS h
2572: , ra_customer_trx_all ar
2573: , Ra_Cust_Trx_Types_all ctt
2574: , RA_CUST_TRX_LINE_GL_DIST_all gd
2575: , ra_batches_all b
2576: WHERE ( h.org_id = p_ORG_ID

Line 2613: , ra_customer_trx_all ar

2609: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2610: INTERSECT
2611: SELECT h.description
2612: FROM JMF_GTA_TRX_HEADERS h
2613: , ra_customer_trx_all ar
2614: , Ra_Cust_Trx_Types_all ctt
2615: , RA_CUST_TRX_LINE_GL_DIST_all gd
2616: , ra_batches_all b
2617: WHERE h.org_id = p_ORG_ID

Line 2669: , ra_customer_trx_all ar

2665: /* OPEN l_cur_header FOR
2666: SELECT
2667: h.*
2668: FROM JMF_GTA_TRX_HEADERS h
2669: , ra_customer_trx_all ar
2670: , Ra_Cust_Trx_Types_all ctt
2671: , RA_CUST_TRX_LINE_GL_DIST_all gd
2672: , ra_batches_all b
2673: WHERE h.org_id = p_ORG_ID

Line 2984: , RA_CUSTOMER_TRX_ALL RCT

2980:
2981: SELECT DISTINCT RCTT.type
2982: INTO lv_class_type
2983: FROM RA_CUST_TRX_TYPES_ALL RCTT
2984: , RA_CUSTOMER_TRX_ALL RCT
2985: , JMF_GTA_TRX_HEADERS_ALL JGTH
2986: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
2987: AND JGTH.source = 'AR'
2988: AND RCTT.org_id = p_GTA_org_id

Line 3089: FROM ra_customer_trx_all ct

3085: IF (p_GTA_trx_header.invoice_type = '2') then
3086: BEGIN
3087: SELECT t.TYPE
3088: INTO l_trx_class
3089: FROM ra_customer_trx_all ct
3090: , ra_cust_trx_types_all t
3091: WHERE ct.cust_trx_type_id = t.cust_trx_type_id
3092: AND ct.customer_trx_id=p_GTA_trx_header.ra_trx_id
3093: AND t.org_id=p_GTA_trx_header.org_id;