DBA Data[Home] [Help]

APPS.ARP_ETAX_UTIL dependencies on RA_CUSTOMER_TRX_LINES_S

Line 204: ra_customer_trx_lines_s.nextval,

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

Line 3199: from ra_customer_trx_lines sqtl

3195:
3196: UPDATE ra_customer_trx_lines mtl
3197: SET line_recoverable = extended_amount,
3198: tax_recoverable = (select sum(extended_amount)
3199: from ra_customer_trx_lines sqtl
3200: where sqtl.link_to_cust_trx_line_id =
3201: mtl.customer_trx_line_id
3202: and sqtl.customer_trx_id =
3203: mtl.customer_trx_id

Line 3218: from ra_customer_trx_lines sqtl

3214: specified */
3215: UPDATE ra_customer_trx_lines mtl
3216: SET line_recoverable = extended_amount,
3217: tax_recoverable = (select sum(extended_amount)
3218: from ra_customer_trx_lines sqtl
3219: where sqtl.link_to_cust_trx_line_id =
3220: mtl.customer_trx_line_id
3221: and sqtl.customer_trx_id =
3222: mtl.customer_trx_id