DBA Data[Home] [Help]

APPS.WSH_SC_DEL_LINES_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 139: FROM po_requisition_lines_all pl,po_requisition_headers_all ph,

135: Elsif (X_Order_Category = 'P') then
136: SELECT nvl(destination_type_code,'@'),source_organization_id,
137: destination_organization_id
138: INTO X_Dest_Type,X_From_Org,X_To_Org
139: FROM po_requisition_lines_all pl,po_requisition_headers_all ph,
140: po_req_distributions_all pd,so_lines_all sol,so_headers_all soh,
141: so_picking_lines_all pkl,so_picking_headers_all pkh
142: WHERE pl.line_num = to_number(sol.original_system_line_reference)
143: AND pl.requisition_header_id = ph.requisition_header_id