eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LCKBX_CSH_APP_PVT dependencies on AR_TRANS_RECORD_FORMATS

Line 93: ar_trans_record_formats rec,

89: cp_column_type IN VARCHAR2
90: ) IS
91: SELECT NVL (fld.amount_format_lookup_code, 'N')
92: FROM ar_transmissions_all trans,
93: ar_trans_record_formats rec,
94: ar_trans_field_formats fld
95: WHERE trans.transmission_request_id = cp_trans_req_id
96: AND trans.requested_trans_format_id = rec.transmission_format_id
97: AND rec.record_type_lookup_code = cp_record_type

Line 359: l_record_identifier ar_trans_record_formats.record_identifier%TYPE

355: l_batch_name ar_payments_interface_all.batch_name%TYPE
356: DEFAULT NULL;
357: l_transmission_format_id ar_transmission_formats.transmission_format_id%TYPE
358: DEFAULT NULL;
359: l_record_identifier ar_trans_record_formats.record_identifier%TYPE
360: DEFAULT NULL;
361: l_record_type_lookup_code ar_trans_record_formats.record_type_lookup_code%TYPE
362: DEFAULT NULL;
363: l_overflow_rec_indicator ar_trans_field_formats.overflow_rec_indicator%TYPE

Line 361: l_record_type_lookup_code ar_trans_record_formats.record_type_lookup_code%TYPE

357: l_transmission_format_id ar_transmission_formats.transmission_format_id%TYPE
358: DEFAULT NULL;
359: l_record_identifier ar_trans_record_formats.record_identifier%TYPE
360: DEFAULT NULL;
361: l_record_type_lookup_code ar_trans_record_formats.record_type_lookup_code%TYPE
362: DEFAULT NULL;
363: l_overflow_rec_indicator ar_trans_field_formats.overflow_rec_indicator%TYPE
364: DEFAULT NULL;
365: l_transmission_hdr ar_trans_record_formats.record_identifier%TYPE

Line 365: l_transmission_hdr ar_trans_record_formats.record_identifier%TYPE

361: l_record_type_lookup_code ar_trans_record_formats.record_type_lookup_code%TYPE
362: DEFAULT NULL;
363: l_overflow_rec_indicator ar_trans_field_formats.overflow_rec_indicator%TYPE
364: DEFAULT NULL;
365: l_transmission_hdr ar_trans_record_formats.record_identifier%TYPE
366: DEFAULT NULL;
367: l_transmission_trl ar_trans_record_formats.record_identifier%TYPE
368: DEFAULT NULL;
369: l_payment ar_trans_record_formats.record_identifier%TYPE

Line 367: l_transmission_trl ar_trans_record_formats.record_identifier%TYPE

363: l_overflow_rec_indicator ar_trans_field_formats.overflow_rec_indicator%TYPE
364: DEFAULT NULL;
365: l_transmission_hdr ar_trans_record_formats.record_identifier%TYPE
366: DEFAULT NULL;
367: l_transmission_trl ar_trans_record_formats.record_identifier%TYPE
368: DEFAULT NULL;
369: l_payment ar_trans_record_formats.record_identifier%TYPE
370: DEFAULT NULL;
371: l_overflow ar_trans_record_formats.record_identifier%TYPE

Line 369: l_payment ar_trans_record_formats.record_identifier%TYPE

365: l_transmission_hdr ar_trans_record_formats.record_identifier%TYPE
366: DEFAULT NULL;
367: l_transmission_trl ar_trans_record_formats.record_identifier%TYPE
368: DEFAULT NULL;
369: l_payment ar_trans_record_formats.record_identifier%TYPE
370: DEFAULT NULL;
371: l_overflow ar_trans_record_formats.record_identifier%TYPE
372: DEFAULT NULL;
373: l_service ar_trans_record_formats.record_identifier%TYPE

Line 371: l_overflow ar_trans_record_formats.record_identifier%TYPE

367: l_transmission_trl ar_trans_record_formats.record_identifier%TYPE
368: DEFAULT NULL;
369: l_payment ar_trans_record_formats.record_identifier%TYPE
370: DEFAULT NULL;
371: l_overflow ar_trans_record_formats.record_identifier%TYPE
372: DEFAULT NULL;
373: l_service ar_trans_record_formats.record_identifier%TYPE
374: DEFAULT NULL;
375: l_customer_number ar_payments_interface_all.customer_number%TYPE

Line 373: l_service ar_trans_record_formats.record_identifier%TYPE

369: l_payment ar_trans_record_formats.record_identifier%TYPE
370: DEFAULT NULL;
371: l_overflow ar_trans_record_formats.record_identifier%TYPE
372: DEFAULT NULL;
373: l_service ar_trans_record_formats.record_identifier%TYPE
374: DEFAULT NULL;
375: l_customer_number ar_payments_interface_all.customer_number%TYPE
376: DEFAULT NULL;
377: l_remittance_amount ar_payments_interface_all.remittance_amount%TYPE

Line 654: FROM ar_transmissions_all a, ar_trans_record_formats b

650: CURSOR c_get_trans_fmt (cp_trans_req_id IN NUMBER) IS
651: SELECT b.record_identifier,
652: b.record_type_lookup_code,
653: b.transmission_format_id
654: FROM ar_transmissions_all a, ar_trans_record_formats b
655: WHERE a.requested_trans_format_id = b.transmission_format_id
656: AND a.transmission_request_id = cp_trans_req_id
657: ORDER BY b.record_identifier;
658: