APPS.ARP_LOCKBOX_HOOK_PVT dependencies on AR_TRANS_RECORD_FORMATS

Line 70: ar_trans_record_formats rf

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

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

462: amount_applied8,
463: batch_name
464: FROM ar_payments_interface_all
465: WHERE transmission_request_id = req_id
466: AND record_type in ( select a.record_identifier from ar_trans_record_formats a, ar_transmissions_all b
467: where b.transmission_request_id = req_id
468: and b.requested_trans_format_id = a.transmission_format_id
469: and a.record_type_lookup_code in ('PAYMENT','OVRFLW PAYMENT') );
470: BEGIN

Line 706: ar_trans_record_formats b

702: b.transmission_format_id,
703: a.transmission_id
704: INTO l_overflow_rec, l_trans_format_id, l_transmission_id
705: FROM ar_transmissions_all a,
706: ar_trans_record_formats b
707: WHERE a.requested_trans_format_id = b.transmission_format_id
708: AND a.transmission_request_id = in_trans_req_id
709: AND b.record_type_lookup_code = 'OVRFLW PAYMENT';
710:

Line 1033: ar_trans_record_formats c,

1029: decode(format_amount1,'Y',d.precision,0)
1030: INTO l_org_id, l_lockbox_number, l_batch_name, l_currency_code, l_precision
1031: FROM ar_payments_interface_all a,
1032: ar_transmissions_all b,
1033: ar_trans_record_formats c,
1034: fnd_currencies d
1035: WHERE a.transmission_request_id = b.transmission_request_id
1036: AND b.requested_trans_format_id = c.transmission_format_id
1037: AND c.record_identifier = a.record_type

Line 1187: from ar_trans_record_formats a, ar_transmissions_all b

1183: select count(*) from ar_payments_interface_all
1184: where transmission_request_id = in_trans_req_id )
1185: where transmission_request_id = in_trans_req_id
1186: and record_type in ( select a.record_identifier
1187: from ar_trans_record_formats a, ar_transmissions_all b
1188: where b.transmission_request_id = in_trans_req_id
1189: and b.requested_trans_format_id = a.transmission_format_id
1190: and a.record_type_lookup_code in ('TRANS HDR','TRANS TRL') );
1191: