APPS.ARP_DET_DIST_PKG dependencies on RA_CUST_TRX_TYPES

Line 8408: ra_cust_trx_types ctt

8404: inv.customer_trx_id
8405: FROM
8406: ra_customer_trx inv,
8407: ra_cust_trx_line_gl_dist gld,
8408: ra_cust_trx_types ctt
8409: WHERE inv.customer_trx_id = gld.customer_trx_id
8410: AND ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
8411: AND inv.request_id = p_request_id
8412: AND ctt.TYPE in ('INV','DM')

Line 8420: ra_cust_trx_types ctt

8416: SELECT
8417: customer_trx_id
8418: FROM
8419: ra_customer_trx inv,
8420: ra_cust_trx_types ctt
8421: WHERE request_id = P_request_id
8422: AND ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
8423: AND ctt.TYPE in ('INV','DM')
8424: AND EXISTS

Line 8536: FROM ra_cust_trx_types ctt

8532: UPDATE ra_customer_trx inv SET upgrade_method = 'R12'
8533: WHERE request_id = p_request_id
8534: AND EXISTS
8535: ( SELECT 1
8536: FROM ra_cust_trx_types ctt
8537: WHERE ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
8538: AND ctt.TYPE in ('INV','DM'))
8539: AND NOT EXISTS (
8540: SELECT 1

Line 11752: -- ra_cust_trx_types typ,

11748: -- ) -- LINE_ORIGIN
11749: --}
11750: FROM ra_customer_trx_lines tl,
11751: -- ra_customer_trx br,
11752: -- ra_cust_trx_types typ,
11753: -- Amount for original and remaining for all type of lines on reve line
11754: (SELECT SUM(AMOUNT) sum_amt,
11755: SUM(ACCTD_AMOUNT) sum_acctd_amt,
11756: customer_trx_line_id

Line 11877: -- ra_cust_trx_types typ

11873: -- ) -- LINE_ORIGIN
11874: --}
11875: FROM ra_customer_trx_lines tl
11876: -- ra_customer_trx br,
11877: -- ra_cust_trx_types typ
11878: WHERE tl.customer_trx_id = p_customer_trx_id
11879: AND (tl.customer_trx_line_id = NVL(p_customer_trx_line_id, tl.customer_trx_line_id)
11880: OR tl.link_to_cust_trx_line_id = NVL(p_customer_trx_line_id, tl.customer_trx_line_id));
11881: -- AND tl.br_ref_customer_trx_id = br.customer_trx_id(+)