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_OCCURRENCE_DOCS_ALL

Line 109: jl_br_ar_occurrence_docs_all oc,

105: BEGIN
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

Line 147: jl_br_ar_occurrence_docs_all oc

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
151: AND oc.document_id = cd.document_id

Line 195: jl_br_ar_occurrence_docs_all oc

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
199: AND oc.document_id = cd.document_id

Line 1184: jl_br_ar_occurrence_docs_all oc,

1180: cd.document_id, oc.bank_party_id, oc.bordero_id, ract.customer_trx_id,
1181: csc.select_account_id, oc.flag_post_gl, oc.gl_date, cd.org_id,
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

Line 1225: and exists(select 'Y' from jl_br_ar_occurrence_docs_all o2 where o2.document_id = oc.document_id

1221: or (o.gl_date >= xud.start_date
1222: and o.gl_date < xud.end_date))))))
1223: or ((nvl(oc.occurrence_status,'CONFIRMED') <> 'CANCELED'
1224: and bo.std_occurrence_code = 'REMITTANCE'
1225: and exists(select 'Y' from jl_br_ar_occurrence_docs_all o2 where o2.document_id = oc.document_id
1226: and nvl(o2.flag_post_gl,'N') = 'N'))))
1227: ))) X,
1228: gl_row_multipliers grm,
1229: ar_payment_schedules_all ps

Line 1356: jl_br_ar_occurrence_docs_all occ1

1352: SET (prior_dist_id, reversed_dist_id) =
1353: ( SELECT decode(d.accounting_reversal_option, 'Y', NULL, d1.distribution_id),
1354: decode(d.accounting_reversal_option, 'Y', d1.distribution_id, NULL)
1355: FROM jl_br_ar_distributns_all d1,
1356: jl_br_ar_occurrence_docs_all occ1
1357: WHERE d1.distribution_type = d.distribution_type
1358: AND d1.std_occurrence_code = 'REMITTANCE'
1359: AND d1.document_id = d.document_id
1360: AND d1.occurrence_id = occ1.occurrence_id

Line 1369: SELECT 1 FROM jl_br_ar_occurrence_docs_all occ

1365: (d.std_occurrence_code in ('FULL_SETTLEMENT','PARTIAL_SETTLEMENT')
1366: AND d.distribution_type = 'JLBR_AR_ENDORSEMENT'
1367: AND d.prior_dist_id IS NULL))
1368: AND EXISTS(
1369: SELECT 1 FROM jl_br_ar_occurrence_docs_all occ
1370: WHERE occ.occurrence_id = d.occurrence_id
1371: AND rowid >= l_start_rowid
1372: AND rowid <= l_end_rowid
1373: );

Line 1838: jl_br_ar_occurrence_docs_all oc,

1834: ract.bill_to_site_use_id BILL_TO_SITE_USE_ID,
1835: ract.trx_number TRX_NUMBER ,
1836: oc.ROWID RID
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,

Line 1890: and exists(select 'Y' from jl_br_ar_occurrence_docs_all o2 where o2.document_id = oc.document_id

1886: or (o.gl_date >= xud.start_date
1887: and o.gl_date < xud.end_date))))))
1888: or ((nvl(oc.occurrence_status,'CONFIRMED') <> 'CANCELED'
1889: and bo.std_occurrence_code = 'REMITTANCE'
1890: and exists(select 'Y' from jl_br_ar_occurrence_docs_all o2 where o2.document_id = oc.document_id
1891: and nvl(o2.flag_post_gl,'N') = 'N'))))
1892: ))
1893: And not exists
1894: (SELECT 'Y' FROM

Line 2183: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Updating the event id and the cancel event id of table jl_br_ar_occurrence_docs_all');

2179: ------------------------------------------------------------------
2180: -- Updating the event id and the cancel event id
2181: ------------------------------------------------------------------
2182: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2183: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Updating the event id and the cancel event id of table jl_br_ar_occurrence_docs_all');
2184: END IF;
2185: OPEN c_events;
2186: FETCH c_events BULK COLLECT INTO
2187: JL_BR_AR_BANK_ACCT_PKG.trx_events.row_id,

Line 2196: UPDATE jl_br_ar_occurrence_docs_all occ

2192: CLOSE c_events;
2193:
2194: FORALL i in 1..nvl(JL_BR_AR_BANK_ACCT_PKG.trx_events.row_id.LAST,-99)
2195:
2196: UPDATE jl_br_ar_occurrence_docs_all occ
2197: set event_id = JL_BR_AR_BANK_ACCT_PKG.trx_events.event_id(i)
2198: ,cancel_event_id = JL_BR_AR_BANK_ACCT_PKG.trx_events.cancel_event_id(i)
2199: where rowid = JL_BR_AR_BANK_ACCT_PKG.trx_events.row_id(i) ;
2200: -------------------------------------------------------------------

Line 2588: /* UPDATE jl_br_ar_occurrence_docs_all oc

2584: -- Update event_id for unposted occurrences and distributions
2585: -- This will be used by Extract objects when Create Accounting
2586: -- program of SLA is run for the non posted data
2587: -------------------------------------------------------------------
2588: /* UPDATE jl_br_ar_occurrence_docs_all oc
2589: SET event_id = decode(oc.gl_posted_date, NULL, (SELECT a.event_id
2590: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2591: WHERE sys.org_id = oc.org_id
2592: AND a.entity_id = c.entity_id

Line 2625: jl_br_ar_occurrence_docs_all oc1

2621: UPDATE /*+ rowid(jlbr) */ jl_br_ar_distributns_all jlbr
2622: SET event_id = decode(jlbr.accounting_reversal_option, 'Y',
2623: (SELECT a1.event_id
2624: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1,
2625: jl_br_ar_occurrence_docs_all oc1
2626: WHERE jlbr.occurrence_id = oc1.occurrence_id
2627: AND sys1.org_id = oc1.org_id
2628: AND a1.entity_id = c1.entity_id
2629: AND ((a1.event_type_code IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')

Line 2650: AND EXISTS (SELECT 'Y' from jl_br_ar_occurrence_docs_all occ

2646: AND nvl(c.source_id_int_2,-99) = jlbr.occurrence_id))
2647: WHERE jlbr.event_id IS NULL
2648: AND jlbr.rowid >= l_start_rowid
2649: AND jlbr.rowid <= l_end_rowid
2650: AND EXISTS (SELECT 'Y' from jl_br_ar_occurrence_docs_all occ
2651: WHERE occ.occurrence_id = jlbr.occurrence_id
2652: AND (occ.flag_post_gl = 'N' OR occ.flag_post_gl IS NULL));
2653:
2654: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;

Line 3155: jl_br_ar_occurrence_docs_all od,

3151: hdr.gl_transfer_date gl_transfer_date,
3152: mcod.set_of_books_id sob_id
3153: --
3154: from
3155: jl_br_ar_occurrence_docs_all od,
3156: jl_br_ar_mc_occ_docs mcod,
3157: jl_br_ar_collection_docs_all cd,
3158: ra_customer_trx_all ct,
3159: gl_ledgers lgr,

Line 3508: jl_br_ar_occurrence_docs_all od,

3504: dl.event_class_code event_class_code,
3505: mcod.set_of_books_id sob_id
3506: --
3507: from
3508: jl_br_ar_occurrence_docs_all od,
3509: jl_br_ar_mc_occ_docs mcod,
3510: jl_br_ar_collection_docs_all cd,
3511: ra_customer_trx_all ct,
3512: gl_ledgers lgr,