DBA Data[Home] [Help]

APPS.OE_NOTIFY_USER_WF dependencies on OE_ITEMS_V

Line 87: FROM oe_items_v

83:
84: BEGIN
85: SELECT item
86: INTO l_item_name
87: FROM oe_items_v
88: WHERE item_id = l_line_rec.ordered_item_id
89: AND inventory_item_id = l_line_rec.inventory_item_id
90: AND item_identifier_type = l_line_rec.item_identifier_type;
91: EXCEPTION

Line 131: FROM oe_items_v

127:
128: BEGIN
129: SELECT item
130: INTO l_item_name
131: FROM oe_items_v
132: WHERE item_id = l_line_rec.ordered_item_id
133: AND inventory_item_id = l_line_rec.inventory_item_id
134: AND item_identifier_type = l_line_rec.item_identifier_type;
135: EXCEPTION