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: OKI.OKI_DBI_CHR_STAGE_INC

Object Details

Object Name:	OKI_DBI_CHR_STAGE_INC
Object Type:	TABLE
Owner:	OKI
Subobject Name:
Status:	VALID

Staging table for OKI_DBI_CHR_INC. Used only in Initial Load.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKI_DBI_CHR_STAGE_INC_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Internal contract header id
CURRENCY_CODE	VARCHAR2	(15)		Transactional Currency Code for the Contract
DATE_APPROVED	DATE			Approved Date of contract
CREATION_DATE	DATE			Creation Date of contract
CONVERSION_RATE_DATE	DATE			Conversion Date of Contract
CONVERSION_TYPE	VARCHAR2	(30)		Conversion Type for Contract
CONVERSION_RATE	NUMBER			Conversion rate identified
END_DATE	DATE			End date of Contract
AUTHORING_ORG_ID	NUMBER			Authoring Organization Internal identifier
APPLICATION_ID	NUMBER			Contract application ID
CONTRACT_NUMBER	VARCHAR2	(120)		Contract number
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract number modifier
BUY_OR_SELL	VARCHAR2	(3)		Buy or sell intent indicator
SCS_CODE	VARCHAR2	(30)		Contract Category Code
TRN_CODE	VARCHAR2	(30)		Termination code of the original contract
DATE_SIGNED	DATE			Date the original contract was signed
START_DATE	DATE			Start date of the contract line for the original contract
DATE_TERMINATED	DATE			Date the contract line was terminated
RENEWAL_TYPE_CODE	VARCHAR2	(30)		Identifier for Renewal Type
STS_CODE	VARCHAR2	(30)		Status of the original contract line
DATETIME_CANCELLED	DATE			Cancelled date of contract
LAST_UPDATE_DATE	DATE			Standard Who column
BILL_TO_SITE_USE_ID	NUMBER			Account site use identifier used to identify the billing address of the customer account
SHIP_TO_SITE_USE_ID	NUMBER			Account site use identifier used to identify the shipping address of the customer account
INV_ORGANIZATION_ID	NUMBER			Inventory organization ID
SUBSEQUENT_RENEWAL_TYPE_CODE	VARCHAR2	(30)		Subsequent Renewal Type Code
AGREEMENT_TYPE_CODE	VARCHAR2	(80)		Added Agreement_type_code as part of ER 6062516.
AGREEMENT_NAME	VARCHAR2	(240)		Added Agreement_Name as part of ER 6062516.
HDR_TERM_CANCEL_SOURCE	VARCHAR2	(30)		Hdr Term Cancel Source

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      CURRENCY_CODE
,      DATE_APPROVED
,      CREATION_DATE
,      CONVERSION_RATE_DATE
,      CONVERSION_TYPE
,      CONVERSION_RATE
,      END_DATE
,      AUTHORING_ORG_ID
,      APPLICATION_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      BUY_OR_SELL
,      SCS_CODE
,      TRN_CODE
,      DATE_SIGNED
,      START_DATE
,      DATE_TERMINATED
,      RENEWAL_TYPE_CODE
,      STS_CODE
,      DATETIME_CANCELLED
,      LAST_UPDATE_DATE
,      BILL_TO_SITE_USE_ID
,      SHIP_TO_SITE_USE_ID
,      INV_ORGANIZATION_ID
,      SUBSEQUENT_RENEWAL_TYPE_CODE
,      AGREEMENT_TYPE_CODE
,      AGREEMENT_NAME
,      HDR_TERM_CANCEL_SOURCE
FROM OKI.OKI_DBI_CHR_STAGE_INC;

Dependencies

[top of page]

OKI.OKI_DBI_CHR_STAGE_INC does not reference any database object

OKI.OKI_DBI_CHR_STAGE_INC is referenced by following:

APPS: OKI_DBI_CHR_STAGE_INC