DBA Data[Home] [Help]

APPS.WSH_SC_DEL_LINES_PVT dependencies on SO_LINES_ALL

Line 140: po_req_distributions_all pd,so_lines_all sol,so_headers_all soh,

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
144: AND pd.requisition_line_id = pl.requisition_line_id