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_DENORM#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
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

Query Text

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#;

Dependencies

[top of page]

OSM.AS_OSI_LEADS_DENORM# references the following:

OSM: AS_OSI_LEADS_DENORM

OSM.AS_OSI_LEADS_DENORM# is referenced by following:

APPS: AS_OSI_LEADS_DENORM