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_DENORM

Object Details

Object Name:	AS_OSI_LEADS_DENORM
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_OSI_LEADS_DENORM
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:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_OSI_LEADS_DENORM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEAD_ID
AS_OSI_LEADS_DENORM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OSI_LEAD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	who column
CREATION_DATE	DATE		Yes	time column
CREATED_BY	NUMBER		Yes	who column
LAST_UPDATE_LOGIN	NUMBER		Yes	time column
OSI_LEAD_ID	NUMBER		Yes	OSI Lead id
LEAD_ID	NUMBER		Yes	lead_id
CONTRACT_NAME	VARCHAR2	(150)		Contract Name
CONTRACT_NAME_ID	NUMBER			Contract Name ID
CONTRACT_VEHICLE	VARCHAR2	(300)		Contract Vehicle
CONTRACT_VHCL_ID	NUMBER			Contract Vehicle ID
CONTRACT_TYPE	VARCHAR2	(90)		Contract Type
OVM_CODE	VARCHAR2	(30)		OVM Code
OVM_VALUE	VARCHAR2	(90)		OVM Value
BOM_PERSON_ID	NUMBER			BOM Person ID
LEGAL_PERSON_ID	NUMBER			Legal Person ID
SENIOR_CONTR_PERSON_ID	NUMBER			Sr. person contract ID
CONT_SPEC_PERSON_ID	NUMBER			Contract spec person id
COMBINED_OVM_VALUE	VARCHAR2	(4000)		Combined OVM Value
CONTR_DRAFTING_REQ	VARCHAR2	(90)		Contract Drafting Request
PRIORITY	VARCHAR2	(90)		Priority
HIGHEST_APVL	VARCHAR2	(90)		Highest Approval
CURRENT_APVL_STATUS	VARCHAR2	(90)		Current Approval status
SUPPORT_APVL	VARCHAR2	(90)		Support Approval
INTERNATIONAL_APVL	VARCHAR2	(90)		International Approval
CREDIT_APVL	VARCHAR2	(90)		Credit Approval
FIN_ESCROW_REQ	VARCHAR2	(90)		Financial Escrow Request
FIN_ESCROW_STATUS	VARCHAR2	(90)		Financial Escrow Status
CSI_ROLLIN	VARCHAR2	(90)		CSI rolling
LICENCE_CREDIT_VER	VARCHAR2	(90)		Licence Credit Verification
SUPPORT_CREDIT_VER	VARCHAR2	(90)		Support Credit Verification
MD_DEAL_SUMMARY	VARCHAR2	(90)		MD Deal Summary
PROD_AVAIL_VER	VARCHAR2	(90)		Product Avail. Version
SHIP_LOCATION	VARCHAR2	(90)		Shipping Location
TAX_EXEMPT_CERT	VARCHAR2	(90)		Tax Exempt certification
NL_REV_ALLOC_REQ	VARCHAR2	(90)		National Rev. Allocation Request
SENIOR_CONTR_NOTES	VARCHAR2	(4000)		Sr. Contract Notes
LEGAL_NOTES	VARCHAR2	(4000)		Legal Notes
BOM_NOTES	VARCHAR2	(4000)		BOM Notes
CONTR_NOTES	VARCHAR2	(4000)		Contract Notes
PO_FROM	VARCHAR2	(90)		PO Form
PO_FROM_DISP	VARCHAR2	(90)		PO Form Displacement
CONTRACT_TYPE_DISP	VARCHAR2	(90)		Contract type Displacement
CONSULTING_CC	VARCHAR2	(90)		Consulting CC
CONSULTING_CC_DISP	VARCHAR2	(90)		Consulting CC Disp.
CONTR_STATUS	VARCHAR2	(90)		Contact Status
RTS_ID	NUMBER			RTS ID
EXTRA_DOCS	NUMBER			Extra Docs

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 does not reference any database object

OSM.AS_OSI_LEADS_DENORM is referenced by following:

OSM: AS_OSI_LEADS_DENORM#