[Home] [Help] [Dependency Information]
Object Name: | OKE_K_HEADERS_HV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_K_HEADERS_HV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Database generated row identifier | |
K_HEADER_ID | NUMBER | Yes | Contract document unique identifier | |
MAJOR_VERSION | NUMBER | Yes | Major version number of contract document | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Internal object version number |
CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (120) | Contract Number Modifier | |
SCS_CODE | VARCHAR2 | (30) | Yes | Contract Category Code |
AUTHORING_ORG_ID | NUMBER | Yes | Contract Authoring (Owning) Organization unique identifier | |
K_NUMBER | VARCHAR2 | (120) | Yes | Contract document number |
K_NUMBER_DISP | VARCHAR2 | (240) | Contract document number for display purpose | |
K_ALIAS | VARCHAR2 | (300) | Contract alias | |
CHR_TYPE | VARCHAR2 | (30) | Yes | OKC Contract Type |
K_TYPE_CODE | VARCHAR2 | (30) | Yes | Internal identifier for contract document type |
K_VALUE | NUMBER | Contract Value | ||
PRODUCT_LINE_CODE | VARCHAR2 | (30) | Product Line Code | |
PRIORITY_CODE | VARCHAR2 | (30) | Priority rating of contract document | |
PROGRAM_ID | NUMBER | Program unique identifier | ||
START_DATE | DATE | Date when contract document becomes effective | ||
END_DATE | DATE | Date when contract document is no longer active (expired) | ||
BUY_OR_SELL | VARCHAR2 | (3) | Contract intent | |
AWARD_DATE | DATE | Contract Award Date | ||
STATUS_CODE | VARCHAR2 | (30) | Yes | Contract Status Code |
SHORT_DESCRIPTION | VARCHAR2 | (600) | Short Description | |
DESCRIPTION | VARCHAR2 | (1995) | Description of contract document | |
PRIME_K_ALIAS | VARCHAR2 | (30) | Prime Contract Alias | |
PRIME_K_NUMBER | VARCHAR2 | (30) | Prime Contract Number | |
CLASSIFIED_FLAG | VARCHAR2 | (1) | Classified indicator | |
DCAA_AUDIT_REQ_FLAG | VARCHAR2 | (1) | DCAA Audit Required indicator | |
BOOKED_FLAG | VARCHAR2 | (1) | Booked indicator | |
OPEN_FLAG | VARCHAR2 | (1) | Open indicator | |
EXPORT_FLAG | VARCHAR2 | (1) | Export indicator | |
BOA_ID | NUMBER | Basic Order Agreement unique identifier | ||
AUTHORIZE_DATE | DATE | Authorize Date | ||
SIC_CODE | VARCHAR2 | (30) | Industry Classification | |
AUTHORIZING_REASON | VARCHAR2 | (240) | Authorizing Reason | |
DATE_ISSUED | DATE | Date Issued | ||
DATE_SIGN_BY_CUSTOMER | DATE | Date Signed by Customer | ||
DATE_SIGN_BY_CONTRACTOR | DATE | Date Signed by Contracter | ||
DATE_RECEIVED | DATE | Date Received | ||
AWARD_CANCEL_DATE | DATE | Award Cancel Date | ||
FAA_APPROVE_DATE | DATE | First Article Approve Date | ||
FAA_REJECT_DATE | DATE | First Article Reject Date | ||
PROJECT_ID | NUMBER | System generated project unique identifier | ||
CUSTOMER_PO_NUMBER | VARCHAR2 | (150) | Customer PO Number | |
NO_COMPETITION_AUTHORIZE | VARCHAR2 | (80) | Non-competition justification | |
HUMAN_SUBJECT_FLAG | VARCHAR2 | (1) | Human Subject Applies indicator | |
PENALTY_CLAUSE_FLAG | VARCHAR2 | (1) | Penalty Clause Applies indicator | |
SB_PLAN_REQ_FLAG | VARCHAR2 | (1) | Small Business Plan Required indicator | |
SB_REPORT_FLAG | VARCHAR2 | (1) | Small Business Report Required indicator | |
CQA_FLAG | VARCHAR2 | (1) | Customer Quality Acceptance Required indicator | |
REPORTING_FLAG | VARCHAR2 | (1) | Reporting Required indicator | |
CFE_FLAG | VARCHAR2 | (1) | Customer Furnished Equipment Required indicator | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (30) | Country of origin | |
COST_OF_MONEY | VARCHAR2 | (1) | Cost of Money Applies indicator | |
DATE_DEFINITIZED | DATE | Date Definitized | ||
DATE_NEGOTIATED | DATE | Date Negotiated | ||
COST_SHARE_FLAG | VARCHAR2 | (1) | Cost Share indicator | |
NTE_WARNING_FLAG | VARCHAR2 | (1) | Not To Exceed Warning indicator | |
INTERIM_RPT_REQ_FLAG | VARCHAR2 | (1) | Interim report required indicator | |
CLIENT_APPROVE_REQ_FLAG | VARCHAR2 | (1) | Client Approval Required indicator | |
CAS_FLAG | VARCHAR2 | (1) | Cost Accounting Standards Applies indicator | |
BILL_WITHOUT_DEF_FLAG | VARCHAR2 | (1) | Bill Without Definitized indicator | |
OH_RATES_FINAL_FLAG | VARCHAR2 | (1) | Overhead Rates Finalized indicator | |
NTE_AMOUNT | NUMBER | Not To Exceed Amount | ||
TECH_DATA_WH_RATE | NUMBER | Technical Data Withholding Rate | ||
VAT_CODE | VARCHAR2 | (30) | VAT Code | |
PROP_DELIVERY_LOCATION | VARCHAR2 | (150) | Proposal Delivery Location | |
PROP_DUE_DATE_TIME | DATE | Proposal Due Date | ||
PROP_DUE_TIME | VARCHAR2 | (80) | Proposal Due | |
PROP_EXPIRE_DATE | DATE | Proposal Expiry Date | ||
COPIES_REQUIRED | NUMBER | Copies of Reponse Required | ||
DEFINITIZED_FLAG | VARCHAR2 | (1) | Definitized indicator | |
FINANCIAL_CTRL_VERIFIED_FLAG | VARCHAR2 | (1) | Financial Control Verified indicator | |
COST_OF_SALE_RATE | NUMBER | Cost of Sale Rate | ||
LINE_VALUE_TOTAL | NUMBER | Line Value Total | ||
UNDEF_LINE_VALUE_TOTAL | NUMBER | Undefinitized Line Value Total | ||
OWNING_ORGANIZATION_ID | NUMBER | Owning Organization ID | ||
TEMPLATE_YN | VARCHAR2 | (3) | Yes | Template indicator |
QCL_ID | NUMBER | Quality Check List unique identifier | ||
TRN_CODE | VARCHAR2 | (30) | Contract line termination code | |
ISSUE_OR_RECEIVE | VARCHAR2 | (3) | Perspective | |
COMMENTS | VARCHAR2 | (1995) | User-entered comments | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield attribute context | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield attribute | |
DEFAULT_TASK_ID | NUMBER | Task Id of the task to be defaulted on contract lines. | ||
DEFAULT_TASK_NUMBER | VARCHAR2 | (25) | Task number of the task to be defaulted on contract lines. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, K_HEADER_ID
, MAJOR_VERSION
, OBJECT_VERSION_NUMBER
, CONTRACT_NUMBER_MODIFIER
, SCS_CODE
, AUTHORING_ORG_ID
, K_NUMBER
, K_NUMBER_DISP
, K_ALIAS
, CHR_TYPE
, K_TYPE_CODE
, K_VALUE
, PRODUCT_LINE_CODE
, PRIORITY_CODE
, PROGRAM_ID
, START_DATE
, END_DATE
, BUY_OR_SELL
, AWARD_DATE
, STATUS_CODE
, SHORT_DESCRIPTION
, DESCRIPTION
, PRIME_K_ALIAS
, PRIME_K_NUMBER
, CLASSIFIED_FLAG
, DCAA_AUDIT_REQ_FLAG
, BOOKED_FLAG
, OPEN_FLAG
, EXPORT_FLAG
, BOA_ID
, AUTHORIZE_DATE
, SIC_CODE
, AUTHORIZING_REASON
, DATE_ISSUED
, DATE_SIGN_BY_CUSTOMER
, DATE_SIGN_BY_CONTRACTOR
, DATE_RECEIVED
, AWARD_CANCEL_DATE
, FAA_APPROVE_DATE
, FAA_REJECT_DATE
, PROJECT_ID
, CUSTOMER_PO_NUMBER
, NO_COMPETITION_AUTHORIZE
, HUMAN_SUBJECT_FLAG
, PENALTY_CLAUSE_FLAG
, SB_PLAN_REQ_FLAG
, SB_REPORT_FLAG
, CQA_FLAG
, REPORTING_FLAG
, CFE_FLAG
, CURRENCY_CODE
, COUNTRY_OF_ORIGIN_CODE
, COST_OF_MONEY
, DATE_DEFINITIZED
, DATE_NEGOTIATED
, COST_SHARE_FLAG
, NTE_WARNING_FLAG
, INTERIM_RPT_REQ_FLAG
, CLIENT_APPROVE_REQ_FLAG
, CAS_FLAG
, BILL_WITHOUT_DEF_FLAG
, OH_RATES_FINAL_FLAG
, NTE_AMOUNT
, TECH_DATA_WH_RATE
, VAT_CODE
, PROP_DELIVERY_LOCATION
, PROP_DUE_DATE_TIME
, PROP_DUE_TIME
, PROP_EXPIRE_DATE
, COPIES_REQUIRED
, DEFINITIZED_FLAG
, FINANCIAL_CTRL_VERIFIED_FLAG
, COST_OF_SALE_RATE
, LINE_VALUE_TOTAL
, UNDEF_LINE_VALUE_TOTAL
, OWNING_ORGANIZATION_ID
, TEMPLATE_YN
, QCL_ID
, TRN_CODE
, ISSUE_OR_RECEIVE
, COMMENTS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DEFAULT_TASK_ID
, DEFAULT_TASK_NUMBER
FROM APPS.OKE_K_HEADERS_HV;
|
|
|