DBA Data[Home] [Help]

APPS.OE_HOLDS_WF dependencies on OE_ORDER_LINES

Line 107: FROM oe_order_lines

103:
104: l_line_id := to_number(itemkey);
105: SELECT header_id
106: INTO l_header_id
107: FROM oe_order_lines
108: WHERE line_id = to_number(itemkey);
109:
110: -- Not needed anymore.
111: --ELSIF itemtype='OECHGORD' THEN

Line 121: -- FROM oe_order_lines

117: --
118: -- IF l_header_id IS NULL then
119: -- SELECT header_id
120: -- INTO l_header_id
121: -- FROM oe_order_lines
122: -- WHERE line_id = l_line_id;
123: -- END IF;
124:
125: END IF; -- end for the itemtype check