APPS.AR_XLA_REPORTS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

            p_custom_line_query := 'select /*+ index(xdl, XLA_DISTRIBUTION_LINKS_N3) */
            sum(xdl.unrounded_entered_dr) L1, sum(xdl.unrounded_entered_cr) L2,
            sum(xdl.unrounded_accounted_dr) L3, sum(xdl.unrounded_accounted_cr) L4,
            xdl.application_id L5, xdl.ae_header_id L6, xdl.ae_line_num L7
            from xla_distribution_links xdl
            where xdl.event_class_code = ''CREDIT_MEMO''
	    and xdl.source_distribution_type = ''RA_CUST_TRX_LINE_GL_DIST_ALL''
            and xdl.application_id = to_number(:APPLICATION_ID)
            and xdl.ae_header_id = to_number(:HEADER_ID)
            and xdl.ae_line_num = to_number(:ORIG_LINE_NUMBER)
            group by xdl.application_id, xdl.ae_header_id, xdl.ae_line_num ';