DBA Data[Home] [Help]

APPS.AMS_ITEM_CATEGORY_PVT dependencies on AMS_ITEM_ATTRIBUTES

Line 39: FROM ams_item_attributes

35:
36:
37: Cursor Get_owner_id IS
38: SELECT item_owner_id
39: FROM ams_item_attributes
40: WHERE inventory_item_id = p_inventory_item_id
41: AND organization_id = p_organization_id;
42:
43: l_return_status_cue VARCHAR2(1);

Line 150: FROM ams_item_attributes

146: AND inventory_item_id = p_inventory_item_id;
147:
148: Cursor Get_owner_id IS
149: SELECT item_owner_id
150: FROM ams_item_attributes
151: WHERE inventory_item_id = p_inventory_item_id
152: AND organization_id = p_organization_id;
153:
154: l_return_status_cue VARCHAR2(1);