[Home] [Help] [Dependency Information]
Object Name: | OKE_K_HEADERS_FULL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKE.OKE_K_HEADERS_FULL_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows more detailed contract header information, including displayed values for internal codes and checkboxes.
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 | Major version number of contract document | ||
MINOR_VERSION | NUMBER | Yes | Minor version number of contract document (not currently used) | |
VERSION_DISP | VARCHAR2 | (81) | Concatenation of major version and minor version for display purposes | |
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 Organization unique identifier | |
AUTHORING_ORG | VARCHAR2 | (240) | Contract Authoring Organization | |
K_NUMBER | VARCHAR2 | (120) | Yes | Contract document number |
K_ALIAS | VARCHAR2 | (300) | Contract alias | |
CHR_TYPE | VARCHAR2 | (30) | Yes | Contracts Core Contract Type |
K_TYPE_CODE | VARCHAR2 | (30) | Yes | Internal identifier for contract document type |
K_TYPE | VARCHAR2 | (80) | Yes | Contract document type name |
TYPE_CLASS_CODE | VARCHAR2 | (30) | Yes | Contract document type class code |
K_VALUE | NUMBER | Contract Value | ||
OWNING_ORGANIZATION_ID | NUMBER | Owning Organization ID | ||
OWNING_ORGANIZATION | VARCHAR2 | (240) | Owning Organization Name | |
PRODUCT_LINE_CODE | VARCHAR2 | (30) | Product Line Code | |
PRODUCT_LINE | VARCHAR2 | (80) | Product Line | |
PRIORITY_CODE | VARCHAR2 | (30) | Priority rating of contract document | |
PRIORITY_RATING | VARCHAR2 | (80) | Priority Rating | |
PROGRAM_ID | NUMBER | Program unique identifier | ||
PROGRAM_NUMBER | VARCHAR2 | (80) | Program number | |
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 |
STATUS | VARCHAR2 | (90) | Yes | Contract Status |
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 | |
CLASSIFIED_YN | VARCHAR2 | (4000) | Classified? | |
DCAA_AUDIT_REQ_FLAG | VARCHAR2 | (1) | DCAA Audit Required indicator | |
DCAA_AUDIT_REQ_YN | VARCHAR2 | (4000) | DCAA Audit Required? | |
BOOKED_FLAG | VARCHAR2 | (1) | Booked indicator | |
BOOKED_YN | VARCHAR2 | (4000) | Booked? | |
OPEN_FLAG | VARCHAR2 | (1) | Open indicator | |
OPEN_YN | VARCHAR2 | (4000) | Open? | |
EXPORT_FLAG | VARCHAR2 | (1) | Export indicator | |
EXPORT_YN | VARCHAR2 | (4000) | Export Required? | |
BOA_ID | NUMBER | Basic Order Agreement unique identifier | ||
BOA_NUMBER | VARCHAR2 | (120) | Basic Order Agreement Number | |
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 | ||
DATE_APPROVED | DATE | Date Approved | ||
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 | ||
PROJECT_NUMBER | VARCHAR2 | (25) | Project number | |
PROJECT_NAME | VARCHAR2 | (30) | Project name | |
PROJECT_DESCRIPTION | VARCHAR2 | (250) | Project description | |
PROJECT_START_DATE | DATE | Project Start Date | ||
PROJECT_COMPLETION_DATE | DATE | Project Completion Date | ||
PROJECT_ORGANIZATION | VARCHAR2 | (240) | Project Organization | |
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 | |
HUMAN_SUBJECT_YN | VARCHAR2 | (4000) | Human Subject Applies? | |
PENALTY_CLAUSE_FLAG | VARCHAR2 | (1) | Penalty Clause Applies indicator | |
PENALTY_CLAUSE_YN | VARCHAR2 | (4000) | Penalty Clause Applies? | |
SB_PLAN_REQ_FLAG | VARCHAR2 | (1) | Small Business Plan Required indicator | |
SB_PLAN_REQ_YN | VARCHAR2 | (4000) | Small Business Plan Required? | |
SB_REPORT_FLAG | VARCHAR2 | (1) | Small Business Report Required indicator | |
SB_REPORT_YN | VARCHAR2 | (4000) | Small Business Report Required? | |
CQA_FLAG | VARCHAR2 | (1) | Customer Quality Acceptance Required indicator | |
CQA_YN | VARCHAR2 | (4000) | Customer Quality Acceptance Required? | |
REPORTING_FLAG | VARCHAR2 | (1) | Reporting Required indicator | |
REPORTING_YN | VARCHAR2 | (4000) | Reporting Required? | |
CFE_FLAG | VARCHAR2 | (1) | Customer Furnished Equipment Required indicator | |
CFE_YN | VARCHAR2 | (4000) | Customer Furnished Equipment Required? | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency | |
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (30) | Country of origin | |
COST_OF_MONEY | VARCHAR2 | (1) | Cost of Money Applies indicator | |
COST_OF_MONEY_YN | VARCHAR2 | (4000) | Cost of Money Applies? | |
DATE_DEFINITIZED | DATE | Date Definitized | ||
DATE_NEGOTIATED | DATE | Date Negotiated | ||
COST_SHARE_FLAG | VARCHAR2 | (1) | Cost Share indicator | |
COST_SHARE_YN | VARCHAR2 | (4000) | Cost Share? | |
NTE_WARNING_FLAG | VARCHAR2 | (1) | Not To Exceed Warning indicator | |
NTE_WARNING_YN | VARCHAR2 | (4000) | Not To Exceed Warning? | |
INTERIM_RPT_REQ_FLAG | VARCHAR2 | (1) | Interim report required indicator | |
INTERIM_RPT_REQ_YN | VARCHAR2 | (4000) | Interim Report Required? | |
CLIENT_APPROVE_REQ_FLAG | VARCHAR2 | (1) | Client Approval Required indicator | |
CLIENT_APPROVE_REQ_YN | VARCHAR2 | (4000) | Client Approval Required? | |
CAS_FLAG | VARCHAR2 | (1) | Cost Accounting Standards Applies indicator | |
CAS_YN | VARCHAR2 | (4000) | Cost Accounting Standards Applies? | |
BILL_WITHOUT_DEF_FLAG | VARCHAR2 | (1) | Bill Without Definitized indicator | |
BILL_WITHOUT_DEF_YN | VARCHAR2 | (4000) | Bill Without Definitized? | |
OH_RATES_FINAL_FLAG | VARCHAR2 | (1) | Overhead Rates Finalized indicator | |
OH_RATES_FINAL_YN | VARCHAR2 | (4000) | Overhead Rates Finalized? | |
NTE_AMOUNT | NUMBER | Not To Exceed Amount | ||
TECH_DATA_WH_RATE | NUMBER | Technical Data Withholding Rate | ||
PROGRESS_PAYMENT_FLAG | VARCHAR2 | (1) | Progress Payment Applies indicator | |
PROGRESS_PAYMENT_YN | VARCHAR2 | (4000) | Progress Payment Applies? | |
PROGRESS_PAYMENT_LIQ_RATE | NUMBER | Progress Payment Liquidation Rate | ||
PROGRESS_PAYMENT_RATE | NUMBER | Progress Payment Rate | ||
ALTERNATE_LIQUIDATION_RATE | NUMBER | Alternate Liquidation 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 | |
DEFINITIZED_YN | VARCHAR2 | (4000) | Definitized? | |
FINANCIAL_CTRL_VERIFIED_FLAG | VARCHAR2 | (1) | Financial Control Verified indicator | |
FINANCIAL_CTRL_VERIFIED_YN | VARCHAR2 | (4000) | Financial Control Verified? | |
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 | ||
TEMPLATE_YN | VARCHAR2 | (3) | Yes | Template indicator |
TEMPLATE_YN_DSP | VARCHAR2 | (4000) | Template? | |
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 | |
FREIGHT_TERMS_CODE | VARCHAR2 | (4000) | ||
FOB_POINT_CODE | VARCHAR2 | (4000) | ||
DEFAULT_TASK_ID | NUMBER | Task Id of the task to be defaulted on contract lines. Used only for defaulting. | ||
DEFAULT_TASK_NUMBER | VARCHAR2 | (25) | Task number of the task to be defaulted on contract lines. Used only for defaulting. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, K_HEADER_ID
, MAJOR_VERSION
, MINOR_VERSION
, VERSION_DISP
, OBJECT_VERSION_NUMBER
, CONTRACT_NUMBER_MODIFIER
, SCS_CODE
, AUTHORING_ORG_ID
, AUTHORING_ORG
, K_NUMBER
, K_ALIAS
, CHR_TYPE
, K_TYPE_CODE
, K_TYPE
, TYPE_CLASS_CODE
, K_VALUE
, OWNING_ORGANIZATION_ID
, OWNING_ORGANIZATION
, PRODUCT_LINE_CODE
, PRODUCT_LINE
, PRIORITY_CODE
, PRIORITY_RATING
, PROGRAM_ID
, PROGRAM_NUMBER
, START_DATE
, END_DATE
, BUY_OR_SELL
, AWARD_DATE
, STATUS_CODE
, STATUS
, SHORT_DESCRIPTION
, DESCRIPTION
, PRIME_K_ALIAS
, PRIME_K_NUMBER
, CLASSIFIED_FLAG
, CLASSIFIED_YN
, DCAA_AUDIT_REQ_FLAG
, DCAA_AUDIT_REQ_YN
, BOOKED_FLAG
, BOOKED_YN
, OPEN_FLAG
, OPEN_YN
, EXPORT_FLAG
, EXPORT_YN
, BOA_ID
, BOA_NUMBER
, AUTHORIZE_DATE
, SIC_CODE
, AUTHORIZING_REASON
, DATE_ISSUED
, DATE_SIGN_BY_CUSTOMER
, DATE_SIGN_BY_CONTRACTOR
, DATE_RECEIVED
, DATE_APPROVED
, AWARD_CANCEL_DATE
, FAA_APPROVE_DATE
, FAA_REJECT_DATE
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_DESCRIPTION
, PROJECT_START_DATE
, PROJECT_COMPLETION_DATE
, PROJECT_ORGANIZATION
, CUSTOMER_PO_NUMBER
, NO_COMPETITION_AUTHORIZE
, HUMAN_SUBJECT_FLAG
, HUMAN_SUBJECT_YN
, PENALTY_CLAUSE_FLAG
, PENALTY_CLAUSE_YN
, SB_PLAN_REQ_FLAG
, SB_PLAN_REQ_YN
, SB_REPORT_FLAG
, SB_REPORT_YN
, CQA_FLAG
, CQA_YN
, REPORTING_FLAG
, REPORTING_YN
, CFE_FLAG
, CFE_YN
, CURRENCY_CODE
, COUNTRY_OF_ORIGIN_CODE
, COST_OF_MONEY
, COST_OF_MONEY_YN
, DATE_DEFINITIZED
, DATE_NEGOTIATED
, COST_SHARE_FLAG
, COST_SHARE_YN
, NTE_WARNING_FLAG
, NTE_WARNING_YN
, INTERIM_RPT_REQ_FLAG
, INTERIM_RPT_REQ_YN
, CLIENT_APPROVE_REQ_FLAG
, CLIENT_APPROVE_REQ_YN
, CAS_FLAG
, CAS_YN
, BILL_WITHOUT_DEF_FLAG
, BILL_WITHOUT_DEF_YN
, OH_RATES_FINAL_FLAG
, OH_RATES_FINAL_YN
, NTE_AMOUNT
, TECH_DATA_WH_RATE
, PROGRESS_PAYMENT_FLAG
, PROGRESS_PAYMENT_YN
, PROGRESS_PAYMENT_LIQ_RATE
, PROGRESS_PAYMENT_RATE
, ALTERNATE_LIQUIDATION_RATE
, VAT_CODE
, PROP_DELIVERY_LOCATION
, PROP_DUE_DATE_TIME
, PROP_DUE_TIME
, PROP_EXPIRE_DATE
, COPIES_REQUIRED
, DEFINITIZED_FLAG
, DEFINITIZED_YN
, FINANCIAL_CTRL_VERIFIED_FLAG
, FINANCIAL_CTRL_VERIFIED_YN
, COST_OF_SALE_RATE
, LINE_VALUE_TOTAL
, UNDEF_LINE_VALUE_TOTAL
, TEMPLATE_YN
, TEMPLATE_YN_DSP
, 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
, FREIGHT_TERMS_CODE
, FOB_POINT_CODE
, DEFAULT_TASK_ID
, DEFAULT_TASK_NUMBER
FROM APPS.OKE_K_HEADERS_FULL_V;
|
|
|