APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_DISTRIBUTION_LINKS

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

2200: -------------------------------------------------------------------
2201: -- Create the Journal Entry Lines
2202: -------------------------------------------------------------------
2203: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2204: 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');
2205: END IF;
2206:
2207: INSERT ALL
2208: WHEN 1 = 1 THEN

Line 2288: INTO xla_distribution_links

2284: UNROUNDED_ENTERED_CR,
2285: UNROUNDED_ENTERED_DR
2286: )
2287: WHEN 1 = 1 THEN
2288: INTO xla_distribution_links
2289: (
2290: APPLICATION_ID,
2291: EVENT_ID,
2292: AE_HEADER_ID,

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

3139: category_name AS category_name,
3140: gl_transfer_date AS gl_transfer_date
3141: FROM
3142: (select /*+ ordered use_nl(mcod,cd,ct,lgr,map,gps,dist,ps,dl,hdr)
3143: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(HDR,XLA_AE_HEADERS_U1) */
3144: hdr.ae_header_id ae_header_id,
3145: hdr.entity_id entity_id,
3146: hdr.event_id event_id,
3147: hdr.event_type_code event_type_code,

Line 3164: xla_distribution_links dl,

3160: gl_date_period_map map,
3161: gl_period_statuses gps,
3162: jl_br_ar_distributns_all dist,
3163: ar_mc_payment_schedules ps,
3164: xla_distribution_links dl,
3165: xla_ae_headers hdr
3166: --
3167: where od.rowid >= l_start_rowid
3168: and od.rowid <= l_end_rowid

Line 3361: INTO XLA_DISTRIBUTION_LINKS

3357: null,
3358: null
3359: )
3360: WHEN 1 = 1 THEN
3361: INTO XLA_DISTRIBUTION_LINKS
3362: (
3363: APPLICATION_ID,
3364: EVENT_ID,
3365: AE_HEADER_ID,

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

3473: RANK() OVER (PARTITION BY event_id, ref_header_id,sob_id
3474: ORDER BY distribution_id, amount_dr) AS line_num
3475: FROM
3476: (select /*+ ordered use_nl(mcod,cd,ct,lgr,map,gps,dist,ps,dl,lin,hdr,hdr1,lgr1)
3477: index(DL,XLA_DISTRIBUTION_LINKS_N1) index(LIN,XLA_AE_LINES_U1) index(HDR,XLA_AE_HEADERS_U1) index(HDR1,XLA_AE_HEADERS_N2) */
3478: hdr1.ae_header_id header_id,
3479: ref.ae_header_id ref_header_id,
3480: ref.event_id ref_event_id,
3481: dist.distribution_id distribution_id,

Line 3517: xla_distribution_links dl,

3513: gl_date_period_map map,
3514: gl_period_statuses gps,
3515: jl_br_ar_distributns_all dist,
3516: ar_mc_payment_schedules ps,
3517: xla_distribution_links dl,
3518: xla_ae_lines lin,
3519: xla_ae_headers hdr,
3520: xla_ae_headers hdr1,
3521: xla_ae_headers ref,

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

3578: and ref.event_type_code = ref1.event_type_code
3579: --
3580: and ref1.ae_header_id = dl.ref_ae_header_id
3581: --
3582: and NOT EXISTS(select 'Y' from xla_distribution_links dl2, xla_ae_headers hdr2
3583: where dl2.application_id = 222
3584: and dl2.source_distribution_id_num_1 = dist.distribution_id
3585: and dl2.source_distribution_type = 'JLBR_AR_DIST'
3586: and hdr2.ae_header_id = dl2.ae_header_id