APPS.AR_INVOICE_VALIDATE_FLEX SQL Statements

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

Line: 13

      select ctx.descriptive_flex_context_code context_code,
             substr(seg.application_column_name,
                    length('INTERFACE_LINE_ATTRIBUTE')+1) segment_num
      from   fnd_descr_flex_contexts ctx,
             fnd_descr_flex_column_usages seg
      where  ctx.application_id = pc_appl_id
      and    ctx.descriptive_flexfield_name = pc_desc_flex
      and    ctx.application_id = seg.application_id(+)
      and    ctx.descriptive_flexfield_name =
                     seg.descriptive_flexfield_name(+)
      and    ctx.descriptive_flex_context_code =
                      seg.descriptive_flex_context_code(+)
      and    seg.enabled_flag (+) = 'Y'
      order by ctx.descriptive_flex_context_code, seg.column_seq_num;

Line: 245

   THEN   l_stmt := 'SELECT 0, 0 FROM '|| p_table_name;

Line: 246

   ELSE   l_stmt := 'SELECT CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID FROM '||
          p_table_name;

Line: 931

  SELECT 'Y'
  FROM fnd_descriptive_flexs
  WHERE application_id = 222
    and descriptive_flexfield_name = p_desc_flex_name;

Line: 1052

  SELECT 'Y'
  FROM fnd_descriptive_flexs
  WHERE application_id = 222
    and descriptive_flexfield_name = p_desc_flex_name;

Line: 1172

        SELECT attribute1, attribute2, attribute3,
               attribute4, attribute5, attribute6,
               attribute7, attribute8, attribute9,
               attribute10, attribute11, attribute12,
               attribute13, attribute14, attribute15,
               attribute_category,
               trx_header_id
        FROM   ar_trx_header_gt
        WHERE  attribute1 IS NOT NULL
        OR     attribute2 IS NOT NULL
        OR     attribute3 IS NOT NULL
        OR     attribute4 IS NOT NULL
        OR     attribute5 IS NOT NULL
        OR     attribute6 IS NOT NULL
        OR     attribute7 IS NOT NULL
        OR     attribute8 IS NOT NULL
        OR     attribute9 IS NOT NULL
        OR     attribute10 IS NOT NULL
        OR     attribute11 IS NOT NULL
        OR     attribute12 IS NOT NULL
        OR     attribute13 IS NOT NULL
        OR     attribute14 IS NOT NULL
        OR     attribute15 IS NOT NULL;

Line: 1197

        SELECT interface_header_attribute1,
               interface_header_attribute2,
               interface_header_attribute3,
               interface_header_attribute4,
               interface_header_attribute5,
               interface_header_attribute6,
               interface_header_attribute7,
               interface_header_attribute8,
               interface_header_attribute9,
               interface_header_attribute10,
               interface_header_attribute11,
               interface_header_attribute12,
               interface_header_attribute13,
               interface_header_attribute14,
               interface_header_attribute15,
               interface_header_context,
               trx_header_id
        FROM   ar_trx_header_gt
        WHERE  interface_header_attribute1 IS NOT NULL
        OR     interface_header_attribute2 IS NOT NULL
        OR     interface_header_attribute3 IS NOT NULL
        OR     interface_header_attribute4 IS NOT NULL
        OR     interface_header_attribute5 IS NOT NULL
        OR     interface_header_attribute6 IS NOT NULL
        OR     interface_header_attribute7 IS NOT NULL
        OR     interface_header_attribute8 IS NOT NULL
        OR     interface_header_attribute9 IS NOT NULL
        OR     interface_header_attribute10 IS NOT NULL
        OR     interface_header_attribute11 IS NOT NULL
        OR     interface_header_attribute12 IS NOT NULL
        OR     interface_header_attribute13 IS NOT NULL
        OR     interface_header_attribute14 IS NOT NULL
        OR     interface_header_attribute15 IS NOT NULL;

Line: 1232

        SELECT interface_line_attribute1,
               interface_line_attribute2,
               interface_line_attribute3,
               interface_line_attribute4,
               interface_line_attribute5,
               interface_line_attribute6,
               interface_line_attribute7,
               interface_line_attribute8,
               interface_line_attribute9,
               interface_line_attribute10,
               interface_line_attribute11,
               interface_line_attribute12,
               interface_line_attribute13,
               interface_line_attribute14,
               interface_line_attribute15,
               interface_line_context,
               trx_header_id,
               trx_line_id,
               customer_trx_line_id,
               customer_trx_id
        FROM   ar_trx_lines_gt
        WHERE  interface_line_attribute1 IS NOT NULL
        OR     interface_line_attribute2 IS NOT NULL
        OR     interface_line_attribute3 IS NOT NULL
        OR     interface_line_attribute4 IS NOT NULL
        OR     interface_line_attribute5 IS NOT NULL
        OR     interface_line_attribute6 IS NOT NULL
        OR     interface_line_attribute7 IS NOT NULL
        OR     interface_line_attribute8 IS NOT NULL
        OR     interface_line_attribute9 IS NOT NULL
        OR     interface_line_attribute10 IS NOT NULL
        OR     interface_line_attribute11 IS NOT NULL
        OR     interface_line_attribute12 IS NOT NULL
        OR     interface_line_attribute13 IS NOT NULL
        OR     interface_line_attribute14 IS NOT NULL
        OR     interface_line_attribute15 IS NOT NULL;

Line: 1270

        SELECT attribute1, attribute2, attribute3,
               attribute4, attribute5, attribute6,
               attribute7, attribute8, attribute9,
               attribute10, attribute11, attribute12,
               attribute13, attribute14, attribute15,
               attribute_category,
               trx_header_id,
               trx_line_id
        FROM   ar_trx_lines_gt
        WHERE  attribute1 IS NOT NULL
        OR     attribute2 IS NOT NULL
        OR     attribute3 IS NOT NULL
        OR     attribute4 IS NOT NULL
        OR     attribute5 IS NOT NULL
        OR     attribute6 IS NOT NULL
        OR     attribute7 IS NOT NULL
        OR     attribute8 IS NOT NULL
        OR     attribute9 IS NOT NULL
        OR     attribute10 IS NOT NULL
        OR     attribute11 IS NOT NULL
        OR     attribute12 IS NOT NULL
        OR     attribute13 IS NOT NULL
        OR     attribute14 IS NOT NULL
        OR     attribute15 IS NOT NULL;

Line: 1296

        SELECT attribute1, attribute2, attribute3,
               attribute4, attribute5, attribute6,
               attribute7, attribute8, attribute9,
               attribute10, attribute11, attribute12,
               attribute13, attribute14, attribute15,
               attribute_category,
               trx_header_id,
               trx_line_id,
               trx_dist_id
        FROM   ar_trx_dist_gt
        WHERE  attribute1 IS NOT NULL
        OR     attribute2 IS NOT NULL
        OR     attribute3 IS NOT NULL
        OR     attribute4 IS NOT NULL
        OR     attribute5 IS NOT NULL
        OR     attribute6 IS NOT NULL
        OR     attribute7 IS NOT NULL
        OR     attribute8 IS NOT NULL
        OR     attribute9 IS NOT NULL
        OR     attribute10 IS NOT NULL
        OR     attribute11 IS NOT NULL
        OR     attribute12 IS NOT NULL
        OR     attribute13 IS NOT NULL
        OR     attribute14 IS NOT NULL
        OR     attribute15 IS NOT NULL;

Line: 1323

        SELECT attribute1, attribute2, attribute3,
               attribute4, attribute5, attribute6,
               attribute7, attribute8, attribute9,
               attribute10, attribute11, attribute12,
               attribute13, attribute14, attribute15,
               attribute_category,
               trx_header_id,
               trx_line_id,
               trx_salescredit_id
        FROM   ar_trx_salescredits_gt
        WHERE  attribute1 IS NOT NULL
        OR     attribute2 IS NOT NULL
        OR     attribute3 IS NOT NULL
        OR     attribute4 IS NOT NULL
        OR     attribute5 IS NOT NULL
        OR     attribute6 IS NOT NULL
        OR     attribute7 IS NOT NULL
        OR     attribute8 IS NOT NULL
        OR     attribute9 IS NOT NULL
        OR     attribute10 IS NOT NULL
        OR     attribute11 IS NOT NULL
        OR     attribute12 IS NOT NULL
        OR     attribute13 IS NOT NULL
        OR     attribute14 IS NOT NULL
        OR     attribute15 IS NOT NULL;

Line: 1384

                INSERT INTO ar_trx_errors_gt
                    (   trx_header_id,
                        error_message,
                        invalid_value) values (
                    cFlexAttrRec.trx_header_id,
                    arp_standard.fnd_message('AR_INAPI_INVALID_DESC_FLEX'),
                    'RA_CUSTOMER_TRX') ;

Line: 1419

                INSERT INTO ar_trx_errors_gt
                    (   trx_header_id,
                        error_message,
                        invalid_value) VALUES (
                 cFlexIntAttrRec.trx_header_id,
                  arp_standard.fnd_message('AR_INAPI_INVALID_DESC_FLEX'),
                  'RA_INTERFACE_HEADER') ;

Line: 1456

                INSERT INTO ar_trx_errors_gt
                    (   trx_header_id,
                        trx_line_id,
                        error_message,
                        invalid_value) values (
                    clFlexAttrRec.trx_header_id,
                    clFlexAttrRec.trx_line_id,
                    arp_standard.fnd_message('AR_INAPI_INVALID_DESC_FLEX'),
                    'RA_CUSTOMER_TRX_LINES') ;

Line: 1494

                INSERT INTO ar_trx_errors_gt
                    (   trx_header_id,
                        trx_line_id,
                        error_message,
                        invalid_value) VALUES (
                 clFlexIntAttrRec.trx_header_id,
                 clFlexIntAttrRec.trx_line_id,
                  arp_standard.fnd_message('AR_INAPI_NONUNIQUE_DESC_FLEX'),
                  'RA_INTERFACE_LINES') ;

Line: 1511

                INSERT INTO ar_trx_errors_gt
                    (   trx_header_id,
                        trx_line_id,
                        error_message,
                        invalid_value) VALUES (
                 clFlexIntAttrRec.trx_header_id,
                 clFlexIntAttrRec.trx_line_id,
                  arp_standard.fnd_message('AR_INAPI_INVALID_DESC_FLEX'),
                  'RA_INTERFACE_LINES') ;

Line: 1550

                INSERT INTO ar_trx_errors_gt
                    (   trx_header_id,
                        trx_line_id,
                        trx_dist_id,
                        error_message,
                        invalid_value) values (
                    cdFlexAttrRec.trx_header_id,
                    cdFlexAttrRec.trx_line_id,
                    cdFlexAttrRec.trx_dist_id,
                    arp_standard.fnd_message('AR_INAPI_INVALID_DESC_FLEX'),
                    'RA_CUST_TRX_LINE_GL_DIST') ;

Line: 1591

                INSERT INTO ar_trx_errors_gt
                    (   trx_header_id,
                        trx_line_id,
                        trx_salescredit_id,
                        error_message,
                        invalid_value) values (
                    csFlexAttrRec.trx_header_id,
                    csFlexAttrRec.trx_line_id,
                    csFlexAttrRec.trx_salescredit_id,
                    arp_standard.fnd_message('AR_INAPI_INVALID_DESC_FLEX'),
                    'RA_CUST_TRX_LINE_SALESREPS') ;