APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on RA_CUST_TRX_TYPES_ALL

Line 1945: , RA_CUST_TRX_TYPES_ALL RCTT

1941: --Yao Zhang add for bug8605196 end
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

Line 2605: , Ra_Cust_Trx_Types_all ctt

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

Line 2655: , Ra_Cust_Trx_Types_all ctt

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

Line 2696: , Ra_Cust_Trx_Types_all ctt

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

Line 2748: , Ra_Cust_Trx_Types_all ctt

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

Line 2795: , Ra_Cust_Trx_Types_all ctt

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

Line 2836: , Ra_Cust_Trx_Types_all ctt

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

Line 2892: , Ra_Cust_Trx_Types_all ctt

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

Line 3205: FROM RA_CUST_TRX_TYPES_ALL RCTT

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

Line 3330: , ra_cust_trx_types_all t

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