DBA Data[Home] [Help]

APPS.PO_POXRQSDD_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 135: , oe_order_headers_all oeh') ;

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;
139:

Line 163: oe_order_headers_all oeh

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
167: AND oel.header_id = oeh.header_id

Line 184: oe_order_headers_all oeh

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
188: AND oel.header_id = oeh.header_id