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

Line 1946: , RA_CUSTOMER_TRX_ALL RCT

1942: SELECT DISTINCT RCTT.type
1943: INTO lv_trx_type
1944: FROM AR_GTA_TRX_HEADERS_ALL JGTH
1945: , RA_CUST_TRX_TYPES_ALL RCTT
1946: , RA_CUSTOMER_TRX_ALL RCT
1947: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
1948: AND JGTH.source = 'AR'
1949: AND RCTT.org_id = p_GTA_trx_header.org_id
1950: AND RCT.customer_trx_id = p_GTA_trx_header.ra_trx_id;

Line 2509: l_AR_Trx_Num_From Ra_Customer_Trx_All.Trx_Number%TYPE

2505: IS
2506: l_procedure_name VARCHAR2(30):='export_Invoices_from_Conc';
2507: l_Customer_id NUMBER;
2508: l_cur_header c_trx_header_id_type;
2509: l_AR_Trx_Num_From Ra_Customer_Trx_All.Trx_Number%TYPE
2510: :=nvl(P_AR_Trx_Num_From,' ');
2511: l_AR_Trx_Num_To Ra_Customer_Trx_All.Trx_Number%TYPE
2512: :=nvl(p_AR_Trx_Num_To,lpad('z',20,'z'));
2513:

Line 2511: l_AR_Trx_Num_To Ra_Customer_Trx_All.Trx_Number%TYPE

2507: l_Customer_id NUMBER;
2508: l_cur_header c_trx_header_id_type;
2509: l_AR_Trx_Num_From Ra_Customer_Trx_All.Trx_Number%TYPE
2510: :=nvl(P_AR_Trx_Num_From,' ');
2511: l_AR_Trx_Num_To Ra_Customer_Trx_All.Trx_Number%TYPE
2512: :=nvl(p_AR_Trx_Num_To,lpad('z',20,'z'));
2513:
2514: l_AR_Trx_Date_From Ra_Customer_Trx_All.Trx_Date%TYPE
2515: :=nvl(P_AR_Trx_Date_From,to_date('1900/01/01','RRRR/MM/DD'));

Line 2514: l_AR_Trx_Date_From Ra_Customer_Trx_All.Trx_Date%TYPE

2510: :=nvl(P_AR_Trx_Num_From,' ');
2511: l_AR_Trx_Num_To Ra_Customer_Trx_All.Trx_Number%TYPE
2512: :=nvl(p_AR_Trx_Num_To,lpad('z',20,'z'));
2513:
2514: l_AR_Trx_Date_From Ra_Customer_Trx_All.Trx_Date%TYPE
2515: :=nvl(P_AR_Trx_Date_From,to_date('1900/01/01','RRRR/MM/DD'));
2516: l_AR_Trx_Date_To Ra_Customer_Trx_All.Trx_Date%TYPE
2517: :=nvl(P_AR_Trx_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2518:

Line 2516: l_AR_Trx_Date_To Ra_Customer_Trx_All.Trx_Date%TYPE

2512: :=nvl(p_AR_Trx_Num_To,lpad('z',20,'z'));
2513:
2514: l_AR_Trx_Date_From Ra_Customer_Trx_All.Trx_Date%TYPE
2515: :=nvl(P_AR_Trx_Date_From,to_date('1900/01/01','RRRR/MM/DD'));
2516: l_AR_Trx_Date_To Ra_Customer_Trx_All.Trx_Date%TYPE
2517: :=nvl(P_AR_Trx_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2518:
2519: l_AR_Trx_GL_Date_From RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2520: :=nvl(p_AR_Trx_GL_Date_From,to_date('1900/01/01','RRRR/MM/DD'));

Line 2604: , ra_customer_trx_all ar

2600: OPEN l_cur_header FOR
2601: SELECT
2602: h.*
2603: FROM AR_GTA_TRX_HEADERS h
2604: , ra_customer_trx_all ar
2605: , Ra_Cust_Trx_Types_all ctt
2606: , RA_CUST_TRX_LINE_GL_DIST_all gd
2607: , ra_batches_all b
2608: WHERE h.org_id = p_ORG_ID

Line 2654: , ra_customer_trx_all ar

2650: AND JGTHA.status IN ('GENERATED', 'COMPLETED')
2651:
2652: AND JGTHA.description IN /*( SELECT h.description
2653: FROM AR_GTA_TRX_HEADERS h
2654: , ra_customer_trx_all ar
2655: , Ra_Cust_Trx_Types_all ctt
2656: , RA_CUST_TRX_LINE_GL_DIST_all gd
2657: , ra_batches_all b
2658: WHERE ( h.org_id = p_ORG_ID

Line 2695: , ra_customer_trx_all ar

2691: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2692: INTERSECT
2693: SELECT h.description
2694: FROM AR_GTA_TRX_HEADERS h
2695: , ra_customer_trx_all ar
2696: , Ra_Cust_Trx_Types_all ctt
2697: , RA_CUST_TRX_LINE_GL_DIST_all gd
2698: , ra_batches_all b
2699: WHERE h.org_id = p_ORG_ID

Line 2747: , ra_customer_trx_all ar

2743: , JGTHA.description
2744: , JGTHA.org_id
2745: , JGTHA.gta_trx_number
2746: FROM AR_GTA_TRX_HEADERS_ALL JGTHA
2747: , ra_customer_trx_all ar
2748: , Ra_Cust_Trx_Types_all ctt
2749: , RA_CUST_TRX_LINE_GL_DIST_all gd
2750: , ra_batches_all b
2751: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'

Line 2794: , ra_customer_trx_all ar

2790: AND JGTHA.invoice_type = P_Invoice_Type_ID
2791:
2792: AND JGTHA.description IN /*( SELECT h.description
2793: FROM AR_GTA_TRX_HEADERS h
2794: , ra_customer_trx_all ar
2795: , Ra_Cust_Trx_Types_all ctt
2796: , RA_CUST_TRX_LINE_GL_DIST_all gd
2797: , ra_batches_all b
2798: WHERE ( h.org_id = p_ORG_ID

Line 2835: , ra_customer_trx_all ar

2831: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2832: INTERSECT
2833: SELECT h.description
2834: FROM AR_GTA_TRX_HEADERS h
2835: , ra_customer_trx_all ar
2836: , Ra_Cust_Trx_Types_all ctt
2837: , RA_CUST_TRX_LINE_GL_DIST_all gd
2838: , ra_batches_all b
2839: WHERE h.org_id = p_ORG_ID

Line 2891: , ra_customer_trx_all ar

2887: /* OPEN l_cur_header FOR
2888: SELECT
2889: h.*
2890: FROM AR_GTA_TRX_HEADERS h
2891: , ra_customer_trx_all ar
2892: , Ra_Cust_Trx_Types_all ctt
2893: , RA_CUST_TRX_LINE_GL_DIST_all gd
2894: , ra_batches_all b
2895: WHERE h.org_id = p_ORG_ID

Line 3206: , RA_CUSTOMER_TRX_ALL RCT

3202:
3203: SELECT DISTINCT RCTT.type
3204: INTO lv_class_type
3205: FROM RA_CUST_TRX_TYPES_ALL RCTT
3206: , RA_CUSTOMER_TRX_ALL RCT
3207: , AR_GTA_TRX_HEADERS_ALL JGTH
3208: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
3209: AND JGTH.source = 'AR'
3210: AND RCTT.org_id = p_GTA_org_id

Line 3329: FROM ra_customer_trx_all ct

3325: ELSE
3326: BEGIN
3327: SELECT t.TYPE
3328: INTO l_trx_class
3329: FROM ra_customer_trx_all ct
3330: , ra_cust_trx_types_all t
3331: WHERE ct.cust_trx_type_id = t.cust_trx_type_id
3332: AND ct.customer_trx_id=p_GTA_trx_header.ra_trx_id
3333: AND t.org_id=p_GTA_trx_header.org_id;