APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

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

Line 2299: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_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'));
2299: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2300: :=nvl(p_AR_Trx_GL_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2301:
2302: l_AR_Trx_Batch_From ra_batches_all.name%TYPE :=nvl(p_AR_Trx_Batch_From,' ');
2303: l_AR_Trx_Batch_to ra_batches_all.name%TYPE

Line 2384: , RA_CUST_TRX_LINE_GL_DIST_all gd

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

Line 2434: , RA_CUST_TRX_LINE_GL_DIST_all gd

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

Line 2475: , RA_CUST_TRX_LINE_GL_DIST_all gd

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

Line 2527: , RA_CUST_TRX_LINE_GL_DIST_all gd

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

Line 2574: , RA_CUST_TRX_LINE_GL_DIST_all gd

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

Line 2615: , RA_CUST_TRX_LINE_GL_DIST_all gd

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

Line 2671: , RA_CUST_TRX_LINE_GL_DIST_all gd

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