DBA Data[Home] [Help]

APPS.WSH_DETAILS_VALIDATIONS dependencies on OE_ORDER_LINES_ALL

Line 201: oe_order_lines_all ol

197: SELECT nvl(destination_type_code,'@'),source_organization_id,
198: destination_organization_id
199: INTO l_Dest_Type,l_From_Org,l_To_Org
200: FROM po_requisition_lines_all pl,
201: oe_order_lines_all ol
202: WHERE pl.line_num = to_number(ol.orig_sys_line_ref)
203: AND pl.requisition_header_id = ol.source_document_id
204: AND pl.requisition_line_id = ol.source_document_line_id
205: AND ol.line_id = p_source_line_id;

Line 1728: FROM oe_order_lines_all

1724: x_item_id) quantity ,
1725: order_quantity_uom,
1726: ordered_quantity2,
1727: ordered_quantity_uom2
1728: FROM oe_order_lines_all
1729: WHERE line_id = x_source_line_id;
1730:
1731:
1732: l_found_flag BOOLEAN;