DBA Data[Home] [Help]

APPS.ARP_ACCT_EVENT_PKG dependencies on RA_CUST_TRX_TYPES

Line 167: ra_cust_trx_types ctt,

163: distev.event_date dist_event_date,
164: distev.transaction_date dist_ev_trx_date
165: FROM ra_customer_trx trx,
166: ra_cust_trx_line_gl_dist gld,
167: ra_cust_trx_types ctt,
168: xla_transaction_entities_upg xet,
169: xla_events ev,
170: xla_events distev
171: WHERE trx.customer_trx_id = p_source_id_int_1

Line 380: ra_cust_trx_types ctt,

376: SELECT ra.gl_date gl_date,
377: ra.customer_trx_id trx_id,
378: ra.event_id event_id
379: FROM ra_customer_trx trx,
380: ra_cust_trx_types ctt,
381: ar_receivable_applications ra
382: WHERE trx.customer_trx_id = p_source_int_id
383: AND ctt.cust_trx_type_id= trx.cust_trx_type_id
384: AND ctt.org_id = trx.org_id

Line 755: ra_cust_trx_types_all tty

751: IS
752: SELECT ctlgd.customer_trx_id
753: FROM ra_cust_trx_line_gl_dist_all ctlgd,
754: ra_customer_trx_all trx,
755: ra_cust_trx_types_all tty
756: WHERE ctlgd.gl_date BETWEEN p_start_date AND p_end_date
757: AND ctlgd.posting_control_id = -3
758: AND NVL(p_org_id,ctlgd.org_id) = p_org_id
759: AND ctlgd.account_set_flag = 'N'