APPS.OKL_AM_CUSTOM_RMK_ASSET_PVT SQL Statements

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

Line: 47

SELECT 'x'
FROM   okl_asset_returns_b
WHERE  id = cp_asset_return_id;

Line: 53

SELECT organization_name
FROM   ORG_ORGANIZATION_DEFINITIONS
WHERE  organization_id = cp_org_id;

Line: 61

SELECT  'x'
--FROM    QP_LIST_HEADERS_B -- SECHAWLA 08-DEC-04 4047159
FROM    QP_LIST_HEADERS -- SECHAWLA 08-DEC-04 4047159
WHERE   LIST_HEADER_ID = cp_list_header_id;

Line: 69

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 = cp_trans_id;

Line: 76

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

Line: 82

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

Line: 88

 SELECT TEMPLATE_NAME
       --  DESCRIPTION ,
 FROM  MTL_ITEM_TEMPLATES
 WHERE TEMPLATE_ID = cp_item_templ_id
 AND   ( (CONTEXT_ORGANIZATION_ID IS NULL ) OR (CONTEXT_ORGANIZATION_ID = cp_org_id));

Line: 169

     SELECT SYSDATE INTO l_sysdate FROM DUAL;

Line: 619

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

Line: 625

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: 639

    SELECT OKL_IMR_SEQ.NEXTVAL
    FROM   DUAL;

Line: 1037

            			  'before OKL_ASSET_RETURNS_PUB.update_asset_returns'||x_return_status);

Line: 1042

    OKL_ASSET_RETURNS_PUB.update_asset_returns(
      p_api_version        => p_api_version,
      p_init_msg_list      => OKL_API.G_FALSE,
      x_return_status      => x_return_status,
      x_msg_count          => x_msg_count,
      x_msg_data           => x_msg_data,
      p_artv_rec           => lp_artv_rec,
      x_artv_rec           => lx_artv_rec);

Line: 1053

            			  'after OKL_ASSET_RETURNS_PUB.update_asset_returns'||x_return_status);

Line: 1246

      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: 1415

SELECT  name
FROM    QP_LIST_HEADERS
WHERE   LIST_HEADER_ID = cp_list_header_id;

Line: 1421

SELECT segment1
FROM   mtl_system_items_b
WHERE  inventory_item_id = cp_item_id;

Line: 1464

     gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_UPDATE;