APPS.PO_POXRQSDD_XMLP_PKG dependencies on OE_ORDER_LINES_ALL

Line 134: if (P_OE_STATUS = 'I') then return(', oe_order_lines_all oel

130:
131: function C_fromFormula return VARCHAR2 is
132: begin
133:
134: if (P_OE_STATUS = 'I') then return(', oe_order_lines_all oel
135: , oe_order_headers_all oeh') ;
136: end if;
137:
138: RETURN NULL; end;

Line 162: from oe_order_lines_all oel,

158: (nvl(unit_price,0) * nvl(Quantity_delivered,0)) Cost_Variance
159: into C_Quantity_Shipped,
160: C_Quantity_Variance,
161: C_Cost_Variance
162: from oe_order_lines_all oel,
163: oe_order_headers_all oeh
164: where oel.orig_sys_line_ref = to_char(Line)
165: AND oeh.orig_sys_document_ref = Req_number
166: AND oeh.order_source_id = p_Order_Source_id

Line 183: from oe_order_lines_all oel,

179: sum_shipped_quantity number;
180: BEGIN
181: select sum(oel.shipped_quantity)
182: into sum_shipped_quantity
183: from oe_order_lines_all oel,
184: oe_order_headers_all oeh
185: where oel.orig_sys_line_ref = orig_line_num
186: AND oeh.orig_sys_document_ref = orig_header_num
187: AND oeh.order_source_id = psp_order_source_id