DBA Data[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_TRANSMISSIONS

Line 3309: AR_TRANSMISSIONS_all TR

3305: from
3306: AR_TRANS_FIELD_FORMATS FF,
3307: AR_TRANS_RECORD_FORMATS RF,
3308: AR_PAYMENTS_INTERFACE_all PI,
3309: AR_TRANSMISSIONS_all TR
3310: where TR.transmission_request_id = p_trans_req_id
3311: and PI.transmission_record_id = p_trans_rec_id
3312: and RF.transmission_format_id = TR.requested_trans_format_id
3313: and RF.record_identifier = PI.record_type

Line 3403: ar_trans_record_formats format, ar_transmissions transmissions,

3399: and invoice_number = inv_num
3400: and transmission_record_id in (
3401: select overflow.transmission_record_id
3402: from ar_payments_interface payment, ar_payments_interface overflow,
3403: ar_trans_record_formats format, ar_transmissions transmissions,
3404: ar_interim_cash_receipts cash
3405: where payment.check_number = cash.receipt_number
3406: and payment.transmission_request_id = overflow.transmission_request_id
3407: and payment.item_number = overflow.item_number