DBA Data[Home] [Help]

APPS.ARP_ACCT_EVENT_PKG dependencies on RA_CUST_TRX_TYPES

Line 166: ra_cust_trx_types ctt,

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

Line 379: ra_cust_trx_types ctt,

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

Line 753: ra_cust_trx_types_all tty

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