DBA Data[Home] [Help]

APPS.OE_ORDER_UPGRADE_UTIL dependencies on OE_ORDER_LINES_ALL

Line 61: FROM oe_order_lines_all

57: BEGIN
58:
59: SELECT nvl(invoice_interface_status_code, 'NO')
60: INTO l_invoice_status_code
61: FROM oe_order_lines_all
62: WHERE line_id = p_line_id;
63:
64: IF l_invoice_status_code = 'YES' THEN
65: x_invoice_status_code := 'COMPLETE';

Line 141: FROM oe_order_lines_all

137: IF l_s26= OE_WF_UPGRADE_UTIL.RES_PARTIAL THEN
138:
139: SELECT shipped_quantity
140: INTO l_shipped_quantity
141: FROM oe_order_lines_all
142: WHERE line_id=p_line_id;
143:
144: IF l_shipped_quantity is null THEN
145: x_result := OE_WF_UPGRADE_UTIL.RES_INTERFACED;