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: OKS.OKS_K_HEADERS_B#

Object Details

Object Name:	OKS_K_HEADERS_B#
Object Type:	VIEW
Owner:	OKS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ID	NUMBER		Yes
CHR_ID	NUMBER		Yes
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
SECURITY_GROUP_ID	NUMBER
REQUEST_ID	NUMBER
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
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)
PERIOD_START	VARCHAR2	(30)
PERIOD_TYPE	VARCHAR2	(10)
PRICE_UOM	VARCHAR2	(10)
PERSON_PARTY_ID	NUMBER
TAX_CLASSIFICATION_CODE	VARCHAR2	(50)
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)
EXEMPT_REASON_CODE	VARCHAR2	(30)
APPROVAL_TYPE_USED	VARCHAR2	(30)
RENEWAL_COMMENT	VARCHAR2	(600)
CC_EMAIL_ADDRESS	VARCHAR2	(2000)

Query Text

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


SELECT 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
,      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
,      PERIOD_START
,      PERIOD_TYPE
,      PRICE_UOM
,      PERSON_PARTY_ID
,      TAX_CLASSIFICATION_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      APPROVAL_TYPE_USED
,      RENEWAL_COMMENT
,      CC_EMAIL_ADDRESS
FROM OKS.OKS_K_HEADERS_B#;

Dependencies

[top of page]

OKS.OKS_K_HEADERS_B# references the following:

OKS: OKS_K_HEADERS_B

OKS.OKS_K_HEADERS_B# is referenced by following:

APPS: OKS_K_HEADERS_B