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]

VIEW: OSM.AS_OSI_LEADS_ALL#

Object Details

Object Name:	AS_OSI_LEADS_ALL#
Object Type:	VIEW
Owner:	OSM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
OSI_LEAD_ID	NUMBER		Yes
LEAD_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
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

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# references the following:

OSM: AS_OSI_LEADS_ALL

OSM.AS_OSI_LEADS_ALL# is referenced by following:

APPS: AS_OSI_LEADS_ALL