VIEW: OSM.AS_OSI_LEADS_ALL#

Source

View Text - Preformatted

select OSI_LEAD_ID OSI_LEAD_ID, LEAD_ID LEAD_ID, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CVEHICLE CVEHICLE, CNAME_ID CNAME_ID, CONTR_DRAFTING_REQ CONTR_DRAFTING_REQ, PRIORITY PRIORITY, SENIOR_CONTR_PERSON_ID SENIOR_CONTR_PERSON_ID, CONTR_SPEC_PERSON_ID CONTR_SPEC_PERSON_ID, BOM_PERSON_ID BOM_PERSON_ID, LEGAL_PERSON_ID LEGAL_PERSON_ID, 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, CONTR_TYPE CONTR_TYPE, CONSULTING_CC CONSULTING_CC, CONTR_STATUS CONTR_STATUS, RTS_ID RTS_ID, EXTRA_DOCS EXTRA_DOCS, SECURITY_GROUP_ID SECURITY_GROUP_ID from "OSM"."AS_OSI_LEADS_ALL"

View Text - HTML Formatted

SELECT OSI_LEAD_ID OSI_LEAD_ID
, LEAD_ID LEAD_ID
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CVEHICLE CVEHICLE
, CNAME_ID CNAME_ID
, CONTR_DRAFTING_REQ CONTR_DRAFTING_REQ
, PRIORITY PRIORITY
, SENIOR_CONTR_PERSON_ID SENIOR_CONTR_PERSON_ID
, CONTR_SPEC_PERSON_ID CONTR_SPEC_PERSON_ID
, BOM_PERSON_ID BOM_PERSON_ID
, LEGAL_PERSON_ID LEGAL_PERSON_ID
, 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
, CONTR_TYPE CONTR_TYPE
, CONSULTING_CC CONSULTING_CC
, CONTR_STATUS CONTR_STATUS
, RTS_ID RTS_ID
, EXTRA_DOCS EXTRA_DOCS
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "OSM"."AS_OSI_LEADS_ALL"