APPS.CSE_FA_STAGE_PKG SQL Statements

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

Line: 43

      SELECT pol.item_id,
             pol.line_num,
             pol.item_description,
             pod.destination_type_code,
             pod.destination_organization_id,
             pol.org_id
      FROM   po_distributions_all pod,
             po_lines_all         pol
      WHERE  pod.po_distribution_id = p_dist_id
      AND    pol.po_line_id         = pod.po_line_id;

Line: 55

      SELECT po_distribution_id
      FROM   ap_invoice_distributions_all aid
      WHERE  aid.invoice_id                = p_invoice_id
      AND    aid.distribution_line_number  = p_ap_dist_line_number;

Line: 87

            SELECT inventory_organization_id
            INTO   l_organization_id
            FROM   financials_system_params_all
            WHERE  org_id = po_rec.org_id;

Line: 95

          SELECT nvl(comms_nl_trackable_flag, 'N')
          INTO   l_ib_trackable_flag
          FROM   mtl_system_items
          WHERE  inventory_item_id = l_inventory_item_id
          AND    organization_id   = l_organization_id;

Line: 174

        SELECT csi_fa_headers_s.nextval
        INTO   l_interface_header_id
        FROM   sys.dual;

Line: 178

        csi_fa_headers_pkg.INSERT_ROW (
          X_ROWID               => l_rowid,
          X_INTERFACE_HEADER_ID => l_interface_header_id,
          X_FA_ASSET_ID         => p_asset_hdr_rec.asset_id,
          X_FEEDER_SYSTEM_NAME  => l_feeder_system_name,
          X_STATUS_CODE         => 'NEW',
          X_FA_BOOK_TYPE_CODE   => p_asset_hdr_rec.book_type_code,
          X_CREATION_DATE       => sysdate,
          X_CREATED_BY          => fnd_global.user_id,
          X_LAST_UPDATE_DATE    => sysdate,
          X_LAST_UPDATED_BY     => fnd_global.user_id,
          X_LAST_UPDATE_LOGIN   => fnd_global.login_id);

Line: 200

          SELECT csi_fa_transactions_s.nextval
          INTO   l_interface_line_id
          FROM   sys.dual;

Line: 204

          csi_fa_transactions_pkg.INSERT_ROW (
            X_ROWID                    => l_rowid,
            X_INTERFACE_LINE_ID        => l_interface_line_id,
            X_INTERFACE_HEADER_ID      => l_interface_header_id,
            X_DISTRIBUTION_ID          => p_asset_dist_tbl(dist_ind).distribution_id,
            X_TRANSACTION_DATE         => p_trans_rec.transaction_date_entered,
            X_TRANSACTION_UNITS => nvl(p_asset_dist_tbl(dist_ind).transaction_units, p_asset_desc_rec.current_units),
            X_TRANSACTION_COST         => p_asset_fin_rec.cost,
            X_PARENT_MASS_ADDITION_ID  => l_parent_mass_addition_id,
            X_PA_ASSET_LINE_ID         => l_pa_asset_line_id,
            X_TRANSFER_DISTRIBUTION_ID => null,
            X_RETIREMENT_ID            => null,
            X_STATUS_CODE              => 'NEW',
            X_DATE_PROCESSED           => null,
            X_DATE_NOTIFIED            => null,
            X_ERROR_FLAG               => 'N',
            X_ERROR_TEXT               => null,
            X_TRANSACTION_SOURCE_TYPE  => p_trans_rec.transaction_type_code,
            X_CREATION_DATE            => sysdate,
            X_CREATED_BY               => fnd_global.user_id,
            X_LAST_UPDATE_DATE         => sysdate,
            X_LAST_UPDATED_BY          => fnd_global.user_id,
            X_LAST_UPDATE_LOGIN        => fnd_global.login_id);

Line: 290

      SELECT cfh.interface_header_id,
             cfh.fa_asset_id,
             fa.asset_number,
             fa.description asset_description,
             cfh.fa_book_type_code,
             cfh.created_by,
             cft.interface_line_id,
             cft.transaction_source_type,
             cft.transaction_units,
             cft.transaction_date,
             cft.transaction_cost,
             cfh.feeder_system_name
      FROM   csi_fa_headers      cfh,
             csi_fa_transactions cft,
             fa_additions        fa
      WHERE  cfh.status_code         = 'NEW'
      AND    cft.interface_header_id = cfh.interface_header_id
      AND    cft.status_code         = 'NEW'
      AND    fa.asset_id             = cfh.fa_asset_id;

Line: 401

    SELECT fnd_profile.value('apps_framework_agent')||'/OA_HTML/OA.jsp?OAFunc=CSE_OANF_FA_SEARCH'
    INTO   l_ib_url
    FROM   sys.dual;

Line: 425

    SELECT csi_wf_item_key_number_s.nextval
    INTO   l_item_key_seq
    FROM   sys.dual;

Line: 438

    SELECT responsibility_name
    INTO   l_resp_name
    FROM   fnd_responsibility fr, fnd_responsibility_tl frt
    WHERE  fr.responsibility_key = 'CSE_SUPER_USER_RESP'
    AND    frt.responsibility_id = fr.responsibility_id
    AND    frt.language = 'US';

Line: 483

    SELECT responsibility_name
    INTO   l_resp_name
    FROM   fnd_responsibility fr, fnd_responsibility_tl frt
    WHERE  fr.responsibility_key = 'CSE_ASSET_PLANNER'
    AND    frt.responsibility_id = fr.responsibility_id
    AND    frt.language = 'US';