APPS.CSE_UTIL_PKG SQL Statements

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

Line: 18

       SELECT   DISTINCT 'Y'
       FROM     mtl_system_items
       WHERE    inventory_item_id = p_item_id
       AND      organization_id =
                (select organization_id
                 from   mtl_system_items
                 where inventory_item_id=P_inventory_item_id
                 and  rownum =1)
       AND      enabled_flag = 'Y'
       AND      nvl (start_date_active, l_sysdate) <= l_sysdate
       AND      nvl (end_date_active, l_sysdate+1) > l_sysdate
       AND      comms_nl_trackable_flag = 'Y';

Line: 58

       SELECT   DISTINCT 'Y'
         FROM   mtl_system_items
        WHERE   inventory_item_id = P_item_id
          AND   organization_id = P_org_id
          AND   enabled_flag = 'Y'
          AND   nvl (start_date_active, l_sysdate) <= l_sysdate
          AND   nvl (end_date_active, l_sysdate+1) > l_sysdate
	      AND   lot_control_code <> 1;

Line: 94

       SELECT   DISTINCT 'Y'
         FROM   mtl_system_items
        WHERE   inventory_item_id = p_item_id
          AND   organization_id = p_org_id
          AND   enabled_flag = 'Y'
          AND   nvl (start_date_active, l_sysdate) <= l_sysdate
          AND   nvl (end_date_active, l_sysdate+1) > l_sysdate
          AND   serial_number_control_code <> 1;

Line: 136

       SELECT   DISTINCT 'Y'
         FROM   mtl_secondary_inventories
	    WHERE   secondary_inventory_name = p_subinv
          AND   organization_id = p_org_id
          AND   disable_date IS NULL
          AND   depreciable_flag = 1;

Line: 168

       SELECT   DISTINCT asset_creation_code
         FROM   mtl_system_items
        WHERE   inventory_item_id = p_inventory_item_id
          AND   organization_id =
                (select organization_id
                from   mtl_system_items
                where  inventory_item_id=p_inventory_item_id
                and rownum=1)
          AND   enabled_flag = 'Y'
          AND   nvl (start_date_active, l_sysdate) <= l_sysdate
          AND   nvl (end_date_active, l_sysdate+1) > l_sysdate;

Line: 390

  SELECT negative_inv_receipt_Code
  FROM   mtl_parameters
  WHERE  organization_id = pc_org_id;

Line: 423

     SELECT instance_status_id
     FROM csi_instance_statuses
     WHERE upper(name) ='CREATED';

Line: 581

  select location_id
  from hz_locations
  where clli_code=p_network_location_code;

Line: 626

  select location_id
  from hz_party_sites
  where party_site_id=p_party_site_id;

Line: 672

  select fa_location_id
  from   csi_a_locations
  where  location_id =p_hz_location_id;

Line: 723

  SELECT organization_code
  FROM   mtl_parameters
  WHERE  organization_id = p_organization_id;

Line: 730

  SELECT master_organization_id
  FROM   mtl_parameters
  WHERE  organization_id = p_organization_id;

Line: 833

FUNCTION Init_Instance_Update_Rec RETURN CSI_DATASTRUCTURES_PUB.Instance_Rec IS
l_Instance_Rec  CSI_DATASTRUCTURES_PUB.Instance_Rec;

Line: 837

END Init_Instance_Update_Rec;

Line: 907

    SELECT ctt.Transaction_Type_Id Transaction_Type_Id
    FROM   CSI_Txn_Types ctt,
           FND_Application fa
    WHERE  ctt.Source_Transaction_Type = P_Txn_Type
    AND    fa.application_id   = ctt.Source_Application_ID
    AND    fa.Application_Short_Name = P_App_Short_Name;

Line: 923

    SELECT Source_Transaction_Type
    FROM   CSI_Txn_Types
    WHERE  Transaction_Type_Id = P_Txn_Id;

Line: 945

  SELECT lookup_code
  FROM   csi_lookups
  WHERE  lookup_type = 'CSI_INST_LOCATION_SOURCE_CODE'
  AND    lookup_code = upper(P_Location_Meaning);

Line: 983

  SELECT   src_status_id
  FROM     csi_txn_sub_types
  WHERE    transaction_type_id = p_transaction_id
  AND      default_flag = 'Y';

Line: 1010

FUNCTION Get_Fnd_Employee_Id(P_Last_Updated IN NUMBER) RETURN NUMBER IS

l_employee_id     NUMBER;

Line: 1015

  SELECT employee_id
  FROM   fnd_user
  WHERE  user_id = p_last_updated;

Line: 1072

 SELECT 'X'
 FROM Fnd_Concurrent_Requests fcr,
      Fnd_Concurrent_Programs fcp,
      fnd_executables         fe
 WHERE fcr.Program_Application_Id = fcp.Application_Id
 AND   fcr.Concurrent_Program_Id  = fcp.Concurrent_Program_Id
 AND   fcr.Phase_Code = 'R'
 AND   fcr.Request_Id <> P_Request_Id
 AND   fcp.Executable_Application_Id = fe.Application_Id
 AND   fcp.Executable_Id = fe.Executable_Id
 AND   fcp.application_id = 873
 AND   fe.Executable_Name = P_Executable;

Line: 1118

    SELECT transaction_type_id
    FROM mtl_material_transactions
    WHERE transaction_id = p_transaction_id;

Line: 1241

  SELECT 1
  FROM csi_ii_relationships ciir1
  WHERE ciir1.object_id = p_id
  AND ciir1.relationship_type_code = 'COMPONENT-OF'
  AND NOT EXISTS (select ciir2.subject_id
                  from csi_ii_relationships ciir2
                  where ciir2.relationship_type_code = 'COMPONENT-OF'
                  and ciir2.subject_id = p_id);

Line: 1298

SELECT 'Y' redeploy_flag
FROM   csi_transactions ct
      ,csi_item_instances_h ciih
      ,csi_item_instances cii
WHERE  ct.transaction_id = ciih.transaction_id
AND    ciih.instance_id = cii.instance_id
AND    cii.inventory_item_id = p_inventory_item_id
AND    cii.serial_number = p_serial_number
AND    ct.transaction_date < NVL(p_transaction_date, SYSDATE)
AND    ct.transaction_type_id IN (l_out_of_sev, l_proj_insev, l_issue_hz, l_misc_issue_hz) ;