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

VIEW: APPS.OKS_K_HEADERS_V

Object Details
Object Name: OKS_K_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKS.OKS_K_HEADERS_V
Subobject Name:
Status: VALID


Service Contracts Header Attributes


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ID NUMBER
Yes
CHR_ID NUMBER
Yes Unique Identifier for Contract Header
ACCT_RULE_ID NUMBER

PAYMENT_TYPE VARCHAR2 (30)
CC_NO VARCHAR2 (80)
CC_EXPIRY_DATE DATE

CC_BANK_ACCT_ID NUMBER

CC_AUTH_CODE VARCHAR2 (150)
COMMITMENT_ID NUMBER

GRACE_DURATION NUMBER

GRACE_PERIOD VARCHAR2 (30)
EST_REV_PERCENT NUMBER

EST_REV_DATE DATE

TAX_AMOUNT NUMBER

TAX_STATUS VARCHAR2 (30)
TAX_CODE NUMBER

TAX_EXEMPTION_ID NUMBER

BILLING_PROFILE_ID NUMBER

RENEWAL_STATUS VARCHAR2 (30)
ELECTRONIC_RENEWAL_FLAG VARCHAR2 (1)
QUOTE_TO_CONTACT_ID NUMBER

QUOTE_TO_SITE_ID NUMBER

QUOTE_TO_EMAIL_ID NUMBER

QUOTE_TO_PHONE_ID NUMBER

QUOTE_TO_FAX_ID NUMBER

RENEWAL_PO_REQUIRED VARCHAR2 (1)
RENEWAL_PO_NUMBER VARCHAR2 (240)
RENEWAL_PRICE_LIST NUMBER

RENEWAL_PRICING_TYPE VARCHAR2 (30)
RENEWAL_MARKUP_PERCENT NUMBER

RENEWAL_GRACE_DURATION NUMBER

RENEWAL_GRACE_PERIOD VARCHAR2 (30)
RENEWAL_EST_REV_PERCENT NUMBER

RENEWAL_EST_REV_DURATION NUMBER

RENEWAL_EST_REV_PERIOD VARCHAR2 (30)
RENEWAL_PRICE_LIST_USED NUMBER

RENEWAL_TYPE_USED VARCHAR2 (30)
RENEWAL_NOTIFICATION_TO NUMBER

RENEWAL_PO_USED VARCHAR2 (1)
RENEWAL_PRICING_TYPE_USED VARCHAR2 (30)
RENEWAL_MARKUP_PERCENT_USED NUMBER

REV_EST_PERCENT_USED NUMBER

REV_EST_DURATION_USED NUMBER

REV_EST_PERIOD_USED VARCHAR2 (30)
BILLING_PROFILE_USED NUMBER

ERN_FLAG_USED_YN VARCHAR2 (1)
EVN_THRESHOLD_AMT NUMBER

EVN_THRESHOLD_CUR VARCHAR2 (30)
ERN_THRESHOLD_AMT NUMBER

ERN_THRESHOLD_CUR VARCHAR2 (30)
RENEWAL_GRACE_DURATION_USED NUMBER

RENEWAL_GRACE_PERIOD_USED VARCHAR2 (30)
INV_TRX_TYPE VARCHAR2 (30)
INV_PRINT_PROFILE VARCHAR2 (1)
AR_INTERFACE_YN VARCHAR2 (1)
HOLD_BILLING VARCHAR2 (1)
SUMMARY_TRX_YN VARCHAR2 (1)
SERVICE_PO_NUMBER VARCHAR2 (240)
SERVICE_PO_REQUIRED VARCHAR2 (1)
BILLING_SCHEDULE_TYPE VARCHAR2 (10)
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SECURITY_GROUP_ID NUMBER

Used to create a Virtual Private Database which was originally designed to be used by Hosting services. Now obsolete.
REQUEST_ID NUMBER

Unique Identifier of a concurrent request.
CREATED_BY NUMBER (15) Yes ID of the user whom created the record.
CREATION_DATE DATE
Yes Date the record was created.
LAST_UPDATED_BY NUMBER (15) Yes ID of the last user who updated the record.
LAST_UPDATE_DATE DATE
Yes Date the record was last updated.
LAST_UPDATE_LOGIN NUMBER (15)
OS ID of the user who last updated the record.
PERIOD_TYPE VARCHAR2 (10)
PERIOD_START VARCHAR2 (30)
PRICE_UOM VARCHAR2 (10)
FOLLOW_UP_ACTION VARCHAR2 (30)
FOLLOW_UP_DATE DATE

TRXN_EXTENSION_ID NUMBER

DATE_ACCEPTED DATE

ACCEPTED_BY NUMBER

RMNDR_SUPPRESS_FLAG VARCHAR2 (1)
RMNDR_SENT_FLAG VARCHAR2 (1)
QUOTE_SENT_FLAG VARCHAR2 (1)
PROCESS_REQUEST_ID NUMBER

WF_ITEM_KEY VARCHAR2 (240)
PERSON_PARTY_ID NUMBER

TAX_CLASSIFICATION_CODE VARCHAR2 (50)
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
EXEMPT_REASON_CODE VARCHAR2 (30)
APPROVAL_TYPE_USED VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      ID
,      CHR_ID
,      ACCT_RULE_ID
,      PAYMENT_TYPE
,      CC_NO
,      CC_EXPIRY_DATE
,      CC_BANK_ACCT_ID
,      CC_AUTH_CODE
,      COMMITMENT_ID
,      GRACE_DURATION
,      GRACE_PERIOD
,      EST_REV_PERCENT
,      EST_REV_DATE
,      TAX_AMOUNT
,      TAX_STATUS
,      TAX_CODE
,      TAX_EXEMPTION_ID
,      BILLING_PROFILE_ID
,      RENEWAL_STATUS
,      ELECTRONIC_RENEWAL_FLAG
,      QUOTE_TO_CONTACT_ID
,      QUOTE_TO_SITE_ID
,      QUOTE_TO_EMAIL_ID
,      QUOTE_TO_PHONE_ID
,      QUOTE_TO_FAX_ID
,      RENEWAL_PO_REQUIRED
,      RENEWAL_PO_NUMBER
,      RENEWAL_PRICE_LIST
,      RENEWAL_PRICING_TYPE
,      RENEWAL_MARKUP_PERCENT
,      RENEWAL_GRACE_DURATION
,      RENEWAL_GRACE_PERIOD
,      RENEWAL_EST_REV_PERCENT
,      RENEWAL_EST_REV_DURATION
,      RENEWAL_EST_REV_PERIOD
,      RENEWAL_PRICE_LIST_USED
,      RENEWAL_TYPE_USED
,      RENEWAL_NOTIFICATION_TO
,      RENEWAL_PO_USED
,      RENEWAL_PRICING_TYPE_USED
,      RENEWAL_MARKUP_PERCENT_USED
,      REV_EST_PERCENT_USED
,      REV_EST_DURATION_USED
,      REV_EST_PERIOD_USED
,      BILLING_PROFILE_USED
,      ERN_FLAG_USED_YN
,      EVN_THRESHOLD_AMT
,      EVN_THRESHOLD_CUR
,      ERN_THRESHOLD_AMT
,      ERN_THRESHOLD_CUR
,      RENEWAL_GRACE_DURATION_USED
,      RENEWAL_GRACE_PERIOD_USED
,      INV_TRX_TYPE
,      INV_PRINT_PROFILE
,      AR_INTERFACE_YN
,      HOLD_BILLING
,      SUMMARY_TRX_YN
,      SERVICE_PO_NUMBER
,      SERVICE_PO_REQUIRED
,      BILLING_SCHEDULE_TYPE
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERIOD_TYPE
,      PERIOD_START
,      PRICE_UOM
,      FOLLOW_UP_ACTION
,      FOLLOW_UP_DATE
,      TRXN_EXTENSION_ID
,      DATE_ACCEPTED
,      ACCEPTED_BY
,      RMNDR_SUPPRESS_FLAG
,      RMNDR_SENT_FLAG
,      QUOTE_SENT_FLAG
,      PROCESS_REQUEST_ID
,      WF_ITEM_KEY
,      PERSON_PARTY_ID
,      TAX_CLASSIFICATION_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      APPROVAL_TYPE_USED
FROM APPS.OKS_K_HEADERS_V;

Dependencies

[top of page]

APPS.OKS_K_HEADERS_V references the following:

SchemaAPPS
SynonymOKS_K_HEADERS_B
APPS.OKS_K_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyOKS_ATTR_DEFAULTS_PVT - show dependent code
Package BodyOKS_AUTH_UTIL_PVT - show dependent code
PL/SQL PackageOKS_CONTRACT_HDR_PUB - show dependent code
Package BodyOKS_KHR_PVT - show dependent code
PL/SQL PackageOKS_KHR_PVT - show dependent code
Package BodyOKS_MASSCHANGE_PVT - show dependent code
Package BodyOKS_OCINT_PUB - show dependent code