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_DISTRIBUTNS_ALL

Line 1013: jl_br_ar_distributns_all dist

1009: order by occurrence_id) lagdist,
1010: lag(distribution_id,1,to_number(NULL)) over (partition by document_id, occurrence_id, distribution_type
1011: order by accounting_reversal_option) cancellagdist
1012: from jl_rev_tmp) tmp,
1013: jl_br_ar_distributns_all dist
1014: where tmp.distribution_id = dist.distribution_id
1015: and (tmp.ACCOUNTING_REVERSAL_OPTION = 'Y'
1016: or dist.std_occurrence_code in ('FULL_SETTLEMENT', 'PARTIAL_SETTLEMENT')
1017: and dist.distribution_type = 'JLBR_AR_ENDORSEMENT');

Line 1034: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_DISTRIBUTIONS','Insert into jl_br_ar_distributns_all ');

1030:
1031: BEGIN
1032: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1033: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_DISTRIBUTIONS','Start procedure UPGRADE_DISTRIBUTIONS');
1034: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_DISTRIBUTIONS','Insert into jl_br_ar_distributns_all ');
1035: END IF;
1036:
1037: INSERT all
1038: WHEN 1=1 THEN

Line 1039: INTO jl_br_ar_distributns_all

1035: END IF;
1036:
1037: INSERT all
1038: WHEN 1=1 THEN
1039: INTO jl_br_ar_distributns_all
1040: (
1041: ORG_ID ,
1042: DISTRIBUTION_ID,
1043: DOCUMENT_ID ,

Line 1197: from jl_br_ar_distributns_all rerun

1193: where grm.multiplier < 7
1194: and ps.payment_schedule_id = x.payment_schedule_id
1195: and not exists (
1196: select /*+ use_nl_with_index(rerun, JL_BR_AR_DISTRIBUTNS_U2) */ null
1197: from jl_br_ar_distributns_all rerun
1198: where rerun.occurrence_id = x.occurrence_id
1199: and rerun.distribution_type = decode (grm.multiplier, 1,
1200: 'JLBR_AR_ENDORSEMENT', 2, 'JLBR_AR_ENDORSEMENT', 3,
1201: 'JLBR_AR_BANK_CHARGES', 4, 'JLBR_AR_BANK_CHARGES', 5,

Line 1239: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_DISTRIBUTIONS',' After Insert into jl_br_ar_distributns_all. Opening cursor c_dist ');

1235: or std_occurrence_code = 'REJECTED_ENTRY'))
1236: ;
1237:
1238: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1239: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPGRADE_DISTRIBUTIONS',' After Insert into jl_br_ar_distributns_all. Opening cursor c_dist ');
1240: END IF;
1241: open c_dist;
1242: LOOP
1243: FETCH c_dist BULK COLLECT INTO

Line 1272: update /+ index(d, jl_br_ar_distributns_u1) / jl_br_ar_distributns_all d

1268: END LOOP;
1269:
1270: FORALL i in 1..nvl(pr_dist.dist_id.LAST,-99)
1271:
1272: update /*+ index(d, jl_br_ar_distributns_u1) */ jl_br_ar_distributns_all d
1273: set reversed_dist_id = pr_dist.rev_dist_id(i),
1274: prior_dist_id = pr_dist.prior_dist_id(i)
1275: where distribution_id = pr_dist.dist_id(i);
1276:

Line 1312: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_DISTRIBUTIONS','Updating table jl_br_ar_distributns_all');

1308: /* Updating the prior and reversed distribution Ids */
1309: ------------------------------------------------------------------
1310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1311: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_DISTRIBUTIONS','Start procedure UPDATE_DISTRIBUTIONS');
1312: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_DISTRIBUTIONS','Updating table jl_br_ar_distributns_all');
1313: END IF;
1314: UPDATE jl_br_ar_distributns_all d
1315: SET (prior_dist_id, reversed_dist_id) =
1316: ( SELECT decode(d.accounting_reversal_option, 'Y', NULL, d1.distribution_id),

Line 1314: UPDATE jl_br_ar_distributns_all d

1310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1311: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_DISTRIBUTIONS','Start procedure UPDATE_DISTRIBUTIONS');
1312: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_DISTRIBUTIONS','Updating table jl_br_ar_distributns_all');
1313: END IF;
1314: UPDATE jl_br_ar_distributns_all d
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,

Line 1318: FROM jl_br_ar_distributns_all d1,

1314: UPDATE jl_br_ar_distributns_all d
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

Line 2404: jl_br_ar_distributns_all dist,

2400: grm.multiplier MULTIPLIER
2401: FROM
2402: jl_remit1_gt TR2,
2403: jl_remit1_gt refTR2,
2404: jl_br_ar_distributns_all dist,
2405: gl_row_multipliers grm
2406: WHERE
2407: dist.occurrence_id = TR2.occurrence_id
2408: And dist.document_id = TR2.document_id

Line 2415: AND EXISTS(SELECT 'Y' FROM jl_br_ar_distributns_all dist2

2411: And (refTR2.event_type_code IN('REMIT_COLL_DOC' ,'REMIT_FACT_DOC')
2412: AND refTR2.occurrence_status = 'CONFIRMED'
2413: AND TR2.std_occurrence_code IN ('WRITE_OFF_REQUISITION','REJECTED_ENTRY',
2414: 'FULL_SETTLEMENT','PARTIAL_SETTLEMENT','AUTOMATIC_WRITE_OFF')
2415: AND EXISTS(SELECT 'Y' FROM jl_br_ar_distributns_all dist2
2416: WHERE dist2.occurrence_id = refTR2.occurrence_id
2417: AND (dist2.distribution_id = dist.prior_dist_id and dist.prior_dist_id is not null
2418: or dist2.distribution_id = dist.reversed_dist_id and dist.reversed_dist_id is not null))
2419: OR refTR2.occurrence_id = TR2.occurrence_id

Line 2580: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_OCCURRENCES','Update table jl_br_ar_distributns_all');

2576:
2577: */
2578:
2579: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2580: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_OCCURRENCES','Update table jl_br_ar_distributns_all');
2581: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_OCCURRENCES','Update event_id for unposted occurrences and distributions');
2582: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_OCCURRENCES','This will be used by Extract objects when Create Accounting program of SLA is run for the non posted data');
2583: END IF;
2584: UPDATE /*+ rowid(jlbr) */ jl_br_ar_distributns_all jlbr

Line 2584: UPDATE /+ rowid(jlbr) / jl_br_ar_distributns_all jlbr

2580: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_OCCURRENCES','Update table jl_br_ar_distributns_all');
2581: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_OCCURRENCES','Update event_id for unposted occurrences and distributions');
2582: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.UPDATE_OCCURRENCES','This will be used by Extract objects when Create Accounting program of SLA is run for the non posted data');
2583: END IF;
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

Line 3124: jl_br_ar_distributns_all dist,

3120: ra_customer_trx_all ct,
3121: gl_ledgers lgr,
3122: gl_date_period_map map,
3123: gl_period_statuses gps,
3124: jl_br_ar_distributns_all dist,
3125: ar_mc_payment_schedules ps,
3126: xla_distribution_links dl,
3127: xla_ae_headers hdr
3128: --

Line 3477: jl_br_ar_distributns_all dist,

3473: ra_customer_trx_all ct,
3474: gl_ledgers lgr,
3475: gl_date_period_map map,
3476: gl_period_statuses gps,
3477: jl_br_ar_distributns_all dist,
3478: ar_mc_payment_schedules ps,
3479: xla_distribution_links dl,
3480: xla_ae_lines lin,
3481: xla_ae_headers hdr,