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

Object Details

Object Name:	OKI_SRM_006_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View that gives summarized information on Contract headers.This view will include Zero dollar amount contracts and Intermediate Cancellations, unlike the DBI summary table that excludes these type of contracts.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
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
CUSTOMER_PARTY_ID	NUMBER		Yes	Customer party ID
SALESREP_ID	NUMBER			The internal identifier for the contract salesperson for the original contract
AUTHORING_ORG_ID	NUMBER		Yes	Operating unit to which the contract belongs
RESOURCE_GROUP_ID	NUMBER			Internal identifier for the resource group of the original contract
RESOURCE_ID	NUMBER			Internal identifier for the salesperson resource of the original contract
SCS_CODE	VARCHAR2	(30)		Contract Category Code
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
ORDER_NUMBER	NUMBER			Order Number
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)		Annuliazed Currency Code
WIN_PERCENT	NUMBER			Expected Booking Percentage
EXPECTED_CLOSE_DATE	DATE			The expected date by which the renewal would be signed
DATE_CANCELLED	DATE			The Date on which the contract is cancelled at Header
DATE_SIGNED	DATE			Date on which Contract is signed
START_DATE	DATE			Contract Header Start Date
END_DATE	DATE			Contract Header End Date
GRACE_END_DATE	DATE			Grace End Date
DATE_APPROVED	DATE			Date on which the contract is approved
DATE_TERMINATED	DATE			The Date on which the contract is terminated at Header
CREATION_DATE	DATE			Date on which the contract is created
LAST_UPDATE_DATE	DATE			Date on which the contract is last updated
BILL_SITE_ID	NUMBER			Account site use identifier used to identify the billing address of the customer account
SHIP_SITE_ID	NUMBER			Account site use identifier used to identify the shipping address of the customer account
ACCT_RULE_ID	NUMBER			Revenue recognition rule identifier for the contract
SUBSEQUENT_RENEWAL_TYPE_CODE	VARCHAR2	(30)		Subsequent Renewal Type Code
NEGOTIATION_STATUS	VARCHAR2	(30)		Negotiation Status
REMINDER	VARCHAR2	(30)		Reminder
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			Contract Amount in transactional Currency
PRICE_NEGO_F	NUMBER			Contract Amount in Functional Currency
PRICE_NEGO_A	NUMBER			Annualized Contract Amount
PRICE_NEGO_G	NUMBER			Contract Amount in Global Currency
PRICE_NEGO_SG	NUMBER			Contract Amount in Secondary Currency

Query Text

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


SELECT CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_K_NUMBER
,      CUSTOMER_PARTY_ID
,      SALESREP_ID
,      AUTHORING_ORG_ID
,      RESOURCE_GROUP_ID
,      RESOURCE_ID
,      SCS_CODE
,      STS_CODE
,      TRN_CODE
,      RENEWAL_TYPE_CODE
,      ORDER_NUMBER
,      CURR_CODE
,      CURR_CODE_F
,      CURR_CODE_G
,      CURR_CODE_SG
,      CURR_CODE_A
,      WIN_PERCENT
,      EXPECTED_CLOSE_DATE
,      DATE_CANCELLED
,      DATE_SIGNED
,      START_DATE
,      END_DATE
,      GRACE_END_DATE
,      DATE_APPROVED
,      DATE_TERMINATED
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      BILL_SITE_ID
,      SHIP_SITE_ID
,      ACCT_RULE_ID
,      SUBSEQUENT_RENEWAL_TYPE_CODE
,      NEGOTIATION_STATUS
,      REMINDER
,      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
FROM APPS.OKI_SRM_006_V;

Dependencies

[top of page]

APPS.OKI_SRM_006_V references the following:

APPS: BIS_COMMON_PARAMETERS - show dependent code; OKC_UTIL - show dependent code; OKI_SRM_006_MV
PUBLIC: DUAL

APPS.OKI_SRM_006_V is referenced by following:

APPS: OKI_HCREDIT_DTL_V; OKI_HPARTY_DTL_V; OKI_HSTATUS_DTL_V; OKI_RESGRP_DTL_V