[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select value
INTO l_utl_file_dir
FROM v$parameter
WHERE name = 'utl_file_dir';
l_last_update_login NUMBER;
select association_id,action, relationship_code, from_entity_name, from_pk1_value,
from_pk2_value, from_pk3_value, from_pk4_value, from_pk5_value,
to_entity_name, to_pk1_value, to_pk2_value, to_pk3_value,
to_pk4_value, to_pk5_value, created_by, last_update_login,to_current_value
from eng_relationship_changes
where change_id = p_change_id
and entity_id = p_entity_id;
P_LAST_UPDATE_LOGIN => REL_CHANGES.last_update_login,
X_RETURN_STATUS => l_return_status,
X_MSG_COUNT => l_msg_count,
X_MSG_DATA => l_msg_data
);
select change_id, entity_id, b.category_id,
from_pk1_value pk1_value, from_pk2_value pk2_value,
from_pk3_value pk3_value
from eng_relationship_changes a, dom_documents b
where a.change_id = l_change_id
and a.to_pk1_value = b.document_id
and to_pk2_value = -1 -- for floating revision documents
and action in ('ADD','CHANGE_REVISION')
and entity_id in (select decode(l_revised_item_seq_id,null, (select revised_item_sequence_id
from eng_revised_items
where change_id = a.change_id),
l_revised_item_seq_id) from dual);
SELECT ecp.policy_char_value INTO l_change_policy
FROM
(select nvl(mirb.lifecycle_id, msi.lifecycle_id) as lifecycle_id,
nvl(mirb.current_phase_id , msi.current_phase_id) as phase_id,
msi.item_catalog_group_id item_catalog_group_id,
msi.inventory_item_id, msi.organization_id , mirb.revision_id
from mtl_item_revisions_b mirb,
MTL_SYSTEM_ITEMS msi
where mirb.INVENTORY_ITEM_ID(+) = msi.INVENTORY_ITEM_ID
and mirb.ORGANIZATION_ID(+)= msi.ORGANIZATION_ID
and mirb.revision_id(+) = c2.pk3_value
and msi.INVENTORY_ITEM_ID = c2.pk2_value
and msi.ORGANIZATION_ID = c2.pk1_value) ITEM_DTLS,
ENG_CHANGE_POLICIES_V ECP
WHERE
ecp.policy_object_pk1_value =
(SELECT TO_CHAR(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
WHERE olc.object_id = (SELECT OBJECT_ID
FROM fnd_objects
WHERE obj_name = 'EGO_ITEM')
AND olc.lifecycle_id = ITEM_DTLS.lifecycle_id
AND olc.object_classification_code = ic.item_catalog_group_id
)
AND ROWNUM = 1
CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
START WITH item_catalog_group_id = ITEM_DTLS.item_catalog_group_id)
AND ecp.policy_object_pk2_value = ITEM_DTLS.lifecycle_id
AND ecp.policy_object_pk3_value = ITEM_DTLS.phase_id
and ecp.policy_object_name = 'CATALOG_LIFECYCLE_PHASE'
and ecp.attribute_object_name = 'EGO_CATALOG_GROUP'
and ecp.attribute_code = 'AML_RULE'
and ecp.attribute_number_value = 2;