[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKS_AUTH_HEADERS_HV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKS.OKS_AUTH_HEADERS_HV
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| ID | NUMBER | Yes | ||
| MAJOR_VERSION | NUMBER | (4) | Yes | Tracks the primary version number of a contract. |
| 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 | Indicates a value was changed in another language. Not fully implemented. |
| 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 | VARCHAR2 | (240) | ||
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, MAJOR_VERSION
, 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_HV;
APPS
OKC_K_HEADERS_BH
OKC_K_HEADERS_TLH
OKC_STATUSES_V
OKC_SUBCLASSES_V
OKC_UTIL
- show dependent code
OKS_K_HEADERS_BH
APPS.OKS_AUTH_HEADERS_HV is not referenced by any database object
|
|
|
|