DBA Data[Home] [Help]

APPS.WSH_DETAILS_VALIDATIONS dependencies on PO_REQUISITION_LINES_ALL

Line 200: FROM po_requisition_lines_all pl,

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