APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 2167: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Creating journal entries by inserting into xla_ae_lines, xla_distribution_links');

2163: -------------------------------------------------------------------
2164: -- Create the Journal Entry Lines
2165: -------------------------------------------------------------------
2166: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2167: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Creating journal entries by inserting into xla_ae_lines, xla_distribution_links');
2168: END IF;
2169:
2170: INSERT ALL
2171: WHEN 1 = 1 THEN

Line 2251: INTO xla_distribution_links

2247: UNROUNDED_ENTERED_CR,
2248: UNROUNDED_ENTERED_DR
2249: )
2250: WHEN 1 = 1 THEN
2251: INTO xla_distribution_links
2252: (
2253: APPLICATION_ID,
2254: EVENT_ID,
2255: AE_HEADER_ID,

Line 3105: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(HDR,XLA_AE_HEADERS_U1) */

3101: category_name AS category_name,
3102: gl_transfer_date AS gl_transfer_date
3103: FROM
3104: (select /*+ ordered use_nl(mcod,cd,ct,lgr,map,gps,dist,ps,dl,hdr)
3105: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(HDR,XLA_AE_HEADERS_U1) */
3106: hdr.ae_header_id ae_header_id,
3107: hdr.entity_id entity_id,
3108: hdr.event_id event_id,
3109: hdr.event_type_code event_type_code,

Line 3126: xla_distribution_links dl,

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: --
3129: where od.rowid >= l_start_rowid
3130: and od.rowid <= l_end_rowid

Line 3323: INTO XLA_DISTRIBUTION_LINKS

3319: null,
3320: null
3321: )
3322: WHEN 1 = 1 THEN
3323: INTO XLA_DISTRIBUTION_LINKS
3324: (
3325: APPLICATION_ID,
3326: EVENT_ID,
3327: AE_HEADER_ID,

Line 3439: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) index(HDR1,XLA_AE_HEADERS_N2) */

3435: RANK() OVER (PARTITION BY event_id, ref_header_id,sob_id
3436: ORDER BY distribution_id, amount_dr) AS line_num
3437: FROM
3438: (select /*+ ordered use_nl(mcod,cd,ct,lgr,map,gps,dist,ps,dl,lin,hdr,hdr1,lgr1)
3439: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) index(HDR1,XLA_AE_HEADERS_N2) */
3440: hdr1.ae_header_id header_id,
3441: ref.ae_header_id ref_header_id,
3442: ref.event_id ref_event_id,
3443: dist.distribution_id distribution_id,

Line 3479: xla_distribution_links dl,

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,
3482: xla_ae_headers hdr1,
3483: xla_ae_headers ref,

Line 3544: and NOT EXISTS(select 'Y' from xla_distribution_links dl2, xla_ae_headers hdr2

3540: and ref.event_type_code = ref1.event_type_code
3541: --
3542: and ref1.ae_header_id = dl.ref_ae_header_id
3543: --
3544: and NOT EXISTS(select 'Y' from xla_distribution_links dl2, xla_ae_headers hdr2
3545: where dl2.application_id = 222
3546: and dl2.source_distribution_id_num_1 = dist.distribution_id
3547: and dl2.source_distribution_type = 'JLBR_AR_DIST'
3548: and hdr2.ae_header_id = dl2.ae_header_id