60: FROM
61: AS_OSI_CONTR_NAMES_BASE contractNames,
62: AS_OSI_CONTR_VHCL_BASE contractVehicles,
63: AS_OSI_LEADS_ALL contractLeads
64: ,AS_OSI_LOOKUP poFrom
65: ,AS_OSI_LOOKUP contrType
66: ,as_osi_cons_ccs_base consCcs
67: WHERE contractNames.CNAME_ID(+)= contractLeads.CNAME_ID
68: AND contractVehicles.CVEHICLE(+) = contractLeads.CVEHICLE
61: AS_OSI_CONTR_NAMES_BASE contractNames,
62: AS_OSI_CONTR_VHCL_BASE contractVehicles,
63: AS_OSI_LEADS_ALL contractLeads
64: ,AS_OSI_LOOKUP poFrom
65: ,AS_OSI_LOOKUP contrType
66: ,as_osi_cons_ccs_base consCcs
67: WHERE contractNames.CNAME_ID(+)= contractLeads.CNAME_ID
68: AND contractVehicles.CVEHICLE(+) = contractLeads.CVEHICLE
69: AND poFrom.lkp_type(+)='PO_FROM'