APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on RA_CUST_TRX_TYPES_ALL

Line 1750: , RA_CUST_TRX_TYPES_ALL RCTT

1746:
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

Line 2383: , Ra_Cust_Trx_Types_all ctt

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

Line 2433: , Ra_Cust_Trx_Types_all ctt

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

Line 2474: , Ra_Cust_Trx_Types_all ctt

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

Line 2526: , Ra_Cust_Trx_Types_all ctt

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

Line 2573: , Ra_Cust_Trx_Types_all ctt

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

Line 2614: , Ra_Cust_Trx_Types_all ctt

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

Line 2670: , Ra_Cust_Trx_Types_all ctt

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

Line 2983: FROM RA_CUST_TRX_TYPES_ALL RCTT

2979: END IF; --( l_proc_level >= l_dbg_level )
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'

Line 3090: , ra_cust_trx_types_all t

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;
3094: EXCEPTION