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: APPS.OKI_SRM_005_MV

Object Details

Object Name:	OKI_SRM_005_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.OKI_SRM_005_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_OKI_SRM_005_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("SLE_ID") SYS_OP_MAP_NONNULL("CHR_ID") SYS_OP_MAP_NONNULL("CONTRACT_NUMBER") SYS_OP_MAP_NONNULL("CONTRACT_NUMBER_MODIFIER") SYS_OP_MAP_NONNULL("COMPLETE_K_NUMBER") SYS_OP_MAP_NONNULL("LINE_NUMBER") SYS_OP_MAP_NONNULL("STS_CODE") SYS_OP_MAP_NONNULL("TRN_CODE") SYS_OP_MAP_NONNULL("RENEWAL_TYPE_CODE") SYS_OP_MAP_NONNULL("CURR_CODE") SYS_OP_MAP_NONNULL("CURR_CODE_F") SYS_OP_MAP_NONNULL("ITEM_CATEGORY_ID") SYS_OP_MAP_NONNULL("ITEM_ID") SYS_OP_MAP_NONNULL("INV_ORG_ID") SYS_OP_MAP_NONNULL("SCS_CODE") SYS_OP_MAP_NONNULL("AUTHORING_ORG_ID") SYS_OP_MAP_NONNULL("TRX_FUNC_CURR_RATE") SYS_OP_MAP_NONNULL("FUNC_GLOBAL_CURR_RATE") SYS_OP_MAP_NONNULL("FUNC_SGLOBAL_CURR_RATE") SYS_OP_MAP_NONNULL("DATE_CANCELLED") SYS_OP_MAP_NONNULL("START_DATE") SYS_OP_MAP_NONNULL("END_DATE") SYS_OP_MAP_NONNULL("DATE_TERMINATED") SYS_OP_MAP_NONNULL("CREATION_DATE") SYS_OP_MAP_NONNULL("LAST_UPDATE_DATE") SYS_OP_MAP_NONNULL("TERM_CANCEL_SOURCE")
OKI_SRM_005_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CHR_ID
OKI_SRM_005_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CONTRACT_NUMBER CONTRACT_NUMBER_MODIFIER
OKI_SRM_005_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INV_ORG_ID ITEM_ID
OKI_SRM_005_MV_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	START_DATE
OKI_SRM_005_MV_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	END_DATE
OKI_SRM_005_MV_U1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SLE_ID	NUMBER			Internal Identifier of Service Line
CHR_ID	NUMBER		Yes	Internal Identifier of Contract Header
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract number of Header
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract Number Modifier on the Header
COMPLETE_K_NUMBER	VARCHAR2	(241)		Concatenation of Contract number and modifier
LINE_NUMBER	VARCHAR2	(300)		Line Number of Service Line
STS_CODE	VARCHAR2	(30)		Status Code of Service Line
TRN_CODE	VARCHAR2	(30)		Termination Code of Service Line
RENEWAL_TYPE_CODE	VARCHAR2	(30)		Renewal Type Code of Service Line
CURR_CODE	VARCHAR2	(15)		Transactional Currency Code of Contract Header
CURR_CODE_F	VARCHAR2	(15)		Functional Currency Code of Contract Header
ITEM_CATEGORY_ID	NUMBER			Internal Category Identifier for this Service Item
ITEM_ID	NUMBER			Internal Item Identifier of Service Item
INV_ORG_ID	NUMBER			Inventory Organization identifier of Service Item
SCS_CODE	VARCHAR2	(30)		Category Code of Contract
AUTHORING_ORG_ID	NUMBER		Yes	Operating Unit Identifier of Contract
TRX_FUNC_CURR_RATE	NUMBER			Conversion Rate From Transactional to Functional Currency
FUNC_GLOBAL_CURR_RATE	NUMBER			Conversion Rate from Functional to Primary Global Currency
FUNC_SGLOBAL_CURR_RATE	NUMBER			Conversion Rate from Functional to Secondary Global Currency
DATE_CANCELLED	DATE			Cancelled Date of Service Line
START_DATE	DATE			Start Date of Service Line
END_DATE	DATE			End Date of Service Line
DATE_TERMINATED	DATE			Termination Date of Service Line
CREATION_DATE	DATE			Creation Date of Service Line
LAST_UPDATE_DATE	DATE			Last Update Date of Service Line
TERM_CANCEL_SOURCE	VARCHAR2	(30)		Termination Source of Service Line
UBT_AMT	NUMBER			Unbilled Amount in Transactional currency
UBT_AMT_F	NUMBER			Unbilled Amount in Functional currency
UBT_AMT_G	NUMBER			Unbilled Amount in Primary Global currency
UBT_AMT_SG	NUMBER			Unbilled Amount in Secondary Global currency
UBT_AMT_A	NUMBER			Annualized Unbilled Amount
SUPP_CREDIT	NUMBER			Suppressed Amount in Transactional currency
SUPP_CREDIT_F	NUMBER			Suppressed Amount in Functional currency
SUPP_CREDIT_G	NUMBER			Suppressed Amount in Primary Global currency
SUPP_CREDIT_SG	NUMBER			Suppressed Amount in Secondary Global currency
SUPP_CREDIT_A	NUMBER			Annualized Suppressed Amount
CREDIT_AMT	NUMBER			Credit Amount in Transactional currency
CREDIT_AMT_F	NUMBER			Credit Amount in Functional currency
CREDIT_AMT_G	NUMBER			Credit Amount in Primary Global currency
CREDIT_AMT_SG	NUMBER			Credit Amount in Secondary Global currency
CREDIT_AMT_A	NUMBER			Annualized Credit Amount
OVERRIDE_AMT	NUMBER			Overridden Amount in Transactional currency
OVERRIDE_AMT_F	NUMBER			Overridden Amount in Functional currency
OVERRIDE_AMT_G	NUMBER			Overridden Amount in Primary Global currency
OVERRIDE_AMT_SG	NUMBER			Overridden Amount in Secondary Global currency
OVERRIDE_AMT_A	NUMBER			Annualized Overridden Amount
PRICE_NEGO	NUMBER			Service line Amount in Transactional currency
PRICE_NEGO_F	NUMBER			Service line Amount in Functional currency
PRICE_NEGO_A	NUMBER			Service line Amount in Primary Global currency
PRICE_NEGO_G	NUMBER			Service line Amount in Secondary Global currency
PRICE_NEGO_SG	NUMBER			Annualized Service line Amount
C_UBT_AMT	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_UBT_AMT_F	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_UBT_AMT_G	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_UBT_AMT_SG	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_UBT_AMT_A	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT_F	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT_G	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT_SG	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_SUPP_CREDIT_A	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT_F	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT_G	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT_SG	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_CREDIT_AMT_A	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT_F	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT_G	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT_SG	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_OVERRIDE_AMT_A	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO_F	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO_A	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO_G	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_PRICE_NEGO_SG	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable
C_TOTAL	NUMBER			Count Columns required to make this Materialized View as Fast Refreshable

Query Text

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


SELECT SLE_ID
,      CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_K_NUMBER
,      LINE_NUMBER
,      STS_CODE
,      TRN_CODE
,      RENEWAL_TYPE_CODE
,      CURR_CODE
,      CURR_CODE_F
,      ITEM_CATEGORY_ID
,      ITEM_ID
,      INV_ORG_ID
,      SCS_CODE
,      AUTHORING_ORG_ID
,      TRX_FUNC_CURR_RATE
,      FUNC_GLOBAL_CURR_RATE
,      FUNC_SGLOBAL_CURR_RATE
,      DATE_CANCELLED
,      START_DATE
,      END_DATE
,      DATE_TERMINATED
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      TERM_CANCEL_SOURCE
,      UBT_AMT
,      UBT_AMT_F
,      UBT_AMT_G
,      UBT_AMT_SG
,      UBT_AMT_A
,      SUPP_CREDIT
,      SUPP_CREDIT_F
,      SUPP_CREDIT_G
,      SUPP_CREDIT_SG
,      SUPP_CREDIT_A
,      CREDIT_AMT
,      CREDIT_AMT_F
,      CREDIT_AMT_G
,      CREDIT_AMT_SG
,      CREDIT_AMT_A
,      OVERRIDE_AMT
,      OVERRIDE_AMT_F
,      OVERRIDE_AMT_G
,      OVERRIDE_AMT_SG
,      OVERRIDE_AMT_A
,      PRICE_NEGO
,      PRICE_NEGO_F
,      PRICE_NEGO_A
,      PRICE_NEGO_G
,      PRICE_NEGO_SG
,      C_UBT_AMT
,      C_UBT_AMT_F
,      C_UBT_AMT_G
,      C_UBT_AMT_SG
,      C_UBT_AMT_A
,      C_SUPP_CREDIT
,      C_SUPP_CREDIT_F
,      C_SUPP_CREDIT_G
,      C_SUPP_CREDIT_SG
,      C_SUPP_CREDIT_A
,      C_CREDIT_AMT
,      C_CREDIT_AMT_F
,      C_CREDIT_AMT_G
,      C_CREDIT_AMT_SG
,      C_CREDIT_AMT_A
,      C_OVERRIDE_AMT
,      C_OVERRIDE_AMT_F
,      C_OVERRIDE_AMT_G
,      C_OVERRIDE_AMT_SG
,      C_OVERRIDE_AMT_A
,      C_PRICE_NEGO
,      C_PRICE_NEGO_F
,      C_PRICE_NEGO_A
,      C_PRICE_NEGO_G
,      C_PRICE_NEGO_SG
,      C_TOTAL
FROM APPS.OKI_SRM_005_MV;

Dependencies

[top of page]

APPS.OKI_SRM_005_MV does not reference any database object

APPS.OKI_SRM_005_MV is referenced by following:

APPS: OKI_SRM_005_MV; OKI_SRM_005_V