DBA Data[Home] [Help]

APPS.XLA_JE_VALIDATION_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 7468: WHERE EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1

7464: ,je_category_name
7465: ,gl_date
7466: ,status
7467: FROM fun_bal_headers_gt fgt
7468: WHERE EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7469: FROM xla_distribution_links xdl
7470: WHERE fgt.group_id = xdl.ae_header_id
7471: AND xdl.temp_line_num <0
7472: AND xdl.application_id = g_application_id);

Line 7469: FROM xla_distribution_links xdl

7465: ,gl_date
7466: ,status
7467: FROM fun_bal_headers_gt fgt
7468: WHERE EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7469: FROM xla_distribution_links xdl
7470: WHERE fgt.group_id = xdl.ae_header_id
7471: AND xdl.temp_line_num <0
7472: AND xdl.application_id = g_application_id);
7473:

Line 7484: AND NOT EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1

7480:
7481:
7482: DELETE FROM fun_bal_headers_gt fgt
7483: WHERE fgt.group_id > 0
7484: AND NOT EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7485: FROM xla_distribution_links xdl
7486: WHERE fgt.group_id = xdl.ae_header_id
7487: AND (xdl.temp_line_num IS NULL OR xdl.temp_line_num >0)
7488: AND xdl.application_id = g_application_id);

Line 7485: FROM xla_distribution_links xdl

7481:
7482: DELETE FROM fun_bal_headers_gt fgt
7483: WHERE fgt.group_id > 0
7484: AND NOT EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7485: FROM xla_distribution_links xdl
7486: WHERE fgt.group_id = xdl.ae_header_id
7487: AND (xdl.temp_line_num IS NULL OR xdl.temp_line_num >0)
7488: AND xdl.application_id = g_application_id);
7489:

Line 7528: AND EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1

7524: WHERE l.balancing_line_type = C_LINE_TYPE_PROCESS
7525: AND l.ae_header_id = h.group_id
7526: AND l.entered_currency_code <> 'STAT' -- added for bug#10166812
7527: AND h.group_id > 0
7528: AND EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7529: FROM xla_distribution_links xdl
7530: WHERE xdl.ae_header_id= l.ae_header_id
7531: AND xdl.ae_line_num= l.ae_line_num
7532: AND (xdl.temp_line_num IS NULL OR xdl.temp_line_num >0)

Line 7529: FROM xla_distribution_links xdl

7525: AND l.ae_header_id = h.group_id
7526: AND l.entered_currency_code <> 'STAT' -- added for bug#10166812
7527: AND h.group_id > 0
7528: AND EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7529: FROM xla_distribution_links xdl
7530: WHERE xdl.ae_header_id= l.ae_header_id
7531: AND xdl.ae_line_num= l.ae_line_num
7532: AND (xdl.temp_line_num IS NULL OR xdl.temp_line_num >0)
7533: AND xdl.application_id = g_application_id);

Line 7572: AND EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1

7568: WHERE l.balancing_line_type = C_LINE_TYPE_PROCESS
7569: AND l.ae_header_id = h.group_id * -1
7570: AND l.entered_currency_code <> 'STAT' -- added for bug#10166812
7571: AND h.group_id < 0
7572: AND EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7573: FROM xla_distribution_links xdl
7574: WHERE xdl.ae_header_id= l.ae_header_id
7575: AND xdl.ae_line_num= l.ae_line_num
7576: AND xdl.temp_line_num <0

Line 7573: FROM xla_distribution_links xdl

7569: AND l.ae_header_id = h.group_id * -1
7570: AND l.entered_currency_code <> 'STAT' -- added for bug#10166812
7571: AND h.group_id < 0
7572: AND EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7573: FROM xla_distribution_links xdl
7574: WHERE xdl.ae_header_id= l.ae_header_id
7575: AND xdl.ae_line_num= l.ae_line_num
7576: AND xdl.temp_line_num <0
7577: AND xdl.application_id = g_application_id);