DBA Data[Home] [Help]

APPS.WSH_DETAILS_VALIDATIONS dependencies on OE_ORDER_LINES_ALL

Line 207: oe_order_lines_all ol

203: SELECT nvl(destination_type_code,'@'),source_organization_id,
204: destination_organization_id
205: INTO l_Dest_Type,l_From_Org,l_To_Org
206: FROM po_requisition_lines_all pl,
207: oe_order_lines_all ol
208: WHERE pl.line_num = to_number(ol.orig_sys_line_ref)
209: AND pl.requisition_header_id = ol.source_document_id
210: AND pl.requisition_line_id = ol.source_document_line_id
211: AND ol.line_id = p_source_line_id;

Line 1797: FROM oe_order_lines_all

1793: x_item_id) quantity ,
1794: order_quantity_uom,
1795: ordered_quantity2,
1796: ordered_quantity_uom2
1797: FROM oe_order_lines_all
1798: WHERE line_id = x_source_line_id;
1799:
1800:
1801: l_found_flag BOOLEAN;