DBA Data[Home] [Help]

APPS.WSH_DETAILS_VALIDATIONS dependencies on PO_REQUISITION_LINES_ALL

Line 206: FROM po_requisition_lines_all pl,

202: elsif (p_source_document_type_id = 10) then
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