APPS.CSI_T_VLDN_ROUTINES_PVT SQL Statements

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

Line: 76

        SELECT transaction_line_id,
           source_transaction_type_id,
           source_transaction_id,
           source_transaction_table,
           source_txn_header_id,
           processing_status,
           error_code,
           error_explanation,
           config_session_hdr_id,
           config_session_item_id,
           config_session_rev_num,
           config_valid_status
    FROM   csi_t_transaction_lines
    where  transaction_line_id = p_txn_line_id;

Line: 131

    SELECT 'X'
    INTO   l_found
    FROM   csi_t_txn_line_details
    WHERE  txn_line_detail_id = p_txn_line_detail_id;

Line: 150

      SELECT txn_line_detail_id,
          transaction_line_id,
          source_transaction_flag,
          instance_id,
          location_type_code,
          location_id,
          active_start_date,
          active_end_date,
          changed_instance_id,
          source_txn_line_detail_id,
          processing_status,
          config_inst_hdr_id,
          config_inst_rev_num,
          config_inst_item_id
      FROM   csi_t_txn_line_details
      WHERE  txn_line_detail_id = p_txn_line_dtl_id;

Line: 208

    SELECT 'X'
    INTO   l_found
    FROM   csi_t_party_details
    WHERE  txn_party_detail_id = p_txn_party_detail_id;

Line: 231

    SELECT 'X'
    INTO   l_found
    FROM   csi_t_party_accounts
    WHERE  txn_account_detail_id = p_txn_acct_detail_id;

Line: 254

    SELECT 'X'
    INTO   l_found
    FROM   csi_t_ii_relationships
    WHERE  txn_relationship_id = p_txn_relationship_id;

Line: 275

    SELECT 'X'
    INTO   l_found
    FROM   csi_t_org_assignments
    WHERE  txn_operating_unit_id = p_txn_operating_unit_id;

Line: 297

    SELECT 'X'
    INTO   l_found
    FROM   csi_t_extend_attribs
    WHERE  txn_attrib_detail_id = p_txn_attrib_detail_id;

Line: 321

      SELECT 'X'
      INTO   l_found
      FROM   oe_order_lines_all
      WHERE  line_id = p_txn_source_id;

Line: 349

      SELECT 'X'
      FROM   csi_t_txn_line_details
      WHERE  transaction_line_id = p_transaction_line_id
      AND    (csi_transaction_id is not null
              OR
              processing_status = 'PROCESSED');

Line: 358

    SELECT processing_status
    INTO   l_processing_status
    FROM   csi_t_transaction_lines
    WHERE  transaction_line_id = p_transaction_line_id;

Line: 395

    SELECT instance_exists_flag,
           instance_id,
           inventory_item_id,
           inv_organization_id
    INTO   l_instance_exists_flag,
           l_instance_id,
           l_inventory_item_id,
           l_inv_organization_id
    FROM   csi_t_txn_line_details
    WHERE  txn_line_detail_id = p_txn_line_dtl_id;

Line: 429

    SELECT 'X'
    INTO   l_found
    FROM   csi_item_instances
    WHERE  instance_id = p_object_id;

Line: 449

    SELECT 'X'
    INTO   v_found
    FROM   csi_ii_relation_types
    WHERE  relationship_type_code = p_rltns_type_code;

Line: 471

    SELECT 'X'
    INTO   v_found
    FROM   csi_i_parties
    WHERE  instance_id = p_instance_id
    AND    instance_party_id = p_instance_party_id;

Line: 492

    SELECT 'X'
    INTO   l_found
    FROM   csi_ip_accounts
    WHERE  ip_account_id     = p_ip_account_id;

Line: 512

    SELECT 'X'
    INTO   l_found
    FROM   csi_i_org_assignments
    WHERE  instance_id = p_instance_id
    AND    instance_ou_id = p_instance_ou_id;

Line: 532

    SELECT object_id
    INTO   x_object_id
    FROM   csi_ii_relationships
    WHERE  relationship_id = p_csi_inst_rltns_id;

Line: 649

            SELECT inventory_item_id,
                   inv_master_organization_id,
                   unit_of_measure,
                   quantity
            INTO   l_inst_item_id,
                   l_inst_organization_id,
                   l_inst_uom_code,
                   l_inst_quantity
            FROM   csi_item_instances
            WHERE  instance_id = p_txn_line_dtl_tbl(l_index).instance_id;

Line: 803

          SELECT src_change_owner,
                 non_src_change_owner
          INTO   l_sub_type_rec.src_change_owner,
                 l_sub_type_rec.non_src_change_owner
          FROM   csi_txn_sub_types
          WHERE  sub_type_id = p_txn_line_dtl_tbl(l_td_ind).sub_type_id
          AND    transaction_type_id = p_txn_line_rec.source_transaction_type_id;

Line: 1232

      SELECT instance_party_id
      FROM   csi_i_parties
      WHERE  instance_id = p_csi_instance_id
      AND    relationship_type_code = 'OWNER';

Line: 1241

    SELECT instance_exists_flag,
           instance_id
    INTO   l_instance_exists_flag,
           l_csi_instance_id
    FROM   csi_t_txn_line_details
    WHERE  txn_line_detail_id = p_txn_line_detail_id;

Line: 1272

        SELECT 'x' INTO l_found
        FROM   csi_t_party_details
        WHERE  txn_line_detail_id = p_txn_line_detail_id
        AND    relationship_type_code = 'OWNER';

Line: 1341

      SELECT txn_line_detail_id
      INTO   l_txn_line_dtl_id
      FROM   csi_t_party_details
      WHERE  txn_party_detail_id = p_level_dtl_id;

Line: 1348

    SELECT transaction_line_id
    INTO   l_transaction_line_id
    FROM   csi_t_txn_line_details
    WHERE  txn_line_detail_id = l_txn_line_dtl_id;

Line: 1353

    SELECT nvl(processing_status, '#NONE#')
    INTO   l_processing_status
    FROM   csi_t_transaction_lines
    WHERE  transaction_line_id = l_transaction_line_id;

Line: 1378

      SELECT 'X'
      INTO   l_found
      FROM   csi_i_extended_attribs
      WHERE  attribute_id = p_attrib_source_id;

Line: 1385

      SELECT 'X'
      INTO   l_found
      FROM   csi_iea_values
      WHERE  attribute_value_id = p_attrib_source_id;

Line: 1426

    SELECT 'X'
    INTO   l_found
    FROM   hz_cust_accounts
    WHERE  party_id = p_party_id
    AND    cust_account_id = p_party_account_id;

Line: 1457

      SELECT txn_line_detail_id
      INTO   l_txn_line_dtl_id
      FROM   csi_t_party_details
      WHERE  txn_party_detail_id = p_level_dtl_id;

Line: 1464

    SELECT instance_id ,
           instance_exists_flag
    INTO   x_instance_id,
           x_instance_exists_flag
    FROM   csi_t_txn_line_details
    WHERE  txn_line_detail_id = l_txn_line_dtl_id;

Line: 1486

    SELECT *
    INTO   x_party_detail_rec
    FROM   csi_t_party_details
    WHERE  txn_party_detail_id = p_party_detail_id;

Line: 1506

    SELECT 'X'
    INTO   l_found
    FROM   csi_item_instances
    WHERE  instance_id = p_instance_id;

Line: 1643

    SELECT 'X' INTO l_found
    FROM   hz_cust_accounts
    WHERE  cust_account_id = p_account_id;

Line: 1663

      SELECT csu.site_use_id
      FROM   hz_cust_site_uses_all csu
      WHERE  csu.site_use_id       = p_site_use_id
      AND    csu.site_use_code     = p_site_use_code;

Line: 1670

      SELECT csu.site_use_id
      FROM   hz_cust_site_uses_all csu ,
             hz_cust_acct_sites_all cas
      WHERE  csu.site_use_id       = p_site_use_id
      AND    csu.site_use_code     = p_site_use_code
      AND    csu.cust_acct_site_id = cas.cust_acct_site_id
      AND    cas.cust_account_id   = p_account_id;

Line: 1770

      SELECT 'X'
      FROM   csi_txn_sub_types
      WHERE  sub_type_id         = p_sub_type_id
      AND    transaction_type_id = nvl(p_txn_type_id, transaction_type_id);

Line: 1779

    SELECT source_transaction_type_id
    INTO   l_txn_type_id
    FROM   csi_t_transaction_lines
    WHERE  transaction_line_id = p_transaction_line_id;

Line: 1803

    SELECT 'x'
    INTO   l_td_found
    FROM   csi_t_transaction_lines
    WHERE  source_transaction_table = p_txn_line_rec.source_transaction_table
    AND    source_transaction_id    = p_txn_line_rec.source_transaction_id;

Line: 1835

      SELECT lot_control_code,
             segment1
      INTO   l_lot_control_code,
             l_item_name
      FROM   mtl_system_items
      WHERE  inventory_item_id = p_inventory_item_id
      AND    organization_id   = p_organization_id;

Line: 1857

        SELECT 'X'
        INTO   l_found
        FROM   mtl_lot_numbers
        WHERE  inventory_item_id = p_inventory_item_id
        AND    lot_number        = p_lot_number;

Line: 1912

      SELECT serial_number_control_code,
             segment1
      INTO   l_serial_control_code,
             l_item_name
      FROM   mtl_system_items
      WHERE  inventory_item_id = p_inventory_item_id
      AND    organization_id   = p_organization_id;

Line: 1935

        SELECT 'X'
        INTO   l_found
        FROM   mtl_serial_numbers
        WHERE  inventory_item_id = p_inventory_item_id
        AND    serial_number     = p_serial_number;

Line: 1993

SELECT txn_relationship_id , object_type, subject_type
FROM   csi_t_ii_relationships
WHERE  subject_id = c_subject_id
AND    object_id = c_object_id
AND    relationship_type_code = c_relationship_type_code
AND    NVL(active_end_date , SYSDATE) >= SYSDATE ;

Line: 2162

            SELECT subject_id,
                   object_id,
                   relationship_type_code
            INTO   l_iir_rec.subject_id,
                   l_iir_rec.object_id,
                   l_iir_rec.relationship_type_code
            FROM   csi_ii_relationships
            WHERE  relationship_id = l_csi_rel_id
             AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);

Line: 2187

                    SELECT location_type_code
                    INTO   l_loc_type
                    FROM   csi_item_instances
                    WHERE  instance_id = l_iir_rec.subject_id -- either one should not be in Inventory
                     AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);

Line: 2209

            SELECT 'Y'
            INTO   l_found
            FROM   csi_item_instances
            WHERE  instance_id = l_instance_id
             AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);

Line: 2223

            SELECT 'Y'
            INTO l_found
            FROM CSI_II_RELATIONSHIPS
            WHERE relationship_type_code = 'COMPONENT-OF'
            AND subject_id = l_instance_id;

Line: 2266

       l_query := 'Select source_txn_header_id, source_transaction_type_id '||
                        'from csi_t_transaction_lines where transaction_line_id = :line_id';

Line: 2316

SELECT instance_hdr_id
FROM   cz_config_items_v
WHERE  instance_hdr_id = c_config_inst_hdr_id
AND    instance_rev_nbr = c_config_inst_rev_num
AND    config_item_id = c_config_inst_item_id ;

Line: 2370

SELECT instance_id
FROM   csi_item_instances
WHERE  config_inst_hdr_id = p_config_inst_hdr_id
AND    config_inst_rev_num = p_config_inst_rev_num
AND    config_inst_item_id = p_config_inst_item_id
AND    trunc(active_start_date) <= c_sysdate
AND    ( trunc(active_end_date) > c_sysdate OR
          active_end_date is NULL) ;

Line: 2381

SELECT txn_line_detail_id
FROM   csi_t_txn_line_details
WHERE  config_inst_hdr_id = p_config_inst_hdr_id
AND    config_inst_rev_num = p_config_inst_rev_num
AND    config_inst_item_id = p_config_inst_item_id  ;

Line: 2439

  SELECT a.transaction_line_id
  FROM   csi_t_transaction_lines a
  WHERE  a.config_session_hdr_id = p_config_session_hdr_id
  AND    a.config_session_rev_num = p_config_session_rev_num
  AND    a.config_session_item_id = p_config_session_item_id
  AND    a.source_transaction_table = 'CONFIGURATOR'; --fix for bug 5632296

Line: 2472

SELECT config_hdr_id
FROM   cz_config_items_v
WHERE  config_hdr_id = p_config_session_hdr_id
AND    config_rev_nbr = p_config_session_rev_num
AND    config_item_id = p_config_session_item_id ;