DBA Data[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_TRANSMISSIONS

Line 3318: AR_TRANSMISSIONS_all TR

3314: from
3315: AR_TRANS_FIELD_FORMATS FF,
3316: AR_TRANS_RECORD_FORMATS RF,
3317: AR_PAYMENTS_INTERFACE_all PI,
3318: AR_TRANSMISSIONS_all TR
3319: where TR.transmission_request_id = p_trans_req_id
3320: and PI.transmission_record_id = p_trans_rec_id
3321: and RF.transmission_format_id = TR.requested_trans_format_id
3322: and RF.record_identifier = PI.record_type

Line 3431: ar_trans_record_formats format, ar_transmissions transmissions,

3427: and invoice_number = inv_num
3428: and transmission_record_id in (
3429: select overflow.transmission_record_id
3430: from ar_payments_interface payment, ar_payments_interface overflow,
3431: ar_trans_record_formats format, ar_transmissions transmissions,
3432: ar_interim_cash_receipts cash
3433: where payment.check_number = cash.receipt_number
3434: and payment.transmission_request_id = overflow.transmission_request_id
3435: and payment.item_number = overflow.item_number