APPS.PJM_COMMITMENT_UTILS SQL Statements

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

Line: 13

    SELECT T.TYPE_NAME into L_Type_Name
    from PO_DOCUMENT_TYPES_ALL_TL T
    WHERE T.LANGUAGE = userenv('LANG')
      and T.DOCUMENT_TYPE_CODE = 'REQUISITION'
      AND T.DOCUMENT_SUBTYPE  = X_Subtype
      and NVL(T.org_id, -99) = NVL(X_Org_Id, -99);

Line: 37

  select resource_code into L_Resource_Code
  from bom_resources
  where resource_id = X_resource_id;

Line: 59

  SELECT segment1 into L_Item_Number
  from mtl_system_items_b
  where inventory_item_id = X_Item_Id
  and organization_id = X_Organization_Id;

Line: 87

    select BD.PA_EXPENDITURE_ORG_ID into L_Exp_Org
    from WIP_OPERATIONS   WO
       , BOM_DEPARTMENTS  BD
    where WO.ORGANIZATION_ID = X_org
      AND WO.WIP_ENTITY_ID = X_entity
      AND WO.OPERATION_SEQ_NUM = X_seq
      AND BD.DEPARTMENT_ID = WO.DEPARTMENT_ID;

Line: 155

    select WO.STANDARD_OPERATION_ID
         , WDJ.WIP_ENTITY_ID
         , WDJ.PRIMARY_ITEM_ID
         , WO.DEPARTMENT_ID
    into L_op, L_entity, L_item, L_dep
    from WIP_DISCRETE_JOBS            WDJ
       , WIP_OPERATIONS               WO
       , BOM_DEPARTMENTS              BD
    where    WDJ.ORGANIZATION_ID = X_org
      AND    WDJ.WIP_ENTITY_ID = X_entity
      AND    WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
      AND    WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
      AND    WO.OPERATION_SEQ_NUM = X_seq
      AND    BD.DEPARTMENT_ID = WO.DEPARTMENT_ID;

Line: 198

    select DECODE( X_pollookup
                   , MSI.PRIMARY_UNIT_OF_MEASURE , 1
                   , INV_CONVERT.INV_UM_CONVERT
                     ( X_item, 5 , 1
                     , NULL , NULL
                     , X_pollookup
                     , MSI.PRIMARY_UNIT_OF_MEASURE ) )
    into L_Uom_Conversion_Rate
    from mtl_system_items_b MSI
    where MSI.ORGANIZATION_ID = X_org
      AND MSI.INVENTORY_ITEM_ID = X_item;

Line: 237

    select primary_unit_of_measure
    into L_Unit
    from mtl_system_items_b MSI
    where MSI.ORGANIZATION_ID = X_org
      AND MSI.INVENTORY_ITEM_ID = X_item;

Line: 267

    select primary_uom_code
    into L_Unit
    from mtl_system_items_b MSI
    where MSI.ORGANIZATION_ID = X_org
      AND MSI.INVENTORY_ITEM_ID = X_item;

Line: 275

    select uom_code into L_Unit
    from MTL_UNITS_OF_MEASURE_VL
    where unit_of_measure = X_pollookup;

Line: 299

    select UOM.UNIT_OF_MEASURE_TL
    into L_Unit
    from mtl_system_items_b MSI,
         mtl_units_of_measure_vl UOM
    where MSI.ORGANIZATION_ID = X_org
      AND MSI.INVENTORY_ITEM_ID = X_item
      AND UOM.UOM_CODE = MSI.PRIMARY_UOM_CODE;

Line: 309

    select UNIT_OF_MEASURE_TL into L_Unit
    from MTL_UNITS_OF_MEASURE_VL
    where unit_of_measure = X_pollookup;

Line: 328

  SELECT vendor_name into L_Vendor_Name
  from po_vendors
  where vendor_id = X_Vendor_id;

Line: 349

  SELECT full_name into L_Full_Name
  from PER_ALL_PEOPLE_F
  where person_id = X_Person_Id
  AND   TRUNC(SYSDATE) BETWEEN NVL(EFFECTIVE_START_DATE, SYSDATE - 1)
  AND   NVL(EFFECTIVE_END_DATE, SYSDATE + 1);

Line: 373

    SELECT T.TYPE_NAME into L_Type_Name
    from PO_DOCUMENT_TYPES_ALL_TL T
    WHERE T.LANGUAGE = userenv('LANG')
      and T.DOCUMENT_TYPE_CODE IN ('PO', 'PA')
      AND T.DOCUMENT_SUBTYPE  = X_Subtype
      and NVL(T.org_id, -99) = NVL(X_Org_Id, -99);

Line: 401

    select common_project_id into L_PO_Project
    from pjm_org_parameters
    where organization_id = X_Org_ID;

Line: 423

  SELECT br.expenditure_type
  FROM   bom_resources          br
  ,      cst_item_cost_details  cicd
  ,      mtl_parameters         mp
  WHERE  mp.organization_id = X_Org_ID
  AND    cicd.organization_id (+) = mp.organization_id
  AND    cicd.inventory_item_id (+) = X_Item_ID
  AND    cicd.cost_type_id (+) = mp.primary_cost_method
  AND    cicd.cost_element_id (+) = 1
  AND    br.resource_id = nvl( cicd.resource_id , mp.default_material_cost_id )
  AND    br.organization_id = mp.organization_id
  ORDER BY br.resource_id;

Line: 456

  SELECT expenditure_type
  FROM   bom_resources
  WHERE  resource_id = X_Resource_ID;

Line: 486

  SELECT dir_item_expenditure_type
  FROM   pjm_project_parameters
  WHERE  organization_id = X_Org_ID
  AND    project_id = X_Project_ID;

Line: 492

  SELECT expenditure_type
  FROM   bom_resources
  WHERE  resource_id = X_Resource_ID;

Line: 505

          select DISTINCT pet.expenditure_type
          into L_Exp_Type
          from cst_cat_ele_exp_assocs cceea,
               pa_expenditure_types pet
          where cceea.category_id = x_category_id
                  and cceea.expenditure_type_id = pet.expenditure_type_id;

Line: 546

  SELECT nvl(max(pp.project_reference_enabled) , 'N')
  ,      decode(max(pp.common_project_id) , NULL , 'N' , 'Y')
  FROM   pjm_org_parameters pp;

Line: 551

  SELECT ou.Oracle_Username
  FROM   fnd_product_installations pi
  ,      fnd_oracle_userid ou
  WHERE  ou.Oracle_ID = pi.Oracle_ID
  AND    Application_ID = 0;

Line: 568

    SELECT table_name
    FROM   user_synonyms
    WHERE  synonym_name = C_name;