APPS.OE_DUAL_UOM_UTIL dependencies on OE_ORDER_LINES_ALL

Line 142: -- p_line_rec : The function will take line_id as input, query oe_order_lines_all table and return value of fulfillment_base field.

138: -- Function get_fulfillment_base
139: --
140: -- GROUP API to return value of fulfillment_base filed on a line.
141: -- IN parameters -
142: -- p_line_rec : The function will take line_id as input, query oe_order_lines_all table and return value of fulfillment_base field.
143: ---------------------------------------------------------------------
144: Function get_fulfillment_base
145: ( p_line_id IN NUMBER
146: ) RETURN VARCHAR2

Line 149: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;

145: ( p_line_id IN NUMBER
146: ) RETURN VARCHAR2
147: IS
148:
149: l_fulfillment_base oe_order_lines_all.fulfillment_base%type;
150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
151: --
152: BEGIN
153:

Line 156: From oe_order_lines_all

152: BEGIN
153:
154: Select fulfillment_base
155: Into l_fulfillment_base
156: From oe_order_lines_all
157: Where line_id = p_line_id ;
158:
159: IF l_debug_level > 0 THEN
160: oe_debug_pub.add(' gfb: l_fulfillment_base ' ||l_fulfillment_base);

Line 489: FROM oe_order_lines_all

485:
486:
487: SELECT DISTINCT fulfillment_base
488: INTO l_ful_base
489: FROM oe_order_lines_all
490: WHERE line_category_code= 'RETURN'
491: AND return_context IN ('INVOICE' ,'ORDER')
492: AND fulfillment_base IS NOT NULL
493: AND reference_line_id = p_line_rec.line_id ;