APPS.ENG_DOM_UTIL_PUB SQL Statements

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

Line: 53

SELECT r.attribute_code,
       ra.attribute_column_type,
       r.attribute_number_value,
       r.attribute_char_value,
       p.policy_column_type,
       pv.policy_char_value,
       pv.policy_number_value,
       ra.attribute_object_name
from
       eng_change_rule_attributes_vl ra,
       eng_change_rules r,
       eng_change_policy_values pv,
       eng_change_policies p
where
       p.policy_object_name = cp_pol_obj_name
       and p.policy_code= cp_pol_code
       and p.policy_object_pk1_value = cp_pol_pk1
       and p.policy_object_pk2_value = cp_pol_pk2
       and p.policy_object_pk3_value = cp_pol_pk3
       and ra.attribute_object_name = cp_attr_obj_name
       and ra.attribute_code = cp_attr_code
       and p.change_policy_id = pv.change_policy_id
       and pv.change_rule_id = r.change_rule_id
       and r.attribute_object_name = ra.attribute_object_name
       and r.attribute_code = ra.attribute_code
       and r.attribute_number_value IS NOT NULL;

Line: 83

     SELECT ic.item_catalog_group_id
       FROM MTL_ITEM_CATALOG_GROUPS_B ic
      WHERE EXISTS (
              SELECT olc.object_classification_code CatalogId
                FROM  ego_obj_type_lifecycles olc, fnd_objects o
               WHERE o.obj_name =  'EGO_ITEM'
                 AND olc.object_id = o.object_id
                 AND olc.lifecycle_id = cp_lifecycle_id
                 AND olc.object_classification_code = item_catalog_group_id
                   )
     CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
     START WITH item_catalog_group_id = cp_catalog_category_id;

Line: 102

  SELECT lifecycle_id,
         current_phase_id,
         item_catalog_group_id
  INTO
         l_lifecycle_id,
         l_current_phase_id,
         l_catalog_id
  FROM MTL_SYSTEM_ITEMS
  WHERE inventory_item_id = p_inventory_item_id
  AND organization_id = p_organization_id;

Line: 113

  SELECT REV.lifecycle_id,
         REV.current_phase_id,
         IT.item_catalog_group_id
  INTO
         l_lifecycle_id,
         l_current_phase_id,
         l_catalog_id
  FROM MTL_ITEM_REVISIONS REV, MTL_SYSTEM_ITEMS IT
  WHERE
        REV.inventory_item_id = IT.inventory_item_id
  AND   REV.inventory_item_id = p_inventory_item_id
  AND   REV.organization_id = p_organization_id
  AND   REV.revision_id = p_revision_id;

Line: 172

attach_query := 'select count(*) from  (SELECT a.ATTACHED_DOCUMENT_ID,
       a.DOCUMENT_ID,
       a.ENTITY_NAME,
       a.PK1_VALUE,
       a.PK2_VALUE,
       a.PK3_VALUE,
       a.PK4_VALUE,
       a.PK5_VALUE,
       nvl(a.CATEGORY_ID, d.CATEGORY_ID) AS CATEGORY_ID,
       d.DOCUMENT_ID AS DOCUMENT_ID1,
       dt.DESCRIPTION,
       dt.FILE_NAME FILE_NAME,
       dt.MEDIA_ID,
       d.DM_DOCUMENT_ID,
       d.DM_VERSION_NUMBER,
       pr.PROTOCOL
FROM FND_ATTACHED_DOCUMENTS a,
     FND_DOCUMENTS d,
     FND_DOCUMENTS_TL dt,
     FND_DOCUMENT_CATEGORIES_TL ct,
     FND_DM_NODES n,
     FND_LOOKUP_VALUES_VL lkp,
     DOM_FOLDER_ATTACHMENTS df,
     FND_DM_NODES dn,
     FND_DM_PRODUCTS pr
WHERE a.DOCUMENT_ID = d.DOCUMENT_ID and
      d.DOCUMENT_ID = dt.DOCUMENT_ID and
      dt.LANGUAGE = USERENV(''LANG'') and
      ct.CATEGORY_ID = nvl(a.CATEGORY_ID, d.CATEGORY_ID) and
      ct.LANGUAGE = USERENV(''LANG'') and
      d.DM_NODE = n.NODE_ID (+)
      and lkp.LOOKUP_TYPE(+) = ''FND_DM_ATTACHED_DOC_STATUS''
      and lkp.LOOKUP_CODE(+) = nvl(a.STATUS,''UNAPPROVED'')
      and df.attachment_id(+)=a.attached_document_id
      and d.dm_node = dn.node_id
      and dn.PRODUCT_ID = pr.product_id)';