[Home] [Help] [Dependency Information]
Object Name: | AS_OSI_LEADS_DENORM# |
---|---|
Object Type: | VIEW |
Owner: | OSM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
OSI_LEAD_ID | NUMBER | Yes | ||
LEAD_ID | NUMBER | Yes | ||
CONTRACT_NAME | VARCHAR2 | (150) | ||
CONTRACT_NAME_ID | NUMBER | |||
CONTRACT_VEHICLE | VARCHAR2 | (300) | ||
CONTRACT_VHCL_ID | NUMBER | |||
CONTRACT_TYPE | VARCHAR2 | (90) | ||
OVM_CODE | VARCHAR2 | (30) | ||
OVM_VALUE | VARCHAR2 | (90) | ||
BOM_PERSON_ID | NUMBER | |||
LEGAL_PERSON_ID | NUMBER | |||
SENIOR_CONTR_PERSON_ID | NUMBER | |||
CONT_SPEC_PERSON_ID | NUMBER | |||
COMBINED_OVM_VALUE | VARCHAR2 | (4000) | ||
CONTR_DRAFTING_REQ | VARCHAR2 | (90) | ||
PRIORITY | VARCHAR2 | (90) | ||
HIGHEST_APVL | VARCHAR2 | (90) | ||
CURRENT_APVL_STATUS | VARCHAR2 | (90) | ||
SUPPORT_APVL | VARCHAR2 | (90) | ||
INTERNATIONAL_APVL | VARCHAR2 | (90) | ||
CREDIT_APVL | VARCHAR2 | (90) | ||
FIN_ESCROW_REQ | VARCHAR2 | (90) | ||
FIN_ESCROW_STATUS | VARCHAR2 | (90) | ||
CSI_ROLLIN | VARCHAR2 | (90) | ||
LICENCE_CREDIT_VER | VARCHAR2 | (90) | ||
SUPPORT_CREDIT_VER | VARCHAR2 | (90) | ||
MD_DEAL_SUMMARY | VARCHAR2 | (90) | ||
PROD_AVAIL_VER | VARCHAR2 | (90) | ||
SHIP_LOCATION | VARCHAR2 | (90) | ||
TAX_EXEMPT_CERT | VARCHAR2 | (90) | ||
NL_REV_ALLOC_REQ | VARCHAR2 | (90) | ||
SENIOR_CONTR_NOTES | VARCHAR2 | (4000) | ||
LEGAL_NOTES | VARCHAR2 | (4000) | ||
BOM_NOTES | VARCHAR2 | (4000) | ||
CONTR_NOTES | VARCHAR2 | (4000) | ||
PO_FROM | VARCHAR2 | (90) | ||
PO_FROM_DISP | VARCHAR2 | (90) | ||
CONTRACT_TYPE_DISP | VARCHAR2 | (90) | ||
CONSULTING_CC | VARCHAR2 | (90) | ||
CONSULTING_CC_DISP | VARCHAR2 | (90) | ||
CONTR_STATUS | VARCHAR2 | (90) | ||
RTS_ID | NUMBER | |||
EXTRA_DOCS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OSI_LEAD_ID
, LEAD_ID
, CONTRACT_NAME
, CONTRACT_NAME_ID
, CONTRACT_VEHICLE
, CONTRACT_VHCL_ID
, CONTRACT_TYPE
, OVM_CODE
, OVM_VALUE
, BOM_PERSON_ID
, LEGAL_PERSON_ID
, SENIOR_CONTR_PERSON_ID
, CONT_SPEC_PERSON_ID
, COMBINED_OVM_VALUE
, CONTR_DRAFTING_REQ
, PRIORITY
, HIGHEST_APVL
, CURRENT_APVL_STATUS
, SUPPORT_APVL
, INTERNATIONAL_APVL
, CREDIT_APVL
, FIN_ESCROW_REQ
, FIN_ESCROW_STATUS
, CSI_ROLLIN
, LICENCE_CREDIT_VER
, SUPPORT_CREDIT_VER
, MD_DEAL_SUMMARY
, PROD_AVAIL_VER
, SHIP_LOCATION
, TAX_EXEMPT_CERT
, NL_REV_ALLOC_REQ
, SENIOR_CONTR_NOTES
, LEGAL_NOTES
, BOM_NOTES
, CONTR_NOTES
, PO_FROM
, PO_FROM_DISP
, CONTRACT_TYPE_DISP
, CONSULTING_CC
, CONSULTING_CC_DISP
, CONTR_STATUS
, RTS_ID
, EXTRA_DOCS
FROM OSM.AS_OSI_LEADS_DENORM#;
|
|
|