DBA Data[Home] [Help]

APPS.AR_REVENUEADJUST_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 865: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type DEFAULT NULL

861: ,x_msg_count OUT NOCOPY NUMBER
862: ,x_msg_data OUT NOCOPY VARCHAR2
863: ,p_org_id IN NUMBER DEFAULT NULL
864: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%type
865: ,p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%type DEFAULT NULL
866: ,p_contingency_id IN ar_line_conts.contingency_id%type DEFAULT NULL
867: ,p_expiration_date IN ar_line_conts.expiration_date%type DEFAULT NULL
868: ,p_expiration_days IN ar_line_conts.expiration_days%type DEFAULT NULL)
869: IS

Line 891: ra_customer_trx_lines tl,

887: 'TRANSACTION_DATE', trunc(t.trx_date),
888: 'SHIP_CONFIRM_DATE', trunc(t.ship_date_actual), NULL))
889: expiration_event_date
890: from ra_customer_trx t,
891: ra_customer_trx_lines tl,
892: ar_line_conts lc,
893: ar_deferral_reasons dr
894: where t.customer_trx_id = p_customer_trx_id
895: and t.customer_trx_id = tl.customer_trx_id