[Home] [Help] [Dependency Information]
Object Name: | AS_OSI_LEADS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_OSI_LEADS_ALL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OSI_LEAD_ID | NUMBER | Yes | ||
LEAD_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
CVEHICLE | NUMBER | |||
CNAME_ID | NUMBER | |||
CONTR_DRAFTING_REQ | VARCHAR2 | (30) | ||
PRIORITY | VARCHAR2 | (30) | ||
SENIOR_CONTR_PERSON_ID | NUMBER | |||
CONTR_SPEC_PERSON_ID | NUMBER | |||
BOM_PERSON_ID | NUMBER | |||
LEGAL_PERSON_ID | NUMBER | |||
HIGHEST_APVL | VARCHAR2 | (30) | ||
CURRENT_APVL_STATUS | VARCHAR2 | (30) | ||
SUPPORT_APVL | VARCHAR2 | (30) | ||
INTERNATIONAL_APVL | VARCHAR2 | (30) | ||
CREDIT_APVL | VARCHAR2 | (30) | ||
FIN_ESCROW_REQ | VARCHAR2 | (30) | ||
FIN_ESCROW_STATUS | VARCHAR2 | (30) | ||
CSI_ROLLIN | VARCHAR2 | (30) | ||
LICENCE_CREDIT_VER | VARCHAR2 | (30) | ||
SUPPORT_CREDIT_VER | VARCHAR2 | (30) | ||
MD_DEAL_SUMMARY | VARCHAR2 | (30) | ||
PROD_AVAIL_VER | VARCHAR2 | (30) | ||
SHIP_LOCATION | VARCHAR2 | (30) | ||
TAX_EXEMPT_CERT | VARCHAR2 | (30) | ||
NL_REV_ALLOC_REQ | VARCHAR2 | (30) | ||
SENIOR_CONTR_NOTES | VARCHAR2 | (4000) | ||
LEGAL_NOTES | VARCHAR2 | (4000) | ||
BOM_NOTES | VARCHAR2 | (4000) | ||
CONTR_NOTES | VARCHAR2 | (4000) | ||
PO_FROM | VARCHAR2 | (30) | ||
CONTR_TYPE | VARCHAR2 | (30) | ||
CONSULTING_CC | VARCHAR2 | (30) | ||
CONTR_STATUS | VARCHAR2 | (30) | ||
RTS_ID | NUMBER | |||
EXTRA_DOCS | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | Subscriber id, for CRM Online Services use |
Cut, paste (and edit) the following text to query this object:
SELECT OSI_LEAD_ID
, LEAD_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CVEHICLE
, CNAME_ID
, CONTR_DRAFTING_REQ
, PRIORITY
, SENIOR_CONTR_PERSON_ID
, CONTR_SPEC_PERSON_ID
, BOM_PERSON_ID
, LEGAL_PERSON_ID
, 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
, CONTR_TYPE
, CONSULTING_CC
, CONTR_STATUS
, RTS_ID
, EXTRA_DOCS
, SECURITY_GROUP_ID
FROM OSM.AS_OSI_LEADS_ALL;
OSM.AS_OSI_LEADS_ALL does not reference any database object
OSM.AS_OSI_LEADS_ALL is referenced by following:
|
|
|