DBA Data[Home] [Help]

APPS.ENG_REVISED_ITEM_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 19: , p_new_description mtl_system_items_b.description%TYPE

15: PROCEDURE update_new_description
16: (
17: p_api_version IN NUMBER := 1.0
18: , p_revised_item_sequence_id IN NUMBER
19: , p_new_description mtl_system_items_b.description%TYPE
20: ) IS
21:
22: BEGIN
23: UPDATE ENG_REVISED_ITEMS SET NEW_ITEM_DESCRIPTION = p_new_description WHERE REVISED_ITEM_SEQUENCE_ID = p_revised_item_sequence_id;

Line 1594: FROM mtl_system_items

1590: l_current_item_revision_id NUMBER;
1591: --added for 3972225
1592: CURSOR c_revised_phase_id (cp_revised_item_id NUMBER,cp_organization_id NUMBER) IS
1593: SELECT current_phase_id
1594: FROM mtl_system_items
1595: WHERE inventory_item_id = cp_revised_item_id
1596: and organization_id = cp_organization_id ;
1597:
1598: l_current_lifecycle_phase_id NUMBER;