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.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_BR_AR_BANK_OCCURRENCES

Line 110: jl_br_ar_bank_occurrences bo

106: SELECT occurrence_id
107: into l_occurrence_id
108: from
109: jl_br_ar_occurrence_docs_all oc,
110: jl_br_ar_bank_occurrences bo
111: WHERE
112: document_id = p_document_id
113: and bo.bank_occurrence_code = oc.bank_occurrence_code
114: and bo.bank_occurrence_type = oc.bank_occurrence_type

Line 146: jl_br_ar_bank_occurrences bo,

142: INTO
143: l_event_source_info.transaction_number
144: FROM jl_br_ar_collection_docs cd,
145: ra_customer_trx_all ract,
146: jl_br_ar_bank_occurrences bo,
147: jl_br_ar_occurrence_docs_all oc
148: WHERE ract.customer_trx_id = cd.customer_trx_id
149: AND ract.org_id = cd.org_id
150: AND cd.document_id = p_document_id

Line 194: jl_br_ar_bank_occurrences bo,

190: INTO
191: l_event_source_info.transaction_number
192: FROM jl_br_ar_collection_docs cd,
193: ra_customer_trx_all ract,
194: jl_br_ar_bank_occurrences bo,
195: jl_br_ar_occurrence_docs_all oc
196: WHERE ract.customer_trx_id = cd.customer_trx_id
197: AND ract.org_id = cd.org_id
198: AND cd.document_id = p_document_id

Line 860: jl_br_ar_bank_occurrences bo

856: -- Introduced for bug 10339838
857: SELECT occurrence_id
858: into x_occurrence_id
859: from jl_br_ar_occurrence_docs oc,
860: jl_br_ar_bank_occurrences bo
861: WHERE document_id = p_document_id
862: and bo.bank_occurrence_code = oc.bank_occurrence_code
863: and bo.bank_occurrence_type = oc.bank_occurrence_type
864: and bo.bank_party_id = oc.bank_party_id

Line 1186: jl_br_ar_bank_occurrences bo,

1182: cd.payment_schedule_id
1183: from jl_br_ar_collection_docs_all cd,
1184: jl_br_ar_occurrence_docs_all oc,
1185: ra_customer_trx_all ract,
1186: jl_br_ar_bank_occurrences bo,
1187: jl_br_ar_select_accounts_all csc,
1188: jl_br_ar_borderos_all b
1189: where oc.document_id between l_start_id and l_end_id
1190: and nvl(oc.occurrence_status,'CONFIRMED') <> 'CREATED'

Line 1841: jl_br_ar_bank_occurrences bo,

1837: FROM
1838: jl_br_ar_occurrence_docs_all oc,
1839: jl_br_ar_collection_docs_all cd,
1840: ra_customer_trx_all ract,
1841: jl_br_ar_bank_occurrences bo,
1842: jl_br_ar_select_accounts_all csc,
1843: jl_br_ar_borderos_all b,
1844: ar_system_parameters_all sys,
1845: gl_date_period_map per1,