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
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:
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);
269: END IF;
270:
271: SELECT fulfillment_base
272: INTO l_fulfillment_base
273: FROM oe_order_lines
274: WHERE line_id = p_line_rec.reference_line_id;
275:
276: RETURN l_fulfillment_base;
277: --------------------------------------------------------------
284: END IF;
285:
286: SELECT fulfillment_base
287: INTO l_fulfillment_base
288: FROM oe_order_lines
289: WHERE line_id = p_line_rec.split_from_line_id;
290:
291:
292: RETURN l_fulfillment_base;
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 ;