APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 2519: l_AR_Trx_GL_Date_From RA_CUST_TRX_LINE_GL_DIST_all.Gl_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'));
2521: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2522: :=nvl(p_AR_Trx_GL_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2523:

Line 2521: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_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'));
2521: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2522: :=nvl(p_AR_Trx_GL_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2523:
2524: l_AR_Trx_Batch_From ra_batches_all.name%TYPE :=nvl(p_AR_Trx_Batch_From,' ');
2525: l_AR_Trx_Batch_to ra_batches_all.name%TYPE

Line 2606: , RA_CUST_TRX_LINE_GL_DIST_all gd

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
2609: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2610: AND ctt.ORG_ID = p_org_id

Line 2656: , RA_CUST_TRX_LINE_GL_DIST_all gd

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
2659: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2660: AND ctt.ORG_ID = p_org_id

Line 2697: , RA_CUST_TRX_LINE_GL_DIST_all gd

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
2700: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2701: AND ctt.ORG_ID = p_org_id

Line 2749: , RA_CUST_TRX_LINE_GL_DIST_all gd

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'
2752: AND JGTHA.status = 'DRAFT'
2753:

Line 2796: , RA_CUST_TRX_LINE_GL_DIST_all gd

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
2799: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2800: AND ctt.ORG_ID = p_org_id

Line 2837: , RA_CUST_TRX_LINE_GL_DIST_all gd

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
2840: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2841: AND ctt.ORG_ID = p_org_id

Line 2893: , RA_CUST_TRX_LINE_GL_DIST_all gd

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
2896: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2897: AND ctt.ORG_ID = p_org_id