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 107: jl_br_ar_occurrence_docs_all oc,

103: BEGIN
104: SELECT occurrence_id
105: into l_occurrence_id
106: from
107: jl_br_ar_occurrence_docs_all oc,
108: jl_br_ar_bank_occurrences bo
109: WHERE
110: document_id = p_document_id
111: and bo.bank_occurrence_code = oc.bank_occurrence_code

Line 137: jl_br_ar_occurrence_docs_all oc

133: l_event_source_info.transaction_number
134: FROM jl_br_ar_collection_docs cd,
135: ra_customer_trx_all ract,
136: jl_br_ar_bank_occurrences bo,
137: jl_br_ar_occurrence_docs_all oc
138: WHERE ract.customer_trx_id = cd.customer_trx_id
139: AND ract.org_id = cd.org_id
140: AND cd.document_id = p_document_id
141: AND oc.document_id = cd.document_id

Line 184: jl_br_ar_occurrence_docs_all oc

180: l_event_source_info.transaction_number
181: FROM jl_br_ar_collection_docs cd,
182: ra_customer_trx_all ract,
183: jl_br_ar_bank_occurrences bo,
184: jl_br_ar_occurrence_docs_all oc
185: WHERE ract.customer_trx_id = cd.customer_trx_id
186: AND ract.org_id = cd.org_id
187: AND cd.document_id = p_document_id
188: AND oc.document_id = cd.document_id

Line 1147: jl_br_ar_occurrence_docs_all oc,

1143: cd.document_id, oc.bank_party_id, oc.bordero_id, ract.customer_trx_id,
1144: csc.select_account_id, oc.flag_post_gl, oc.gl_date, cd.org_id,
1145: cd.payment_schedule_id
1146: from jl_br_ar_collection_docs_all cd,
1147: jl_br_ar_occurrence_docs_all oc,
1148: ra_customer_trx_all ract,
1149: jl_br_ar_bank_occurrences bo,
1150: jl_br_ar_select_accounts_all csc,
1151: jl_br_ar_borderos_all b

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

1184: or (o.gl_date >= xud.start_date
1185: and o.gl_date < xud.end_date))))))
1186: or ((nvl(oc.occurrence_status,'CONFIRMED') <> 'CANCELED'
1187: and bo.std_occurrence_code = 'REMITTANCE'
1188: and exists(select 'Y' from jl_br_ar_occurrence_docs_all o2 where o2.document_id = oc.document_id
1189: and nvl(o2.flag_post_gl,'N') = 'N'))))
1190: ))) X,
1191: gl_row_multipliers grm,
1192: ar_payment_schedules_all ps

Line 1319: jl_br_ar_occurrence_docs_all occ1

1315: SET (prior_dist_id, reversed_dist_id) =
1316: ( SELECT decode(d.accounting_reversal_option, 'Y', NULL, d1.distribution_id),
1317: decode(d.accounting_reversal_option, 'Y', d1.distribution_id, NULL)
1318: FROM jl_br_ar_distributns_all d1,
1319: jl_br_ar_occurrence_docs_all occ1
1320: WHERE d1.distribution_type = d.distribution_type
1321: AND d1.std_occurrence_code = 'REMITTANCE'
1322: AND d1.document_id = d.document_id
1323: AND d1.occurrence_id = occ1.occurrence_id

Line 1332: SELECT 1 FROM jl_br_ar_occurrence_docs_all occ

1328: (d.std_occurrence_code in ('FULL_SETTLEMENT','PARTIAL_SETTLEMENT')
1329: AND d.distribution_type = 'JLBR_AR_ENDORSEMENT'
1330: AND d.prior_dist_id IS NULL))
1331: AND EXISTS(
1332: SELECT 1 FROM jl_br_ar_occurrence_docs_all occ
1333: WHERE occ.occurrence_id = d.occurrence_id
1334: AND rowid >= l_start_rowid
1335: AND rowid <= l_end_rowid
1336: );

Line 1801: jl_br_ar_occurrence_docs_all oc,

1797: ract.bill_to_site_use_id BILL_TO_SITE_USE_ID,
1798: ract.trx_number TRX_NUMBER ,
1799: oc.ROWID RID
1800: FROM
1801: jl_br_ar_occurrence_docs_all oc,
1802: jl_br_ar_collection_docs_all cd,
1803: ra_customer_trx_all ract,
1804: jl_br_ar_bank_occurrences bo,
1805: jl_br_ar_select_accounts_all csc,

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

1849: or (o.gl_date >= xud.start_date
1850: and o.gl_date < xud.end_date))))))
1851: or ((nvl(oc.occurrence_status,'CONFIRMED') <> 'CANCELED'
1852: and bo.std_occurrence_code = 'REMITTANCE'
1853: and exists(select 'Y' from jl_br_ar_occurrence_docs_all o2 where o2.document_id = oc.document_id
1854: and nvl(o2.flag_post_gl,'N') = 'N'))))
1855: ))
1856: And not exists
1857: (SELECT 'Y' FROM

Line 2146: 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');

2142: ------------------------------------------------------------------
2143: -- Updating the event id and the cancel event id
2144: ------------------------------------------------------------------
2145: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2146: 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');
2147: END IF;
2148: OPEN c_events;
2149: FETCH c_events BULK COLLECT INTO
2150: JL_BR_AR_BANK_ACCT_PKG.trx_events.row_id,

Line 2159: UPDATE jl_br_ar_occurrence_docs_all occ

2155: CLOSE c_events;
2156:
2157: FORALL i in 1..nvl(JL_BR_AR_BANK_ACCT_PKG.trx_events.row_id.LAST,-99)
2158:
2159: UPDATE jl_br_ar_occurrence_docs_all occ
2160: set event_id = JL_BR_AR_BANK_ACCT_PKG.trx_events.event_id(i)
2161: ,cancel_event_id = JL_BR_AR_BANK_ACCT_PKG.trx_events.cancel_event_id(i)
2162: where rowid = JL_BR_AR_BANK_ACCT_PKG.trx_events.row_id(i) ;
2163: -------------------------------------------------------------------

Line 2551: /* UPDATE jl_br_ar_occurrence_docs_all oc

2547: -- Update event_id for unposted occurrences and distributions
2548: -- This will be used by Extract objects when Create Accounting
2549: -- program of SLA is run for the non posted data
2550: -------------------------------------------------------------------
2551: /* UPDATE jl_br_ar_occurrence_docs_all oc
2552: SET event_id = decode(oc.gl_posted_date, NULL, (SELECT a.event_id
2553: FROM xla_events a, xla_transaction_entities_upg c, ar_system_parameters_all sys
2554: WHERE sys.org_id = oc.org_id
2555: AND a.entity_id = c.entity_id

Line 2588: jl_br_ar_occurrence_docs_all oc1

2584: UPDATE /*+ rowid(jlbr) */ jl_br_ar_distributns_all jlbr
2585: SET event_id = decode(jlbr.accounting_reversal_option, 'Y',
2586: (SELECT a1.event_id
2587: FROM xla_events a1, xla_transaction_entities_upg c1, ar_system_parameters_all sys1,
2588: jl_br_ar_occurrence_docs_all oc1
2589: WHERE jlbr.occurrence_id = oc1.occurrence_id
2590: AND sys1.org_id = oc1.org_id
2591: AND a1.entity_id = c1.entity_id
2592: AND ((a1.event_type_code IN ('CANCEL_COLL_DOC', 'CANCEL_FACT_DOC')

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

2609: AND nvl(c.source_id_int_2,-99) = jlbr.occurrence_id))
2610: WHERE jlbr.event_id IS NULL
2611: AND jlbr.rowid >= l_start_rowid
2612: AND jlbr.rowid <= l_end_rowid
2613: AND EXISTS (SELECT 'Y' from jl_br_ar_occurrence_docs_all occ
2614: WHERE occ.occurrence_id = jlbr.occurrence_id
2615: AND (occ.flag_post_gl = 'N' OR occ.flag_post_gl IS NULL));
2616:
2617: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;

Line 3117: jl_br_ar_occurrence_docs_all od,

3113: hdr.gl_transfer_date gl_transfer_date,
3114: mcod.set_of_books_id sob_id
3115: --
3116: from
3117: jl_br_ar_occurrence_docs_all od,
3118: jl_br_ar_mc_occ_docs mcod,
3119: jl_br_ar_collection_docs_all cd,
3120: ra_customer_trx_all ct,
3121: gl_ledgers lgr,

Line 3470: jl_br_ar_occurrence_docs_all od,

3466: dl.event_class_code event_class_code,
3467: mcod.set_of_books_id sob_id
3468: --
3469: from
3470: jl_br_ar_occurrence_docs_all od,
3471: jl_br_ar_mc_occ_docs mcod,
3472: jl_br_ar_collection_docs_all cd,
3473: ra_customer_trx_all ct,
3474: gl_ledgers lgr,