APPS.ARP_LOCKBOX_HOOK_PVT dependencies on AR_TRANS_RECORD_FORMATS

Line 73: ar_trans_record_formats rf

69: 'LEFT', RTRIM(pi.lockbox_number, decode(ff.fill_character_lookup_code, 'ZERO', '0', 'BLANK', ' ')),
70: 'RIGHT', LTRIM(pi.lockbox_number,decode(ff.fill_character_lookup_code, 'ZERO', '0', 'BLANK', ' ')))
71: FROM ar_transmissions tr,
72: ar_trans_field_formats ff,
73: ar_trans_record_formats rf
74: WHERE tr.transmission_id = pi.transmission_id
75: AND ff.transmission_format_id = tr.requested_trans_format_id
76: AND rf.record_format_id = ff.record_format_id
77: AND rf.record_identifier = pi.record_type

Line 481: AND record_type in ( select a.record_identifier from ar_trans_record_formats a, ar_transmissions_all b

477: amount_applied8,
478: batch_name
479: FROM ar_payments_interface_all
480: WHERE transmission_request_id = req_id
481: AND record_type in ( select a.record_identifier from ar_trans_record_formats a, ar_transmissions_all b
482: where b.transmission_request_id = req_id
483: and b.requested_trans_format_id = a.transmission_format_id
484: and a.record_type_lookup_code in ('PAYMENT','OVRFLW PAYMENT') );
485: BEGIN

Line 721: ar_trans_record_formats b

717: b.transmission_format_id,
718: a.transmission_id
719: INTO l_overflow_rec, l_trans_format_id, l_transmission_id
720: FROM ar_transmissions_all a,
721: ar_trans_record_formats b
722: WHERE a.requested_trans_format_id = b.transmission_format_id
723: AND a.transmission_request_id = in_trans_req_id
724: AND b.record_type_lookup_code = 'OVRFLW PAYMENT';
725:

Line 1078: ar_trans_record_formats c,

1074: decode(format_amount1,'Y',d.precision,0)
1075: INTO l_org_id, l_lockbox_number, l_batch_name, l_currency_code, l_precision
1076: FROM ar_payments_interface_all a,
1077: ar_transmissions_all b,
1078: ar_trans_record_formats c,
1079: fnd_currencies d
1080: WHERE a.transmission_request_id = b.transmission_request_id
1081: AND b.requested_trans_format_id = c.transmission_format_id
1082: AND c.record_identifier = a.record_type

Line 1234: from ar_trans_record_formats a, ar_transmissions_all b

1230: select count(*) from ar_payments_interface_all
1231: where transmission_request_id = in_trans_req_id )
1232: where transmission_request_id = in_trans_req_id
1233: and record_type in ( select a.record_identifier
1234: from ar_trans_record_formats a, ar_transmissions_all b
1235: where b.transmission_request_id = in_trans_req_id
1236: and b.requested_trans_format_id = a.transmission_format_id
1237: and a.record_type_lookup_code in ('TRANS HDR','TRANS TRL') );
1238: