eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OSM.AS_OSI_LEADS_ALL

Object Details

Object Name:	AS_OSI_LEADS_ALL
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_OSI_LEADS_ALL
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

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

Query Text

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;

Dependencies

[top of page]

OSM.AS_OSI_LEADS_ALL does not reference any database object

OSM.AS_OSI_LEADS_ALL is referenced by following:

OSM: AS_OSI_LEADS_ALL#