DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on RA_CUSTOMER_TRX_LINES_S

Line 203: ra_customer_trx_lines_s.nextval,

199: PREVIOUS_CUSTOMER_TRX_ID, -- 5125882
200: ORG_ID
201: )
202: SELECT
203: ra_customer_trx_lines_s.nextval,
204: sysdate,
205: arp_standard.profile.user_id,
206: sysdate,
207: arp_standard.profile.user_id,

Line 3137: from ra_customer_trx_lines sqtl

3133:
3134: UPDATE ra_customer_trx_lines mtl
3135: SET line_recoverable = extended_amount,
3136: tax_recoverable = (select sum(extended_amount)
3137: from ra_customer_trx_lines sqtl
3138: where sqtl.link_to_cust_trx_line_id =
3139: mtl.customer_trx_line_id
3140: and sqtl.customer_trx_id =
3141: mtl.customer_trx_id

Line 3156: from ra_customer_trx_lines sqtl

3152: specified */
3153: UPDATE ra_customer_trx_lines mtl
3154: SET line_recoverable = extended_amount,
3155: tax_recoverable = (select sum(extended_amount)
3156: from ra_customer_trx_lines sqtl
3157: where sqtl.link_to_cust_trx_line_id =
3158: mtl.customer_trx_line_id
3159: and sqtl.customer_trx_id =
3160: mtl.customer_trx_id