VIEW: OSM.AS_OSI_LEADS_DENORM#

Source

View Text - Preformatted

select LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OSI_LEAD_ID OSI_LEAD_ID, LEAD_ID LEAD_ID, CONTRACT_NAME CONTRACT_NAME, CONTRACT_NAME_ID CONTRACT_NAME_ID, CONTRACT_VEHICLE CONTRACT_VEHICLE, CONTRACT_VHCL_ID CONTRACT_VHCL_ID, CONTRACT_TYPE CONTRACT_TYPE, OVM_CODE OVM_CODE, OVM_VALUE OVM_VALUE, BOM_PERSON_ID BOM_PERSON_ID, LEGAL_PERSON_ID LEGAL_PERSON_ID, SENIOR_CONTR_PERSON_ID SENIOR_CONTR_PERSON_ID, CONT_SPEC_PERSON_ID CONT_SPEC_PERSON_ID, COMBINED_OVM_VALUE COMBINED_OVM_VALUE, CONTR_DRAFTING_REQ CONTR_DRAFTING_REQ, PRIORITY PRIORITY, HIGHEST_APVL HIGHEST_APVL, CURRENT_APVL_STATUS CURRENT_APVL_STATUS, SUPPORT_APVL SUPPORT_APVL, INTERNATIONAL_APVL INTERNATIONAL_APVL, CREDIT_APVL CREDIT_APVL, FIN_ESCROW_REQ FIN_ESCROW_REQ, FIN_ESCROW_STATUS FIN_ESCROW_STATUS, CSI_ROLLIN CSI_ROLLIN, LICENCE_CREDIT_VER LICENCE_CREDIT_VER, SUPPORT_CREDIT_VER SUPPORT_CREDIT_VER, MD_DEAL_SUMMARY MD_DEAL_SUMMARY, PROD_AVAIL_VER PROD_AVAIL_VER, SHIP_LOCATION SHIP_LOCATION, TAX_EXEMPT_CERT TAX_EXEMPT_CERT, NL_REV_ALLOC_REQ NL_REV_ALLOC_REQ, SENIOR_CONTR_NOTES SENIOR_CONTR_NOTES, LEGAL_NOTES LEGAL_NOTES, BOM_NOTES BOM_NOTES, CONTR_NOTES CONTR_NOTES, PO_FROM PO_FROM, PO_FROM_DISP PO_FROM_DISP, CONTRACT_TYPE_DISP CONTRACT_TYPE_DISP, CONSULTING_CC CONSULTING_CC, CONSULTING_CC_DISP CONSULTING_CC_DISP, CONTR_STATUS CONTR_STATUS, RTS_ID RTS_ID, EXTRA_DOCS EXTRA_DOCS from "OSM"."AS_OSI_LEADS_DENORM"

View Text - HTML Formatted

SELECT LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OSI_LEAD_ID OSI_LEAD_ID
, LEAD_ID LEAD_ID
, CONTRACT_NAME CONTRACT_NAME
, CONTRACT_NAME_ID CONTRACT_NAME_ID
, CONTRACT_VEHICLE CONTRACT_VEHICLE
, CONTRACT_VHCL_ID CONTRACT_VHCL_ID
, CONTRACT_TYPE CONTRACT_TYPE
, OVM_CODE OVM_CODE
, OVM_VALUE OVM_VALUE
, BOM_PERSON_ID BOM_PERSON_ID
, LEGAL_PERSON_ID LEGAL_PERSON_ID
, SENIOR_CONTR_PERSON_ID SENIOR_CONTR_PERSON_ID
, CONT_SPEC_PERSON_ID CONT_SPEC_PERSON_ID
, COMBINED_OVM_VALUE COMBINED_OVM_VALUE
, CONTR_DRAFTING_REQ CONTR_DRAFTING_REQ
, PRIORITY PRIORITY
, HIGHEST_APVL HIGHEST_APVL
, CURRENT_APVL_STATUS CURRENT_APVL_STATUS
, SUPPORT_APVL SUPPORT_APVL
, INTERNATIONAL_APVL INTERNATIONAL_APVL
, CREDIT_APVL CREDIT_APVL
, FIN_ESCROW_REQ FIN_ESCROW_REQ
, FIN_ESCROW_STATUS FIN_ESCROW_STATUS
, CSI_ROLLIN CSI_ROLLIN
, LICENCE_CREDIT_VER LICENCE_CREDIT_VER
, SUPPORT_CREDIT_VER SUPPORT_CREDIT_VER
, MD_DEAL_SUMMARY MD_DEAL_SUMMARY
, PROD_AVAIL_VER PROD_AVAIL_VER
, SHIP_LOCATION SHIP_LOCATION
, TAX_EXEMPT_CERT TAX_EXEMPT_CERT
, NL_REV_ALLOC_REQ NL_REV_ALLOC_REQ
, SENIOR_CONTR_NOTES SENIOR_CONTR_NOTES
, LEGAL_NOTES LEGAL_NOTES
, BOM_NOTES BOM_NOTES
, CONTR_NOTES CONTR_NOTES
, PO_FROM PO_FROM
, PO_FROM_DISP PO_FROM_DISP
, CONTRACT_TYPE_DISP CONTRACT_TYPE_DISP
, CONSULTING_CC CONSULTING_CC
, CONSULTING_CC_DISP CONSULTING_CC_DISP
, CONTR_STATUS CONTR_STATUS
, RTS_ID RTS_ID
, EXTRA_DOCS EXTRA_DOCS
FROM "OSM"."AS_OSI_LEADS_DENORM"