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

VIEW: APPS.OKS_AUTH_HEADERS_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SFWT_FLAG VARCHAR2 (3) Yes
CHR_ID_RESPONSE NUMBER

CHR_ID_AWARD NUMBER

CHR_ID_RENEWED NUMBER

INV_ORGANIZATION_ID NUMBER
Yes
STS_CODE VARCHAR2 (30) Yes
QCL_ID NUMBER

SCS_CODE VARCHAR2 (30) Yes
CONTRACT_NUMBER VARCHAR2 (120) Yes With CONTRACT_NUMBER_MODIFIER, used to uniquely identify a contract as a business entity.
CURRENCY_CODE VARCHAR2 (15)
Currency Code
CONTRACT_NUMBER_MODIFIER VARCHAR2 (120)
With CONTRACT_NUMBER, used to uniquely identify a contract as a business entity.
ARCHIVED_YN VARCHAR2 (3) Yes
DELETED_YN VARCHAR2 (3) Yes
CUST_PO_NUMBER_REQ_YN VARCHAR2 (3)
PRE_PAY_REQ_YN VARCHAR2 (3)
CUST_PO_NUMBER VARCHAR2 (150)
SHORT_DESCRIPTION VARCHAR2 (600)
COMMENTS VARCHAR2 (1995)
DESCRIPTION VARCHAR2 (1995)
DPAS_RATING VARCHAR2 (24)
COGNOMEN VARCHAR2 (300)
TEMPLATE_YN VARCHAR2 (3) Yes
TEMPLATE_USED VARCHAR2 (120)
DATE_APPROVED DATE

DATETIME_CANCELLED DATE

AUTO_RENEW_DAYS NUMBER (4)
DATE_ISSUED DATE

DATETIME_RESPONDED DATE

NON_RESPONSE_REASON VARCHAR2 (3)
NON_RESPONSE_EXPLAIN VARCHAR2 (1995)
RFP_TYPE VARCHAR2 (30)
CHR_TYPE VARCHAR2 (30) Yes
KEEP_ON_MAIL_LIST VARCHAR2 (3)
SET_ASIDE_REASON VARCHAR2 (3)
SET_ASIDE_PERCENT NUMBER (5)
RESPONSE_COPIES_REQ NUMBER (2)
DATE_CLOSE_PROJECTED DATE

DATETIME_PROPOSED DATE

DATE_SIGNED DATE

DATE_TERMINATED DATE

DATE_RENEWED DATE

TRN_CODE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

AUTHORING_ORG_ID NUMBER
Yes
BUY_OR_SELL VARCHAR2 (3)
ISSUE_OR_RECEIVE VARCHAR2 (3)
ESTIMATED_AMOUNT NUMBER

CHR_ID_RENEWED_TO NUMBER

ESTIMATED_AMOUNT_RENEWED NUMBER

CURRENCY_CODE_RENEWED VARCHAR2 (15)
USER_ACCESS_LEVEL VARCHAR2 (4000)
UPG_ORIG_SYSTEM_REF VARCHAR2 (60)
UPG_ORIG_SYSTEM_REF_ID NUMBER

APPLICATION_ID NUMBER

RESOLVED_UNTIL DATE

ATTRIBUTE_CATEGORY VARCHAR2 (90)
Typically, a reference field from which a descriptive flexfield can get a context field value (optional, but recommended).
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield
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.
ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
ORIG_SYSTEM_ID1 NUMBER

ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
PROGRAM_APPLICATION_ID NUMBER

With PROGRAM_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_ID NUMBER

With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row.
PROGRAM_UPDATE_DATE DATE

Date the concurrent program updated the record.
REQUEST_ID NUMBER

Unique Identifier of a concurrent request.
PRICE_LIST_ID NUMBER

PRICING_DATE DATE

TOTAL_LINE_LIST_PRICE NUMBER

SIGN_BY_DATE DATE

USER_ESTIMATED_AMOUNT NUMBER

GOVERNING_CONTRACT_YN VARCHAR2 (3)
CONVERSION_TYPE VARCHAR2 (30)
CONVERSION_RATE NUMBER

CONVERSION_RATE_DATE DATE

CONVERSION_EURO_RATE NUMBER

CUST_ACCT_ID NUMBER (15)
BILL_TO_SITE_USE_ID NUMBER (15)
INV_RULE_ID NUMBER (15)
RENEWAL_TYPE_CODE VARCHAR2 (30)
RENEWAL_NOTIFY_TO NUMBER

RENEWAL_END_DATE DATE

SHIP_TO_SITE_USE_ID NUMBER (15)
PAYMENT_TERM_ID NUMBER (15)
DOCUMENT_ID NUMBER

LANGUAGE VARCHAR2 (12) Yes Language Primary Key. Standard MLS column.
SOURCE_LANG VARCHAR2 (12) Yes
KHR_ID NUMBER
Yes
KHR_OBJECT_VERSION_NUMBER 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)
STS_MEANING VARCHAR2 (90) Yes
CLASS_MEANING VARCHAR2 (90) Yes
ORG_ID NUMBER
Yes
PERIOD_TYPE VARCHAR2 (10)
PERIOD_START VARCHAR2 (30)
PRICE_UOM VARCHAR2 (10)
FOLLOW_UP_ACTION VARCHAR2 (30)
FOLLOW_UP_DATE DATE

APPROVAL_TYPE VARCHAR2 (30)
TRXN_EXTENSION_ID NUMBER

PAYMENT_INSTRUCTION_TYPE VARCHAR2 (3)
TAX_CLASSIFICATION_CODE VARCHAR2 (50)
EXEMPT_CERTIFICATE_NUMBER VARCHAR2 (80)
EXEMPT_REASON_CODE VARCHAR2 (30)
TERM_CANCEL_SOURCE VARCHAR2 (30)
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

APPROVAL_TYPE_USED VARCHAR2 (30)
CANCELLED_AMOUNT NUMBER

Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      CHR_ID_RESPONSE
,      CHR_ID_AWARD
,      CHR_ID_RENEWED
,      INV_ORGANIZATION_ID
,      STS_CODE
,      QCL_ID
,      SCS_CODE
,      CONTRACT_NUMBER
,      CURRENCY_CODE
,      CONTRACT_NUMBER_MODIFIER
,      ARCHIVED_YN
,      DELETED_YN
,      CUST_PO_NUMBER_REQ_YN
,      PRE_PAY_REQ_YN
,      CUST_PO_NUMBER
,      SHORT_DESCRIPTION
,      COMMENTS
,      DESCRIPTION
,      DPAS_RATING
,      COGNOMEN
,      TEMPLATE_YN
,      TEMPLATE_USED
,      DATE_APPROVED
,      DATETIME_CANCELLED
,      AUTO_RENEW_DAYS
,      DATE_ISSUED
,      DATETIME_RESPONDED
,      NON_RESPONSE_REASON
,      NON_RESPONSE_EXPLAIN
,      RFP_TYPE
,      CHR_TYPE
,      KEEP_ON_MAIL_LIST
,      SET_ASIDE_REASON
,      SET_ASIDE_PERCENT
,      RESPONSE_COPIES_REQ
,      DATE_CLOSE_PROJECTED
,      DATETIME_PROPOSED
,      DATE_SIGNED
,      DATE_TERMINATED
,      DATE_RENEWED
,      TRN_CODE
,      START_DATE
,      END_DATE
,      AUTHORING_ORG_ID
,      BUY_OR_SELL
,      ISSUE_OR_RECEIVE
,      ESTIMATED_AMOUNT
,      CHR_ID_RENEWED_TO
,      ESTIMATED_AMOUNT_RENEWED
,      CURRENCY_CODE_RENEWED
,      USER_ACCESS_LEVEL
,      UPG_ORIG_SYSTEM_REF
,      UPG_ORIG_SYSTEM_REF_ID
,      APPLICATION_ID
,      RESOLVED_UNTIL
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORIG_SYSTEM_SOURCE_CODE
,      ORIG_SYSTEM_ID1
,      ORIG_SYSTEM_REFERENCE1
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PRICE_LIST_ID
,      PRICING_DATE
,      TOTAL_LINE_LIST_PRICE
,      SIGN_BY_DATE
,      USER_ESTIMATED_AMOUNT
,      GOVERNING_CONTRACT_YN
,      CONVERSION_TYPE
,      CONVERSION_RATE
,      CONVERSION_RATE_DATE
,      CONVERSION_EURO_RATE
,      CUST_ACCT_ID
,      BILL_TO_SITE_USE_ID
,      INV_RULE_ID
,      RENEWAL_TYPE_CODE
,      RENEWAL_NOTIFY_TO
,      RENEWAL_END_DATE
,      SHIP_TO_SITE_USE_ID
,      PAYMENT_TERM_ID
,      DOCUMENT_ID
,      LANGUAGE
,      SOURCE_LANG
,      KHR_ID
,      KHR_OBJECT_VERSION_NUMBER
,      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
,      STS_MEANING
,      CLASS_MEANING
,      ORG_ID
,      PERIOD_TYPE
,      PERIOD_START
,      PRICE_UOM
,      FOLLOW_UP_ACTION
,      FOLLOW_UP_DATE
,      APPROVAL_TYPE
,      TRXN_EXTENSION_ID
,      PAYMENT_INSTRUCTION_TYPE
,      TAX_CLASSIFICATION_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      TERM_CANCEL_SOURCE
,      DATE_ACCEPTED
,      ACCEPTED_BY
,      RMNDR_SUPPRESS_FLAG
,      RMNDR_SENT_FLAG
,      QUOTE_SENT_FLAG
,      PROCESS_REQUEST_ID
,      WF_ITEM_KEY
,      PERSON_PARTY_ID
,      APPROVAL_TYPE_USED
,      CANCELLED_AMOUNT
FROM APPS.OKS_AUTH_HEADERS_V;

Dependencies

[top of page]

APPS.OKS_AUTH_HEADERS_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_TL
ViewOKC_STATUSES_V
ViewOKC_SUBCLASSES_V
PL/SQL PackageOKC_UTIL - show dependent code
SynonymOKS_K_HEADERS_B

APPS.OKS_AUTH_HEADERS_V is not referenced by any database object