DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKI_SRM_005_V

Object Details
Object Name: OKI_SRM_005_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID


View that gives summarized information for service lines . It contains only DAY level information.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SLE_ID NUMBER

Internal contract line identifier for the original service line
CHR_ID NUMBER
Yes Internal idenitifer for the original contract
CONTRACT_NUMBER VARCHAR2 (120) Yes Contract number
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
Contract number modifier
COMPLETE_K_NUMBER VARCHAR2 (241)
Complete Contract Number
LINE_NUMBER VARCHAR2 (300)
Line Number of Service Line
STS_CODE VARCHAR2 (30)
Status of the original contract line
TRN_CODE VARCHAR2 (30)
Termination code of the original contract
RENEWAL_TYPE_CODE VARCHAR2 (30)
Identifier for Renewal Type
DATE_CANCELLED DATE

Date the original contract was cancelled
START_DATE DATE

Start date of the contract line for the original contract
END_DATE DATE

End date of the contract line for the original contract
DATE_TERMINATED DATE

Date the contract line was terminated
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
CURR_CODE VARCHAR2 (15)
Transactional Currency Code
CURR_CODE_F VARCHAR2 (15)
Functional Currency Code
CURR_CODE_G VARCHAR2 (15)
Global Currency Code
CURR_CODE_SG VARCHAR2 (15)
Secondary Global Currency Code
CURR_CODE_A VARCHAR2 (15)
Annualized Currency code
ITEM_CATEGORY_ID NUMBER

Internal identifier for Service Item Category
ITEM_ID NUMBER

Internal Identifier for Service Item
INV_ORG_ID NUMBER

Inventory organization ID
AUTHORING_ORG_ID NUMBER
Yes Operating unit to which the contract belongs
TRX_FUNC_CURR_RATE NUMBER

Conversion rate from transactional currency to functional currency
FUNC_GLOBAL_CURR_RATE NUMBER

Conversion rate from functional currency to global currency
FUNC_SGLOBAL_CURR_RATE NUMBER

Conversion rate from functional currency to secondary global currency
TERM_CANCEL_SOURCE VARCHAR2 (30)
Term Cancel Source
UBT_AMT NUMBER

Unbilled Terminated Amount
UBT_AMT_F NUMBER

Unbilled Terminated amount in functional currency
UBT_AMT_G NUMBER

Unbilled terminated amount in global currency
UBT_AMT_SG NUMBER

Unbilled terminated amount in secondary global currency
UBT_AMT_A NUMBER

Annualized Unbilled terminated amount on original side
SUPP_CREDIT NUMBER

Suppressed credit for terminated contracts
SUPP_CREDIT_F NUMBER

Suppressed credit for terminated contracts, functional currency
SUPP_CREDIT_G NUMBER

Suppressed credit for terminated contracts, global currency
SUPP_CREDIT_SG NUMBER

Suppressed credit for terminated contracts, secondary global currency
SUPP_CREDIT_A NUMBER

Annualized Suppressed credit on original side for terminated contracts in transactional currency
CREDIT_AMT NUMBER

Credit Amount for terminated Contracts
CREDIT_AMT_F NUMBER

Credit Amount for terminated Contracts, functional currency
CREDIT_AMT_G NUMBER

Credit Amount for terminated Contracts, global currency
CREDIT_AMT_SG NUMBER

Credit Amount for terminated Contracts, secondary global currency
CREDIT_AMT_A NUMBER

Annualized credit amout for terminated contracts original side
OVERRIDE_AMT NUMBER

Override amount for terminated contracts
OVERRIDE_AMT_F NUMBER

Override Amt for terminated contracts in functional currency
OVERRIDE_AMT_G NUMBER

Override Amt for terminated contracts in global currency
OVERRIDE_AMT_SG NUMBER

Override Amt for terminated contracts in secondary global currency
OVERRIDE_AMT_A NUMBER

Annualized Override amount on original side for terminated contracts
PRICE_NEGO NUMBER

Value of the original covered line in transactional currency
PRICE_NEGO_F NUMBER

Value of the original covered line in functional currency
PRICE_NEGO_G NUMBER

Value of the original covered line in global currency
PRICE_NEGO_SG NUMBER

Value of the original covered line in secondary global currency
PRICE_NEGO_A NUMBER

Annualized Value of the original covered line
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
,      DATE_CANCELLED
,      START_DATE
,      END_DATE
,      DATE_TERMINATED
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CURR_CODE
,      CURR_CODE_F
,      CURR_CODE_G
,      CURR_CODE_SG
,      CURR_CODE_A
,      ITEM_CATEGORY_ID
,      ITEM_ID
,      INV_ORG_ID
,      AUTHORING_ORG_ID
,      TRX_FUNC_CURR_RATE
,      FUNC_GLOBAL_CURR_RATE
,      FUNC_SGLOBAL_CURR_RATE
,      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_G
,      PRICE_NEGO_SG
,      PRICE_NEGO_A
FROM APPS.OKI_SRM_005_V;

Dependencies

[top of page]

APPS.OKI_SRM_005_V references the following:

SchemaAPPS
PL/SQL PackageBIS_COMMON_PARAMETERS - show dependent code
PL/SQL PackageOKC_UTIL - show dependent code
TableOKI_SRM_005_MV
SchemaPUBLIC
SynonymDUAL
APPS.OKI_SRM_005_V is referenced by following:

SchemaAPPS
ViewOKI_SBILLHIST_DTL_V
ViewOKI_SCREDIT_DTL_V