APPS.ARP_DET_DIST_PKG dependencies on RA_CUST_TRX_TYPES

Line 9825: ra_cust_trx_types ctt

9821: inv.customer_trx_id
9822: FROM
9823: ra_customer_trx inv,
9824: ra_cust_trx_line_gl_dist gld,
9825: ra_cust_trx_types ctt
9826: WHERE inv.customer_trx_id = gld.customer_trx_id
9827: AND ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
9828: AND inv.request_id = p_request_id
9829: AND ctt.TYPE in ('INV','DM')

Line 9837: ra_cust_trx_types ctt

9833: SELECT
9834: customer_trx_id
9835: FROM
9836: ra_customer_trx inv,
9837: ra_cust_trx_types ctt
9838: WHERE request_id = P_request_id
9839: AND ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
9840: AND ctt.TYPE in ('INV','DM')
9841: AND EXISTS

Line 9953: FROM ra_cust_trx_types ctt

9949: UPDATE ra_customer_trx inv SET upgrade_method = 'R12'
9950: WHERE request_id = p_request_id
9951: AND EXISTS
9952: ( SELECT 1
9953: FROM ra_cust_trx_types ctt
9954: WHERE ctt.CUST_TRX_TYPE_ID = inv.CUST_TRX_TYPE_ID
9955: AND ctt.TYPE in ('INV','DM'))
9956: AND NOT EXISTS (
9957: SELECT 1

Line 13220: -- ra_cust_trx_types typ,

13216: -- ) -- LINE_ORIGIN
13217: --}
13218: FROM ra_customer_trx_lines tl,
13219: -- ra_customer_trx br,
13220: -- ra_cust_trx_types typ,
13221: -- Amount for original and remaining for all type of lines on reve line
13222: (SELECT SUM(AMOUNT) sum_amt,
13223: SUM(ACCTD_AMOUNT) sum_acctd_amt,
13224: customer_trx_line_id

Line 13362: -- ra_cust_trx_types typ

13358: -- ) -- LINE_ORIGIN
13359: --}
13360: FROM ra_customer_trx_lines tl
13361: -- ra_customer_trx br,
13362: -- ra_cust_trx_types typ
13363: WHERE tl.customer_trx_id = p_customer_trx_id
13364: AND (tl.customer_trx_line_id = NVL(p_customer_trx_line_id, tl.customer_trx_line_id)
13365: OR tl.link_to_cust_trx_line_id = NVL(p_customer_trx_line_id, tl.customer_trx_line_id));
13366: -- AND tl.br_ref_customer_trx_id = br.customer_trx_id(+)