APPS.OKL_AM_REMARKET_ASSET_PVT SQL Statements

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

Line: 60

    SELECT OKL_IMR_SEQ.NEXTVAL
    FROM   DUAL;

Line: 360

              'before insert call sts..'||x_return_status);

Line: 366

      INSERT INTO mtl_transactions_interface
                  (source_code,
                   source_header_id,
                   lock_Flag,
                   Source_line_id,
                   process_flag,
                   transaction_mode,
                   last_update_date,
                   last_updated_by,
                   creation_date,
                   created_by,
                   transaction_header_id,
                   validation_required,
                   inventory_item_id,
                   organization_id,
                   subinventory_code,
                   transaction_quantity,
                   transaction_uom,
                   transaction_date,
                   transaction_type_id,
                   transaction_reference,
                 --SECHAWLA Bug # 2620853 : No need to store distribution account id
                 --  distribution_account_id,
                   transaction_source_id,
                   transaction_source_name,
                   expenditure_type)
      VALUES
                  ('LEASE',              /* source_code */
                   0,                    /* source_header_id */
--                   '',                   /* lock_Flag */
                   2,                   /* lock_Flag */
                   0,                    /* Source_line_id */
                   1,                    /* process_flag */
                   3,                    /* transaction_mode */
                   p_sysdate,              /* last_update_date */
                   FND_GLOBAL.USER_ID,   /* last_updated_by */
                   p_sysdate,              /* creation_date */
                   FND_GLOBAL.USER_ID,   /* created_by */
                   112,                  /* transaction_header_id */
                   1,                    /* validation_required */
                   p_Inventory_Item_id,  /* inventory_item_id */
                   p_Organization_Id,    /* organization_id */
                   p_Subinv_Code,        /* subinventory_code */
                   p_quantity,            /* transaction_quantity */
                   'EA',                 /* transaction_uom */
                   p_sysdate,              /* transaction_date */
                   p_trans_type_id,      /* transaction_type_id */
                   'LEASE' ,             /* transaction_reference */
                -- SECHAWLA Bug# 2620853 : No need to store distribution account id
                --   p_Dist_account_id,    /* distribution_account_id */
                   0,                    /* transaction_source_id */
                   'LEASE',              /* transaction_source_name */
                   ''                    /* expenditure_type */
                   );

Line: 508

     gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 651

SELECT organization_name
-- SECHAWLA 08-MAR-04 3492490 : Validate against ORG_ORGANIZATION_DEFINITIONS, as we use this view to set the LOV for
-- inventory organization.  mtl_organizations may not have all the orgs that ORG_ORGANIZATION_DEFINITIONS has. For
-- our validation purposes, we do not need the restrictions that mtl_organizations uses to filter out certain orgs
--FROM   mtl_organizations
FROM   ORG_ORGANIZATION_DEFINITIONS
WHERE  organization_id = p_org_id;

Line: 661

SELECT 'Validate Org and Subinv'
FROM   mtl_secondary_inventories
WHERE  organization_id = p_inv_org_id
AND    secondary_inventory_name = p_subinv_code;

Line: 670

SELECT  name
FROM    QP_LIST_HEADERS
WHERE   LIST_HEADER_ID = p_list_header_id;

Line: 679

SELECT  'x'
FROM    GL_CODE_COMBINATIONS
WHERE   code_combination_id = p_ccid
AND     enabled_flag = 'Y';

Line: 688

SELECT warehouse_id, default_outbound_line_type_id, name
FROM   oe_transaction_types_all a, oe_transaction_types_tl b
WHERE  a.transaction_type_id = b.transaction_type_id
AND    a.transaction_type_id = p_trans_id;

Line: 698

SELECT a.master_organization_id, b.organization_name master_org_name
FROM   mtl_parameters a , ORG_ORGANIZATION_DEFINITIONS b
WHERE  a.organization_id = p_org_id
AND    a.master_organization_id = b.organization_id ;

Line: 750

 SELECT REMK_ORGANIZATION_ID, REMK_SUBINVENTORY, REMK_PRICE_LIST_ID
 ,ORG_ID -- Added for bug 10081463
 FROM   OKL_SYSTEM_PARAMS ;

Line: 757

 SELECT count(*)
 FROM   MTL_SYSTEM_ITEMS_B
 WHERE  segment1 = cp_inv_item_number;

Line: 799

     SELECT SYSDATE INTO l_sysdate FROM DUAL;

Line: 1662

   INV_Item_GRP.update_item
   (
         p_commit              => l_commit,
         p_lock_rows           => l_lock_rows
     ,   p_validation_level    => l_validation_level
     ,   p_Item_rec            => l_Item_rec
     ,   x_Item_rec            => x_item_rec
     ,   x_return_status       => x_return_status
     ,   x_Error_tbl           => x_Error_tbl
   );

Line: 1768

SELECT list_header_id, list_line_id
FROM   qp_pricing_attributes
WHERE  product_attr_value = to_char(p_item_id);

Line: 1780

         gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 1788

         gpr_price_list_line_tbl(1).operation := QP_GLOBALS.G_OPR_UPDATE;

Line: 1868

SELECT 'x'
FROM   mtl_system_items_b
WHERE  inventory_item_id = p_inventory_item_id
AND    organization_id = p_organization_id
AND    end_date_active IS NULL;

Line: 2010

SELECT order_number
FROM   oe_order_headers_all
WHERE  header_id = cp_header_id;

Line: 2017

SELECT line_id, inventory_item_id, ordered_quantity, ship_from_org_id
FROM   oe_order_lines_all
WHERE  header_id = p_header_id;

Line: 2025

SELECT header_id, inventory_item_id, ordered_quantity, ship_from_org_id
FROM   oe_order_lines_all
WHERE  line_id = cp_line_id;

Line: 2034

SELECT SOURCE_SUBINVENTORY
FROM   mtl_system_items
WHERE  inventory_item_id = p_item_id
AND    organization_id = p_org_id;

Line: 2074

   SELECT SYSDATE INTO l_sysdate FROM dual;