This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AGING_BUCKET_ID | NUMBER | (15) | Y | Identifier of aging bucket |
| BUCKET_NAME | VARCHAR2 | (20) | Y | Aging bucket name |
| STATUS | VARCHAR2 | (30) | Y | Status of the aging bucket (Active or Inactive) |
| AGING_TYPE | VARCHAR2 | (30) | Y | Lookup code for aging bucket type in AR_LOOKUPS |
| DESCRIPTION | VARCHAR2 | (240) | Aging bucket description | |
| B_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| B_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| B_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| AGING_BUCKET_LINE_ID | NUMBER | (15) | Y | Identifier of aging bucket line |
| LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Y | Standard Who column |
| CREATION_DATE | DATE | Y | Standard Who column | |
| BUCKET_SEQUENCE_NUM | NUMBER | (15) | Sequence number | |
| DAYS_START | NUMBER | Start of days range | ||
| DAYS_TO | NUMBER | End of days range | ||
| TYPE | VARCHAR2 | (30) | Y | Lookup code for aging bucket line type in AR_LOOKUPS, with significant values DISPUTE_ONLY, DISPUTE_PENDADJ, and PENDADJ_ONLY |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column |
APPS.OKX_AGING_BUCKETS_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Displays information about customer agreements regarding the accounting and invoicing rules application.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AGREEMENT_ID | NUMBER | Y | System-generated identifier for the agreement | |
| PRICE_LIST_ID | NUMBER | Price list used for this agreement | ||
| AGREEMENT_NUM | VARCHAR2 | (50) | User-defined number for this agreement | |
| INVOICING_RULE | NUMBER | Invoicing rule | ||
| ACCOUNTING_RULE | NUMBER | Accounting rule | ||
| CUSTOMER_ID | NUMBER | Sold-to customer | ||
| START_DATE_ACTIVE | DATE | Date this record becomes active, if limited | ||
| END_DATE_ACTIVE | DATE | Date this record becomes inactive, if limited | ||
| NAME | VARCHAR2 | (240) | Y | Agreement name |
| DESCRIPTION | VARCHAR2 | (30) | Code used to group agreements for reporting | |
| STATUS | VARCHAR2 | (1) | Status |
APPS.OKX_AGREEMENTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary Key column System generated asset identification number |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (15) | Y | User defined asset number |
| DESCRIPTION | VARCHAR2 | (80) | User defined asset description | |
| ASSET_ID | NUMBER | (15) | Y | Asset identification number |
| ASSET_NUMBER | VARCHAR2 | (15) | Y | User defined asset number |
| CORPORATE_BOOK | VARCHAR2 | (15) | Y | Corporate book code for the asset |
| LIFE_IN_MONTHS | NUMBER | (4) | Total life of the asset in months | |
| ORIGINAL_COST | NUMBER | Y | Original cost of the asset | |
| COST | NUMBER | Y | Current cost of the asset | |
| ADJUSTED_COST | NUMBER | Y | Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustment or revaluation | |
| TAG_NUMBER | VARCHAR2 | (15) | Tag number of the asset | |
| CURRENT_UNITS | NUMBER | Y | Current number of units for the asset | |
| SERIAL_NUMBER | VARCHAR2 | (35) | Serial number of the asset | |
| REVAL_CEILING | NUMBER | Upper limit for revaluing asset cost | ||
| NEW_USED | VARCHAR2 | (4) | Y | Indicates whether the asset is new or used |
| IN_SERVICE_DATE | DATE | Y | Date the asset was placed in service | |
| MANUFACTURER_NAME | VARCHAR2 | (360) | Name of the manufacturer | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model number of asset | |
| ASSET_TYPE | VARCHAR2 | (11) | Y | Indicates whether the asset is CIP, capitalized or expensed |
| SALVAGE_VALUE | NUMBER | Y | Asset salvage value | |
| PERCENT_SALVAGE_VALUE | NUMBER | Salvage value percentage amount | ||
| DEPRECIATION_CATEGORY | NUMBER | (15) | Y | Unique identifier for asset category |
| DEPRN_START_DATE | DATE | Y | Date the asset started to depreciate | |
| DEPRN_METHOD_CODE | VARCHAR2 | (12) | Y | Name of the depreciation method for the asset |
| RATE_ADJUSTMENT_FACTOR | NUMBER | Y | Percent of remaining depreciation after a revaluation or an amortized change, or 1 | |
| BASIC_RATE | NUMBER | Base rate used to calculate depreciation amount for flat-rate methods | ||
| ADJUSTED_RATE | NUMBER | Actual rate used to calculate depreciation for flat-rate methods | ||
| START_DATE_ACTIVE | DATE | Y | Effective from date | |
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (2) | Indicates whether current record is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
| RECOVERABLE_COST | NUMBER | Y | Cost minus salvage value or depreciation ceiling, whichever is lower | |
| ORG_ID | NUMBER | (15) | Unique identifier for operating unit | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Unique identifier for accounting set of books |
| PROPERTY_TYPE_CODE | VARCHAR2 | (10) | Indicates the property type | |
| PROPERTY_1245_1250_CODE | VARCHAR2 | (4) | Indicates whether property class is 1245(personal) or 1250(real) | |
| IN_USE_FLAG | VARCHAR2 | (3) | Y | Indicates whether the asset is in use |
| OWNED_LEASED | VARCHAR2 | (15) | Y | Indicates whether asset is owned or leased |
| INVENTORIAL | VARCHAR2 | (3) | Indicates whether the asset should be included in physical inventory |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary key column. System generated unique identifier for fixed asset line | |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (15) | Y | User defined name of the Lease financial asset |
| DESCRIPTION | VARCHAR2 | (80) | User defined description of the Lease financial asset | |
| ITEM_DESCRIPTION | VARCHAR2 | (1995) | User defined item description of the Lease fianancial asset | |
| COMMENTS | VARCHAR2 | (1995) | Comments | |
| CHR_ID | NUMBER | System generated unique identifier for the contract | ||
| DNZ_CHR_ID | NUMBER | Y | System generated denormalized unique identifier for the contract | |
| LTY_CODE | VARCHAR2 | (30) | Y | Line type code |
| LSE_TYPE | VARCHAR2 | (10) | Y | Indicates whetehr thecontract line is a top line or sub line |
| LSE_PARENT_ID | NUMBER | System generated parent line style identifier | ||
| PARENT_LINE_ID | NUMBER | System generated unique identifier for the parent line | ||
| LINE_NUMBER | VARCHAR2 | (150) | Y | Asset line number |
| DATE_TERMINATED | DATE | Date on which asset line was terminated | ||
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indiactes where the asset line is active or inactive | |
| ASSET_ID | NUMBER | (15) | Y | Unique identifier for fixed asset |
| QUANTITY | NUMBER | Y | Quantity of te asset | |
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Unis of measure code | |
| ASSET_NUMBER | VARCHAR2 | (15) | Y | User assigned number of the asset |
| CORPORATE_BOOK | VARCHAR2 | (15) | Y | Corporate book for the asset |
| LIFE_IN_MONTHS | NUMBER | (4) | Life of the asset in complete months | |
| ORIGINAL_COST | NUMBER | Original cost of the asset | ||
| COST | NUMBER | Y | Current cost of the asset | |
| ADJUSTED_COST | NUMBER | Y | Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustment or revaluation | |
| TAG_NUMBER | VARCHAR2 | (15) | Tag number of the asset | |
| CURRENT_UNITS | NUMBER | Y | Current units of the assets | |
| SERIAL_NUMBER | VARCHAR2 | (35) | Serial number of the asset | |
| REVAL_CEILING | NUMBER | Upper limit for revaluing asset cost | ||
| NEW_USED | VARCHAR2 | (4) | Y | Indicates whether the asset is new or used |
| IN_SERVICE_DATE | DATE | Y | Date the asset was placed in service | |
| MANUFACTURER_NAME | VARCHAR2 | (360) | Manufacturer name | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model number of the asset | |
| ASSET_TYPE | VARCHAR2 | (11) | Y | Indicates whether the asset is CIP, capitalized or expensed |
| SALVAGE_VALUE | NUMBER | Y | Salvage value of the asset | |
| PERCENT_SALVAGE_VALUE | NUMBER | Percentage salvage value | ||
| DEPRECIATION_CATEGORY | NUMBER | (15) | Y | Unique identifier for asset category |
| DEPRN_START_DATE | DATE | Y | Date the asset started to depreciate | |
| DEPRN_METHOD_CODE | VARCHAR2 | (12) | Y | Name of the depreciation method for the asset |
| RATE_ADJUSTMENT_FACTOR | NUMBER | Y | Percent of remaining depreciation after revaluation or an amortized change, or 1 | |
| BASIC_RATE | NUMBER | Base rate used to calculate depreciation amount for flat-rate methods | ||
| ADJUSTED_RATE | NUMBER | Actual rate used to calculate depreciation amount for flat-rate methods | ||
| RECOVERABLE_COST | NUMBER | Y | Cost minus salvage value or depreciation ceiling , whichever is lower | |
| ORG_ID | NUMBER | (15) | Unique identifier for operating unit | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Unique identifier for accounting set of books |
| PROPERTY_TYPE_CODE | VARCHAR2 | (10) | Indicates property type | |
| PROPERTY_1245_1250_CODE | VARCHAR2 | (4) | Indicate whether property class is 1245 (personal) or 1250 (real) | |
| IN_USE_FLAG | VARCHAR2 | (3) | Y | Indicates whether the asset is in use or not |
| OWNED_LEASED | VARCHAR2 | (15) | Y | Indicates whether the asset is owned or leased |
| INVENTORIAL | VARCHAR2 | (3) | Indicates whether the asset should be included in physical inventory | |
| LINE_STATUS | VARCHAR2 | (30) | Y | Status of the fixed asset line |
| YEAR_BUILT | NUMBER | (4) | Year of manufacture or construction of the asset |
APPS.OKX_ASSET_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | VARCHAR2 | (15) | Y | Primary key column. Book name |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (15) | Y | Book name |
| DESCRIPTION | VARCHAR2 | (30) | Y | Book description |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Y | Book name |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set of books identification number for GL sets of books |
| START_DATE_ACTIVE | DATE | Y | Effective from date | |
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether the record is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
| LAST_DEPRN_RUN_DATE | DATE | Y | Date of last depreciation | |
| AMORTIZE_FLAG | VARCHAR2 | (3) | Y | Indicates whether or not to allow amortized changes |
| FULLY_RESERVED_FLAG | VARCHAR2 | (3) | Y | Not used |
| DEPRN_CALENDAR | VARCHAR2 | (15) | Y | Name of depreciation calendar |
| BOOK_CLASS | VARCHAR2 | (15) | Y | Indicates whether the book is a corporate tax or budget book |
| MASS_COPY_SOURCE_BOOK | VARCHAR2 | (15) | Associated coprporate book to mass copy from | |
| ORG_ID | NUMBER | (15) | Identifies operating unit | |
| ALLOW_MASS_CHANGES | VARCHAR2 | (3) | Y | Indicates whether or not to allow mass changes |
| PRORATE_CALENDAR | VARCHAR2 | (15) | Y | Name of prorate calendar |
| COPY_RETIREMENTS_FLAG | VARCHAR2 | (3) | Y | Indicates whether or not to copy retirements in mass copy |
| COPY_ADJUSTMENTS_FLAG | VARCHAR2 | (3) | Y | Indicates whether or not to copy adjustments in mass copy |
| ALLOW_MASS_COPY | VARCHAR2 | (3) | Y | Indicates whether or not to allow mass copy |
| ALLOW_PURGE_FLAG | VARCHAR2 | (3) | Indicates whether or not to allow purge | |
| ALLOW_REVAL_FLAG | VARCHAR2 | (3) | Y | Indicates whether or not to allow revaluation |
| AMORTIZE_REVAL_RESERVE_FLAG | VARCHAR2 | (3) | Indicates whetehr or not to amortize revaluation reserve | |
| COPY_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Y | Indicates whether or not to mass copy salvage value |
| LAST_MASS_COPY_PERIOD_COUNTER | NUMBER | (15) | Last corporate period mass copied into this tax book | |
| LAST_PERIOD_COUNTER | NUMBER | (15) | Y | Last period depreciated in this book |
| IMMEDIATE_COPY_FLAG | VARCHAR2 | (3) | Indicates whether to copy immediately from corporate book to tax book | |
| COPY_ADDITIONS_FLAG | VARCHAR2 | (3) | Y | Indicates whether or not to copy additions in a mass copy |
| USE_PERCENT_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Not used |
APPS.OKX_ASST_BK_CONTROLS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary ket column. Unique identifier for asset category |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (216) | Concatenated segments of asset category key flexfield | |
| DESCRIPTION | VARCHAR2 | (40) | Asset category description | |
| CATEGORY_ID | NUMBER | (15) | Y | Unique identifier for asset category |
| SUMMARY_FLAG | VARCHAR2 | (1) | Y | Internal use column |
| ENABLED_FLAG | VARCHAR2 | (1) | Y | Indicates whether this category is still valid |
| OWNED_LEASED | VARCHAR2 | (6) | Y | Indicates whether the assets in this category are owned or leased |
| CATEGORY_TYPE | VARCHAR2 | (30) | Y | Indicates the category type Oracle Assets uses to classify the assets in this category |
| CAPITALIZE_FLAG | VARCHAR2 | (3) | Y | Indicates whether the assets in this category are capitalized |
| SEGMENT1 | VARCHAR2 | (30) | Asset category key flexfield segment column | |
| SEGMENT2 | VARCHAR2 | (30) | Asset category key flexfield segment column | |
| SEGMENT3 | VARCHAR2 | (30) | Asset category key flexfield segment column | |
| SEGMENT4 | VARCHAR2 | (30) | Asset category key flexfield segment column | |
| SEGMENT5 | VARCHAR2 | (30) | Asset category key flexfield segment column | |
| SEGMENT6 | VARCHAR2 | (30) | Asset category key flexfield segment column | |
| SEGMENT7 | VARCHAR2 | (30) | Asset category key flexfield segment column | |
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether the asset category is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
| PROPERTY_TYPE_CODE | VARCHAR2 | (10) | Inkdicates the property type you assigned to an asset category | |
| PROPERTY_1245_1250_CODE | VARCHAR2 | (4) | Indicates whether the assets in this category are 1245 property class or 1250 property class | |
| DATE_INEFFECTIVE | DATE | Not used | ||
| PRODUCTION_CAPACITY | NUMBER | Production capacity of assets that use a unit of production depreciation method | ||
| INVENTORIAL | VARCHAR2 | (3) | Indicates whether the asset should be included in physical inventory |
APPS.OKX_ASST_CATGRS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary key column. Unique identification number for a depreciation method |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (53) | Method code concatenated with life in months | |
| DESCRIPTION | VARCHAR2 | (80) | Method description | |
| METHOD_CODE | VARCHAR2 | (12) | Y | Short name for the method |
| LIFE_IN_MONTHS | NUMBER | (4) | Life of an asset that uses this depreciation method. Used only for life-based depreciation methods | |
| DEPRECIATE_LASTYEAR_FLAG | VARCHAR2 | (3) | Y | Indicates whether the asset is to be depreciated in its last year of life |
| STL_METHOD_FLAG | VARCHAR2 | (3) | Y | Indicates a straight line definition rule |
| RATE_SOURCE_RULE | VARCHAR2 | (10) | Y | Indicates the depreciation rate source. Either CALCULATED, FLAT, PRODUCTION or TABLE |
| DEPRN_BASIS_RULE | VARCHAR2 | (4) | Y | Indicates whether depreciation is based on cost or net book value |
| PRORATE_PERIODS_PER_YEAR | NUMBER | (3) | Number of prorate periods for table based methods | |
| EXCLUDE_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Indicates whether to exclude salvage value from the depreciable basis | |
| DEPRN_BASIS_FORMULA | VARCHAR2 | (25) | Formula used to base depreciation basis | |
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | CHAR | (1) | Indicates whether the depreciation method is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code |
APPS.OKX_ASST_DEP_METHODS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary key column. Unique identifier for the asset |
| ID2 | VARCHAR2 | (15) | Y | Primary key colum. Unique identifier for asset book |
| NAME | VARCHAR2 | (15) | Y | User assigned asset number |
| DESCRIPTION | VARCHAR2 | (80) | User assigned asset description | |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Y | Asset book code |
| BOOK_CLASS | VARCHAR2 | (15) | Y | Indicates whether the book is 'CORPORATE', 'TAX' or 'BUDGET' |
| ASSET_ID | NUMBER | (15) | Y | Unique identifier for the asset |
| ASSET_NUMBER | VARCHAR2 | (15) | Y | User assigned asset number |
| SERIAL_NUMBER | VARCHAR2 | (35) | Serial number of the asset | |
| SALVAGE_VALUE | NUMBER | Y | Salvage value for the asset | |
| PERCENT_SALVAGE_VALUE | NUMBER | Percentage salvage value | ||
| LIFE_IN_MONTHS | NUMBER | (4) | Life ofthe asset in complete months | |
| ACQUISITION_DATE | DATE | Y | Date the asset was place in service | |
| ORIGINAL_COST | NUMBER | Y | Original cost of the asset | |
| COST | NUMBER | Y | Current cost of the asset | |
| ADJUSTED_COST | NUMBER | Y | Recoverable cost less depreciation reserve. Reset when you perform an amortized adjustmet or revaluation | |
| TAG_NUMBER | VARCHAR2 | (15) | Tag number of the asset | |
| CURRENT_UNITS | NUMBER | Y | Current units of the asset | |
| REVAL_CEILING | NUMBER | Upper limit for revaluing the cost | ||
| NEW_USED | VARCHAR2 | (4) | Y | Indicates whether the asset is new or used |
| MANUFACTURER_NAME | VARCHAR2 | (360) | Manufacturer name | |
| MODEL_NUMBER | VARCHAR2 | (40) | Model number of the asset | |
| ASSET_TYPE | VARCHAR2 | (11) | Y | Indicates whether the asset is CIP, capitalized or expensed |
| DEPRECIATION_CATEGORY | NUMBER | (15) | Y | Unique identifier for asset category |
| DEPRN_START_DATE | DATE | Y | Date the asset started to depreciate | |
| DEPRN_METHOD_CODE | VARCHAR2 | (12) | Y | Name of te depreciation method for the asset |
| RATE_ADJUSTMENT_FACTOR | NUMBER | Y | Percent of remaining depreciation after revaluation or an amortized change , or 1 | |
| BASIC_RATE | NUMBER | Basic rate used to calculate depreciation amount for flat-rate methods | ||
| ADJUSTED_RATE | NUMBER | Actual rate used to calculate depreciation amount for flat-rate methods | ||
| START_DATE_ACTIVE | DATE | Y | Effective from date | |
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indiates whether the asset record is active | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
| RECOVERABLE_COST | NUMBER | Y | Cost minus salvage value , or depreciation ceiling whichever is lower | |
| ORG_ID | NUMBER | (15) | Unique identifier for operating unit | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Unique identifier for accounting set of books |
APPS.OKX_AST_BKS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary key column. Unique Identifier for the asset category |
| ID2 | VARCHAR2 | (15) | Y | Primary key column. Book name |
| NAME | VARCHAR2 | (216) | Concatenated segments of asset category flexfield | |
| DESCRIPTION | CHAR | (1) | Not used | |
| CATEGORY_ID | NUMBER | (15) | Y | Identifies the asset category |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Y | Book name |
| ASSET_CLEARING_ACCT | VARCHAR2 | (25) | Y | Clearing account segment for capitalized asset |
| ASSET_COST_ACCT | VARCHAR2 | (25) | Y | Cost account segment for capitalized assets |
| CIP_CLEARING_ACCT | VARCHAR2 | (25) | Clearing account segment for CIP assets | |
| CIP_COST_ACCT | VARCHAR2 | (25) | Cost account segment for CIP assets | |
| DEPRN_EXPENSE_ACCT | VARCHAR2 | (25) | Y | Expense account segment for depreciation |
| DEPRN_RESERVE_ACCT | VARCHAR2 | (25) | Y | Reserve account segment for depreciation |
| REVAL_AMORTIZATION_ACCT | VARCHAR2 | (25) | Account segment for revaluation reserve amortization | |
| REVAL_RESERVE_ACCT | VARCHAR2 | (25) | Account segment for revaluation reserve | |
| ASSET_COST_ACCOUNT_CCID | NUMBER | (15) | Y | Cost account ccid |
| ASSET_CLEARING_ACCOUNT_CCID | NUMBER | (15) | Y | Clearing account ccid |
| WIP_COST_ACCOUNT_CCID | NUMBER | (15) | CIP cost account ccid | |
| WIP_CLEARING_ACCOUNT_CCID | NUMBER | (15) | CIP clearing account ccid | |
| RESERVE_ACCOUNT_CCID | NUMBER | (15) | Y | Accumulated depreciation ccid |
| REVAL_AMORT_ACCOUNT_CCID | NUMBER | (15) | Revaluation reserve account ccid | |
| REVAL_RESERVE_ACCOUNT_CCID | NUMBER | (15) | Revaluation reserve account segment | |
| PERCENT_SALVAGE_VALUE | NUMBER | Not used | ||
| LIFE_EXTENSION_CEILING | NUMBER | Life extension ceiling | ||
| LIFE_EXTENSION_FACTOR | NUMBER | Life extension factor | ||
| DEFAULT_GROUP_ASSET_ID | NUMBER | (15) | Default group asset id | |
| BONUS_DEPRN_EXPENSE_ACCT | VARCHAR2 | (25) | Expense account segment column for bonus depreciation | |
| BONUS_DEPRN_RESERVE_ACCT | VARCHAR2 | (25) | Reserve account segment column for bonus depreciation | |
| BONUS_RESERVE_ACCT_CCID | NUMBER | Accumulated bonus depreciation ccid | ||
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether the record is active of inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code |
APPS.OKX_AST_CAT_BKS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary key column. Identifier for asset category |
| ID2 | VARCHAR2 | (36) | Primary key column. Book name concatenated with date placed in service. | |
| NAME | CHAR | (1) | Not used | |
| DESCRIPTION | CHAR | (1) | Not used | |
| CATEGORY_ID | NUMBER | (15) | Y | Identifier for asset category |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Y | Book name |
| START_DPIS | DATE | Y | First date placed in service to which this set of default depreciation rules apply | |
| END_DPIS | DATE | Last date placed in service to which this set of default depreciation rules apply | ||
| LIFE_IN_MONTHS | NUMBER | (4) | Life of an asset in this asset category and book | |
| DEPRN_METHOD | VARCHAR2 | (12) | Y | Depreciation method used by this asset category and book |
| PRORATE_CONVENTION_CODE | VARCHAR2 | (10) | Y | Depreciation prorate convention used by assets in this category and book |
| ITC_ELIGIBLE_FLAG | VARCHAR2 | (3) | Y | Indicates whether the assets in this book and category are eligible for ITC |
| USE_ITC_CEILINGS_FLAG | VARCHAR2 | (3) | Y | Indicates whetehr ITC ceilings are used by assets in this category and book |
| CEILING_NAME | VARCHAR2 | (30) | Name of the depreciation ceiling used | |
| BASIC_RATE | NUMBER | Basic depreciation rates used for flat-rate methods | ||
| ADJUSTED_RATE | NUMBER | Basic depreciation rates used for flat-rate methods | ||
| BONUS_RULE | VARCHAR2 | (30) | Bonus depreciation rule for flat rate methods | |
| DEPRECIATE_FLAG | VARCHAR2 | (3) | Y | Indicates whether assets in this category are depreciating or non depreciating assets |
| RETIREMENT_PRORATE_CONVENTION | VARCHAR2 | (10) | Y | Retirement prorate convention used by assets in this category and book |
| PRICE_INDEX_NAME | VARCHAR2 | (40) | Name of the price index | |
| USE_STL_RETIREMENTS_FLAG | VARCHAR2 | (3) | Y | Indicates whetehr a straightline retirement convention is used |
| STL_METHOD_CODE | VARCHAR2 | (12) | Straightline method code used for special tax retirements | |
| STL_LIFE_IN_MONTHS | NUMBER | (4) | Life of an asset for use with straight line method for special tax retirements | |
| SUBCOMPONENT_LIFE_RULE | VARCHAR2 | (13) | Rule by which to defualt the life of subcomponents in this category | |
| MINIMUM_LIFE_IN_MONTHS | NUMBER | (4) | Minimum life for subcomponents | |
| PRODUCTION_CAPACITY | NUMBER | Capacity for a units of production asset | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measure for a units of production asset | |
| CAPITAL_GAIN_THRESHOLD | NUMBER | Minimum time to hold an asset for Oracle Assets to report is as a capital gain on the form 4797 reports when you retire it | ||
| USE_DEPRN_LIMITS_FLAG | VARCHAR2 | (3) | Indicates whether to use depreciation limit for the book | |
| ALLOWED_DEPRN_LIMIT | NUMBER | Default depreciation limit as a percent of cost | ||
| SPECIAL_DEPRN_LIMIT_AMOUNT | NUMBER | Default depreciation limit as a flat amount, subtracted from the cost | ||
| PERCENT_SALVAGE_VALUE | NUMBER | Default salvage value percentage | ||
| CUA_LIFE_END_DATE | DATE | Not used | ||
| CUA_RULE_SET_ID | NUMBER | Not used |
APPS.OKX_AST_CT_BK_DFS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary key column. Unique identifier for the asset |
| ID2 | VARCHAR2 | (56) | Primary key column | |
| NAME | VARCHAR2 | (15) | Y | Asset number |
| DESCRIPTION | VARCHAR2 | (72) | Description | |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Y | Book name |
| ASSET_ID | NUMBER | (15) | Y | Unique identifier for the asset |
| DEPRN_RUN_DATE | DATE | Y | System date when depreciation was run | |
| DEPRN_AMOUNT | NUMBER | Y | Depreciation expense for this depreciation period | |
| YTD_DEPRN | NUMBER | Y | Year-to-date depreciation expense | |
| DEPRN_RESERVE | NUMBER | Y | Total depreciation taken since begining of asset life | |
| DEPRN_SOURCE_CODE | VARCHAR2 | (15) | Y | Indicates whether this record is created by thr depreciation BOOKS form or by running depreciation process |
| ADJUSTED_COST | NUMBER | Y | Depreciable basis | |
| BONUS_RATE | NUMBER | Bonus rate used to calculate depreciation | ||
| LTD_PRODUCTION | NUMBER | Life to date production for an units of production asset | ||
| PERIOD_COUNTER | NUMBER | (15) | Y | Depreciation period |
| PRODUCTION | NUMBER | Current period production for an units of production asset | ||
| REVAL_AMORTIZATION | NUMBER | Amount of revaluation reserve amortized during this period | ||
| REVAL_AMORTIZATION_BASIS | NUMBER | Revaluation reserve used in calculation amortization of revaluation reserve | ||
| REVAL_DEPRN_EXPENSE | NUMBER | Protion of depreciation expense dure to revaluation of asset cost | ||
| REVAL_RESERVE | NUMBER | For a period in which this asset was revalued: change in net book value due to revaluation of asset cost and sometimes also revaluation of depreciation reserve. For all other periods: revaluation reserve amount after depreciation run | ||
| YTD_PRODUCTION | NUMBER | Year-to-date production for a units of production asset | ||
| YTD_REVAL_DEPRN_EXPENSE | NUMBER | Year-to-date depreciation expense due to revaluation. Oracle Assets does not create any journal entries for this amount. It is for reporting only | ||
| PRIOR_FY_EXPENSE | NUMBER | Depreciation expense due to prior fiscal years | ||
| BONUS_DEPRN_AMOUNT | NUMBER | Bonus depreciation expense for this depreciation period. Amount included in deprn_amount | ||
| BONUS_YTD_DEPRN | NUMBER | Bonus year-to-date depreciation expense. Amount included in ytd_deprn | ||
| BONUS_DEPRN_RESERVE | NUMBER | Total bonus depreciation taken since the beginning of asset life. Amount included in deprn_reserve | ||
| PRIOR_FY_BONUS_EXPENSE | NUMBER | Bonus Depreciation expense due to prior fiscal years | ||
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | CHAR | (1) | Indicates whether record is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code |
APPS.OKX_AST_DPRTNS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary key column. Unique distribution identification number |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (15) | Y | Unique identifier for asset |
| DESCRIPTION | VARCHAR2 | (15) | Y | Book name |
| ASSET_ID | NUMBER | (15) | Y | Unique identifier for asset |
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Y | Book name |
| DISTRIBUTION_ID | NUMBER | (15) | Y | Unique identifier for distribution |
| UNITS_ASSIGNED | NUMBER | Y | Number of units assigned to the distribution | |
| CODE_COMBINATION_ID | NUMBER | (15) | Y | Depreciation expense account identification number |
| LOCATION_ID | NUMBER | (15) | Y | Location flexfield identification number |
| TRANSACTION_HEADER_ID_IN | NUMBER | (15) | Y | Identifies the transaction that created the distribution |
| START_DATE_ACTIVE | DATE | Y | Effective from date | |
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether the record is active or not | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
| ASSIGNED_TO | NUMBER | (15) | Employee identification number | |
| TRANSACTION_HEADER_ID_OUT | NUMBER | (15) | Identifies the transaction that made the distribution obsolete | |
| TRANSACTION_UNITS | NUMBER | Number of units involved in the transaction. Negative for the row from which the units were transferred away or retired. Positive for the row to which the units were transferred or added | ||
| RETIREMENT_ID | NUMBER | (15) | Identifies a retirement |
APPS.OKX_AST_DST_HST_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary key column. Unique identification number for each location defined in the table |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (216) | Concatenated segments of location key flexfield | |
| DESCRIPTION | CHAR | (1) | Description | |
| LOCATION_ID | NUMBER | (15) | Y | Unique identification number for each location defined in the table |
| SEGMENT1 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT2 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT6 | VARCHAR2 | (30) | Key flexfield segment | |
| SEGMENT7 | VARCHAR2 | (30) | Key flexfield segment | |
| SUMMARY_FLAG | VARCHAR2 | (1) | Y | Used by Application Object Library for flexfield definition |
| ENABLED_FLAG | VARCHAR2 | (1) | Y | Indicates whether this location is still active |
| START_DATE_ACTIVE | DATE | Date the location becomes active | ||
| END_DATE_ACTIVE | DATE | Date the location becomes inactive | ||
| STATUS | VARCHAR2 | (1) | Indicates whether the record is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measue code |
APPS.OKX_AST_LOCS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Bill of material unique identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| COMMON_BILL_SEQUENCE_ID | NUMBER | Y | Identifier of common bill | |
| ASSEMBLY_ITEM_ID | NUMBER | Inventory item identifier of manufactured assembly | ||
| ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
| ASSEMBLY_TYPE | NUMBER | Y | 1=Manufacturing bill 2=Engineering bill | |
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate designator code | |
| NAME | VARCHAR2 | (10) | Alternate BOM designator | |
| STATUS | CHAR | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (240) | Specific assembly component - description | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date record becomes inactive |
APPS.OKX_BILL_OF_MATERIALS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays transaction group definitions, business processes that group related transaction types.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Unique key to identify a transaction group |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (90) | Y | Name of the transaction group |
| DESCRIPTION | VARCHAR2 | (240) | Description of the transaction group | |
| STATUS | VARCHAR2 | (1) | Status | |
| START_DATE_ACTIVE | DATE | Specifies the start date for a transaction group if it is to be active within a certain period only | ||
| END_DATE_ACTIVE | DATE | Specifies the end date for a transaction group if it is required to be active only within the specified date range | ||
| INVENTORY_ITEM_ID | VARCHAR2 | (0) | Inventory item identifier | |
| ORGANIZATION_ID | VARCHAR2 | (0) | Organization identifier | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code |
APPS.OKX_BUS_PROCESSES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays transactions associated with transaction groups.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Unique key to identify a business process transaction |
| ID2 | NUMBER | (15) | Y | The transaction associated with a transaction group; foreign key to CS_TRANSACTION_TYPES |
| NAME | VARCHAR2 | (0) | Name | |
| STATUS | VARCHAR2 | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (0) | Description | |
| START_DATE_ACTIVE | DATE | Effective start date of the transaction associated with the transaction group | ||
| END_DATE_ACTIVE | DATE | Effective end date of the transaction associated with the transaction group | ||
| INVENTORY_ITEM_ID | VARCHAR2 | (0) | Inventory item identifier | |
| ORGANIZATION_ID | VARCHAR2 | (0) | Organization identifier | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code |
APPS.OKX_BUS_PROCESS_TXNS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (9) | Y | System generated person primary key from PER_PEOPLE_S. |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by. | |
| DESCRIPTION | VARCHAR2 | (301) | Description - buyer email and/or telephone | |
| CATEGORY_ID | NUMBER | Item category unique identifier | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Y | Foreign key to HR_ORGANIZATION_UNITS. |
| START_DATE_ACTIVE | DATE | Key Flexfield start date | ||
| END_DATE_ACTIVE | DATE | Key Flexfield end date | ||
| WORK_TELEPHONE | VARCHAR2 | (60) | Unsupported. | |
| EMAIL_ADDRESS | VARCHAR2 | (240) | Holds actual email identifier. | |
| STATUS | VARCHAR2 | (1) | Status | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (0) | Not used in this view | |
| WOMEN_OWNED_FLAG | VARCHAR2 | (0) | Not used in this view | |
| MINORITY_GROUP_LOOKUP | VARCHAR2 | (0) | Not used in this view | |
| PARTY_ID | VARCHAR2 | (0) | Contact's party identifier (Primary key) | |
| PARTY_ID2 | CHAR | (1) | Contact's party identifier ( Multi-part primary key) |
APPS.OKX_BUYERS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Category identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| STRUCTURE_ID | NUMBER | Y | Flexfield structure identifier | |
| NAME | VARCHAR2 | (240) | Key flexfield segment | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary Unit of Measure Code | |
| B_STATUS | VARCHAR2 | (1) | Y | Flag indicating whether segment combination is enabled |
| STATUS | VARCHAR2 | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (163) | Category translated description | |
| START_DATE_ACTIVE | DATE | Date segment combination becomes active | ||
| END_DATE_ACTIVE | DATE | Date segment combination becomes inactive |
APPS.OKX_CATEGORIES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Category set identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (30) | Y | Category set translated name |
| B_STATUS | VARCHAR2 | (1) | Y | Flag indicating category validation required |
| STATUS | VARCHAR2 | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (240) | Category set translated description | |
| STRUCTURE_ID | NUMBER | Y | Flexfield structure identifier | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | DATE | Date record becomes inactive |
APPS.OKX_CATEGORY_SETS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONFIG_HDR_ID | NUMBER | Y | Configuration header identifier | |
| CONFIG_REV_NBR | NUMBER | (9) | Y | Configuration revision number |
| CONFIG_ITEM_ID | NUMBER | Y | Identifier of the confiuration item. This ID has no relation to the inventory_item_id | |
| PARENT_CONFIG_ITEM_ID | NUMBER | Parent confiuration item identifier | ||
| INVENTORY_ITEM_ID | NUMBER | (9) | Identifier of the inventory item associated with the configuration item (if any) | |
| ORGANIZATION_ID | NUMBER | (9) | Identifier of the inventory organization associated with the configuration item (if any) | |
| COMPONENT_CODE | VARCHAR2 | (1200) | Component_code from bom_explosions | |
| QUANTITY | NUMBER | Configured quantity of the item | ||
| UOM_CODE | VARCHAR2 | (3) | Unit of measure code for the item | |
| BOM_ITEM_TYPE | NUMBER | (9) | BOM item type if applicable: 1 - model; 2 - option class; 4 - standard item. | |
| PS_NODE_ID | NUMBER | (15) | Associates this record with a Model structure node ('psnode') | |
| BOM_SORT_ORDER | VARCHAR2 | (4000) |
APPS.OKX_CONFIG_DETAILS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONFIG_HDR_ID | NUMBER | Y | Configuration header identifier | |
| CONFIG_REV_NBR | NUMBER | (9) | Y | Configuration revision number |
| CONFIG_ITEM_ID | NUMBER | Y | Unique identifier of configuration item | |
| UOM_CODE | VARCHAR2 | (3) | Code indicating the unit of measure for Quantity. Usually "Ea" indicating 'each'. | |
| PS_NODE_ID | NUMBER | (15) | Project structure node identifier | |
| VALUE_TYPE_CODE | NUMBER | Y | Value type code: EMPTY = 0; TEXT = 2; NUMERIC = 3; COMPONENT = 4; | |
| ROOT_BOM_CONFIG_ITEM_ID | NUMBER | (15) | Configuration item identifier of root bom item | |
| SEQUENCE_NBR | NUMBER | Sequence number of item as a child of its parent | ||
| ITEM_VAL | VARCHAR2 | (4000) | Item value | |
| INSTANCE_NBR | NUMBER | Component instance number | ||
| PARENT_CONFIG_ITEM_ID | NUMBER | Configuration item identifier of the parent item | ||
| COMPONENT_CODE | VARCHAR2 | (1200) | Alternative configuration item identifier. The component code is the concatenation of the inventory item ids of all the parent items part of the configuration, completed by the current inventory item id, in the following format: | |
| INVENTORY_ITEM_ID | NUMBER | (9) | Inventory item identifier of the configuration item | |
| ORGANIZATION_ID | NUMBER | (9) | Organization identifier | |
| COMPONENT_SEQUENCE_ID | NUMBER | (15) | Sequence identifier of the component instance | |
| DELETED_FLAG | VARCHAR2 | (1) | Y | Flag indicating if record was deleted by the user. If deleted_flag=1 the record will be purged. |
| EFF_FROM | DATE | Not currently used | ||
| EFF_TO | DATE | Not currently used | ||
| SECURITY_MASK | VARCHAR2 | (40) | Not currently used | |
| EFF_MASK | VARCHAR2 | (40) | Not currently used | |
| CHECKOUT_USER | VARCHAR2 | (40) | Not currently used | |
| USER_STR01 | VARCHAR2 | (255) | Standard extension field (string) | |
| USER_STR02 | VARCHAR2 | (255) | Standard extension field (string) | |
| USER_STR03 | VARCHAR2 | (255) | Standard extension field (string) | |
| USER_STR04 | VARCHAR2 | (255) | Standard extension field (string) | |
| USER_NUM01 | NUMBER | Standard extension field (numeric) | ||
| USER_NUM02 | NUMBER | Standard extension field (numeric) | ||
| USER_NUM03 | NUMBER | Standard extension field (numeric) | ||
| USER_NUM04 | NUMBER | Standard extension field (numeric) |
APPS.OKX_CONFIG_ITEMS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONFIGURATOR_SESSION_KEY | VARCHAR2 | (50) | Y | Configurator Session Key is used to group all of the pricing request records associated with a single session in the Configurator. |
| PS_NODE_ID | NUMBER | (15) | Associates this record with a Model structure node ('psnode') | |
| ITEM_KEY | VARCHAR2 | (2000) | Y | String carrying an identifier for an item for which pricing is to be determined. |
| ITEM_KEY_TYPE | NUMBER | (9) | Y | Code indicating the format for the ITEM_KEY field.1 - 'orig_sys_ref' format CC:EX:ORG:ITEM, CC is component code, EX is explosion type, ORG is organization ID, ITEM is inventory item ID; 2 - ps_node_id |
| QUANTITY | NUMBER | Quantity of this item for which pricing is requested | ||
| UOM_CODE | VARCHAR2 | (3) | Code indicating the unit of measure for Quantity. Usually "Ea" indicating 'each'. | |
| LIST_PRICE | NUMBER | Contains the list price applicable to the item in this record | ||
| SELLING_PRICE | NUMBER | Reports the calculated selling price for the requested item and quantity | ||
| MSG_DATA | VARCHAR2 | (2000) | Information returned from the pricing engine to the Configurator. GENERALLY UNUSED. | |
| SEQ_NBR | NUMBER | Y | Provide ordering capability for pricing records; PRIMARY KEY FIELD |
APPS.OKX_CONFIG_PRICING_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONTACT_POINT_ID | NUMBER | (15) | Y | Unique identifier of this contact point |
| CONTACT_POINT_TYPE | VARCHAR2 | (30) | Y | Lookup: contact_point_type phone, fax, e-mail, web, telex, edi |
| STATUS | VARCHAR2 | (30) | Y | Lookup: contact_point_status. Typically, active, inactive, delete. |
| OWNER_TABLE_NAME | VARCHAR2 | (30) | Y | Table storing the owner of the contact point |
| OWNER_TABLE_ID | NUMBER | (15) | Y | FK to OWNER_TABLE_NAME; identifies the owner of the contact point |
| EMAIL_FORMAT | VARCHAR2 | (30) | Indicates the preferred format for email addressed to this address. For example, 'html' or 'ascii'. | |
| EMAIL_ADDRESS | VARCHAR2 | (2000) | Email address | |
| TELEPHONE_TYPE | VARCHAR2 | (30) | Indicates whether this is a fixed or mobile phone. | |
| PHONE_AREA_CODE | VARCHAR2 | (10) | The area code within a country code. | |
| PHONE_COUNTRY_CODE | VARCHAR2 | (10) | Country code for international phone numbers. | |
| PHONE_NUMBER | VARCHAR2 | (40) | A telephone number formatted in the local format. The number should not include area code, country code, or extension. | |
| PHONE_EXTENSION | VARCHAR2 | (20) | The additional number handled by an internal telephone system that is addressed after contacting the individual's internal telephone system. | |
| CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | Y | Source of data content |
| PRIMARY_FLAG | VARCHAR2 | (1) | ||
| PHONE_LINE_TYPE | VARCHAR2 | (30) |
APPS.OKX_CONTACT_POINTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary key column. unique identifier for the contract | |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (241) | User assigned contract number | |
| DESCRIPTION | VARCHAR2 | (600) | User assigned contract description | |
| START_DATE_ACTIVE | DATE | Contract effective from date | ||
| END_DATE_ACTIVE | DATE | Contract effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether the contract record is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
| SCS_CODE | VARCHAR2 | (30) | Y | Contract subclass code |
| STS_CODE | VARCHAR2 | (30) | Y | Contract status code |
| ORG_ID | NUMBER | Y | Unique identifier for contract authoring operating unit | |
| INV_ORG_ID | NUMBER | Y | Unique identifier for contract inventory organization | |
| BUY_OR_SELL | VARCHAR2 | (3) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| CHR_TYPE | VARCHAR2 | (30) | Y | Contract type |
APPS.OKX_CONTRACTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | VARCHAR2 | (30) | Y | Conversion type name |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (30) | Y | Conversion type |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date record becomes inactive | |
| STATUS | CHAR | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (240) | Conversion type description | |
| USER_CONVERSION_TYPE | VARCHAR2 | (30) | Y | Conversion type user defined name |
APPS.OKX_CONVERSION_TYPES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | The identifier of the counter. | ||
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| COUNTER_ID | NUMBER | Counter identifier | ||
| COUNTER_GROUP_ID | NUMBER | The identifier of the counter group to which the counter belongs | ||
| NAME | VARCHAR2 | (80) | Counter Name | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| TYPE | VARCHAR2 | (30) | Indicates whether the counter is a regular, formula-based, time-based or a SQL-derived counter. | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | DATE | Date record becomes inactive | ||
| CREATED_FROM_COUNTER_TMPL_ID | NUMBER | Created from counter template identifier | ||
| SOURCE_COUNTER_ID | NUMBER | Source counter identifier | ||
| INITIAL_READING | NUMBER | The initial reading of a counter template or an instance. Valid only for regular counters. | ||
| UOM_CODE | VARCHAR2 | (3) | The unit of measure of the counter reading. | |
| USAGE_ITEM_ID | NUMBER | The item that keeps track of the usage of this counter. Can only be the item which has the USAGE_ITEM_FLAG set to 'Y'. | ||
| CTR_VAL_MAX_SEQ_NO | NUMBER | The current maximum sequence number of the counter values being updated in this log. | ||
| COUNTER_VALUE_ID | NUMBER | The identifier of the counter value. | ||
| VALUE_TIMESTAMP | DATE | The date on which this counter reading was taken (maybe different from the date on which the reading is enteerd in the system). | ||
| COUNTER_READING | NUMBER | The counter reading. | ||
| NET_READING | NUMBER | Net reading | ||
| STATUS | VARCHAR2 | (1) | Status | |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary UOM code, needed for UOMs list for lines. |
A public view which may be useful for custom reporting or other data requirements.
Displays the counter groups. The records can be one of the following : the counter group templates or the counter group instances instantiated from a template.
The counter group templates are the ones attached to a master entity. In 11i, the only master entities supported are the serviceable products and service items from the item master.
The counter group instances are the ones attached to the instance of the master entity. The instances of the item master can either be a product in the installed base or a contract line in Oracle Contracts. Counter group instances are automatically instantiated when the product is instantiated in the installed base or a contract line is created in Contracts.
These counter group instances will have the CREATED_FROM_CTR_GRP_TMPL_ID as the identifier of the template.
The counter group templates will have the CREATE_FROM_CTR_GRP_TMPL_ID as NULL.
When the counter group is instantiated from a template, the SOURCE_COUNTER_GROUP_ID is also populated with the identifier of the template. The attributes of this counter group instance can then be over-written. When it is over-written, the SOURCE_COUNTER_GROUP_ID becomes NULL indicating that any changes to the template will not cascade to this counter group.
The ASSOCIATION_TYPE indicates the formula capabilities of the counter group.
For a counter group, if the value of this column is 'PROD_ITEM' or 'SVC_ITEM', then the formula counters within the counter group can only be based on the counters within that counter group.
If it is 'BOM' then the formula counters can be based on any counter within the configuration.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COUNTER_GROUP_ID | NUMBER | Counter Group unique identifier | ||
| NAME | VARCHAR2 | (100) | Counter group name | |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| TEMPLATE_FLAG | VARCHAR2 | (1) | Counter group template flag | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | DATE | Date record becomes inactive | ||
| ASSOCIATION_TYPE | VARCHAR2 | (30) | See table description. | |
| SOURCE_OBJECT_CODE | VARCHAR2 | (30) | Valid only for instances. Can be either 'CP' or 'CTR_CONTRACT_LINE'. | |
| SOURCE_OBJECT_ID | NUMBER | Mandatory only for instances. This must be valid for a particular SOURCE_OBJECT_CODE. | ||
| CREATED_FROM_CTR_GRP_TMPL_ID | NUMBER | See table description. | ||
| SOURCE_COUNTER_GROUP_ID | NUMBER | See table description. |
A public view which may be useful for custom reporting or other data requirements.
Displays the logs of counter updates within a counter group.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COUNTER_GRP_LOG_ID | NUMBER | Y | Identifier of the counter group log. | |
| COUNTER_GROUP_ID | NUMBER | Y | Identifier of the counter group to which the log belongs. | |
| VALUE_TIMESTAMP | DATE | Y | The timestamp of the log. |
APPS.OKX_COUNTER_GRP_LOG_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays the historical readings of counters. A reading has to be considered as a counter instance associated to a sequence number.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COUNTER_VALUE_ID | NUMBER | Y | The identifier of the counter value. | |
| COUNTER_GRP_LOG_ID | NUMBER | The identifier of the counter group log to which this value belongs. | ||
| COUNTER_ID | NUMBER | Y | The identifier of the counter to which this value belongs. | |
| VALUE_TIMESTAMP | DATE | Y | The date on which this counter reading was taken (maybe different from the date on which the reading is enteerd in the system). | |
| SEQ_NO | NUMBER | The sequence number. (Install Base obsoleted this column) | ||
| COUNTER_READING | NUMBER | Y | The counter reading. | |
| RESET_FLAG | VARCHAR2 | (1) | Indicates whether this counter reading is a reset reading or not. | |
| RESET_REASON | VARCHAR2 | (255) | Mandatory only if the RESET_FLAG = 'Y'. | |
| PRE_RESET_LAST_RDG | NUMBER | Mandatory only if the RESET_FLAG = 'Y'. Will be defaulted from the ROLLOVER_LAST_READING for that counter. | ||
| POST_RESET_FIRST_RDG | NUMBER | Mandatory only if the RESET_FLAG = 'Y'. Will be defaulted from the ROLLOVER_FIRST_READING for that counter. | ||
| MISC_READING_TYPE | VARCHAR2 | (30) | A lookup for different types of miscellaneous readings. | |
| MISC_READING | NUMBER | Valid and mandatory only if MISC_READING_TYPE IS NOT NULL. | ||
| PREV_NET_CURR_DIFF | NUMBER | Difference between counter reading and net reading of previous reading. (Install Base obsoleted this column) | ||
| NET_READING | NUMBER | Y | Net Reading | |
| PREV_NET_READING | NUMBER | Previous net reading |
APPS.OKX_COUNTER_VALUES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | VARCHAR2 | (2) | Y | The code for the territory |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (80) | Y | The short name that stands for the territory |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| ISO_NUMERIC_CODE | VARCHAR2 | (3) | The ISO numeric entity code | |
| STATUS | CHAR | (1) | Status | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date record becomes inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Used for lines entry, list for UOM. |
APPS.OKX_COUNTRIES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary key column. Unique identifier for financial asset line | |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (150) | User assigned name of the fianancial asset | |
| DESCRIPTION | VARCHAR2 | (1995) | User assigned description of the financial asset | |
| CHR_ID | NUMBER | Y | Unique identifier for contract number | |
| DNZ_CHR_ID | NUMBER | Y | Denormalized unique identifier for contract | |
| LTY_CODE | VARCHAR2 | (30) | Y | Line style code |
| LSE_TYPE | VARCHAR2 | (10) | Y | Indicates whether asset line is top line (TLS) or sub-line (SLS) |
| LINE_NUMBER | VARCHAR2 | (150) | Y | Asset line number |
| DATE_TERMINATED | DATE | Date on which financial asset was terminated | ||
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether financial asset is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
| CONTRACT_STATUS | VARCHAR2 | (30) | Y | Status of the contract |
| AUTHORING_ORG_ID | NUMBER | Y | Contract authoring operating unit identifier | |
| INV_ORGANIZATION_ID | NUMBER | Y | Inventory organization identifier | |
| OKL_LINE_STATUS | VARCHAR2 | (30) | Y | Contract Lne Satus Code |
| OKC_LINE_STATUS | VARCHAR2 | (30) | Y | STE_CODE from OKC_STATUSES_B for Line status |
APPS.OKX_COVERED_ASSET_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | ||
| ID2 | CHAR | (1) | ||
| NAME | VARCHAR2 | (240) | ||
| DESCRIPTION | VARCHAR2 | (150) | Y | |
| ITEM_DESCRIPTION | VARCHAR2 | (1995) | Item description. | |
| COMMENTS | VARCHAR2 | (1995) | User entered comment. | |
| CHR_ID | NUMBER | Contract ID. Denormalized for performance. | ||
| DNZ_CHR_ID | NUMBER | Y | Contract ID. Denormalized for performance. | |
| LINE_NUMBER | VARCHAR2 | (150) | Y | Sequencial line number. |
| DATE_TERMINATED | DATE | Date contract was terminated. | ||
| START_DATE_ACTIVE | DATE | The beginning of the active period, one second after midnight on the date indicated. | ||
| END_DATE_ACTIVE | DATE | The end of the active period, one second before midnight on the date indicated. | ||
| STATUS | VARCHAR2 | (1) | ||
| INVENTORY_ITEM_ID | VARCHAR2 | (40) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view. | |
| ORGANIZATION_ID | NUMBER | |||
| QUANTITY | NUMBER | Number of items. | ||
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Unit of Measure code. | |
| ITEM_NAME | VARCHAR2 | (240) | Item name. | |
| SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | (1) | Y | Indicates whether the item is serviceable by other service-type items and can have service requests reported against it |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) |
APPS.OKX_COVERED_LINES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Disiplays associations of counter groups for inventory items. These associations are used later to autoinstantiate counters.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CTR_ASSOCIATION_ID | NUMBER | Y | Primary key | |
| COUNTER_GROUP_ID | NUMBER | Counter group identifier | ||
| SOURCE_OBJECT_ID | NUMBER | Y | Source object identifier |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Customer Account Identifier. |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| PARTY_ID | NUMBER | (15) | Y | A foreign key to the HZ_PARTY table. |
| NAME | VARCHAR2 | (360) | A user defined name for the account. | |
| DESCRIPTION | VARCHAR2 | (30) | Y | Account Number |
| CUSTOMER_TYPE | VARCHAR2 | (30) | Receivables lookup code for ?CUSTOMER_TYPE? (?I? for internal customers; ?R? for external customers) | |
| B_STATUS | VARCHAR2 | (1) | Y | Customer status flag. Lookup code for CODE_STATUS |
| STATUS | VARCHAR2 | (1) | Y | Status |
| COTERMINATE_DAY_MONTH | VARCHAR2 | (6) | Identifies the date on which services ordered by the customer will end. Values for this column will take the form DD-MON. | |
| ACCOUNT_ESTABLISHED_DATE | DATE | Date when Account is established | ||
| CUSTOMER_CLASS_CODE | VARCHAR2 | (30) | Customer class indentifier | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Used for lines entry, list for UOM. | |
| SALES_CHANNEL_CODE | VARCHAR2 | (30) | ||
| GSA_INDICATOR | VARCHAR2 | (1) | ||
| EMAIL_ADDRESS | VARCHAR2 | (2000) |
APPS.OKX_CUSTOMER_ACCOUNTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Unique identifier for a product in the installed base | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (240) | Key flexfield segment | |
| DESCRIPTION | VARCHAR2 | (40) | Item translated description | |
| STATUS | VARCHAR2 | (1) | Status | |
| INVENTORY_ITEM_ID | NUMBER | Y | Product identifier | |
| ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure code | |
| CUSTOMER_ID | NUMBER | Customer identifier | ||
| INSTALL_SITE_USE_ID | NUMBER | Identifies the location where product is installed | ||
| SYSTEM_ID | NUMBER | Identifies the system to which the product belongs | ||
| QUANTITY | NUMBER | Y | Sales order information: quantity of product | |
| LOT_NUMBER | VARCHAR2 | (80) | Lot number of product shipped | |
| CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Serial number of product shipped | |
| REFERENCE_NUMBER | VARCHAR2 | (30) | Y | Unique reference for a customer product |
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Y | Sales order information: unit of measure of product |
| UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| ORG_ID | NUMBER | Operating unit identifier | ||
| CONFIG_PARENT_ID | NUMBER | The customer product ID of the immediate parent customer product | ||
| START_DATE_ACTIVE | DATE | Effective from | ||
| END_DATE_ACTIVE | DATE | Effective till | ||
| CREATED_MANUALLY_FLAG | VARCHAR2 | (1) | Flag indicating whether record was created manually or imported from an "order management" system. | |
| MOST_RECENT_FLAG | CHAR | (1) | Flags the most recent of a set of related (i.e., upgraded, etc.) customer products | |
| CURRENT_CP_REVISION_ID | VARCHAR2 | (3) | Identifies the current revision. | |
| TYPE_CODE | VARCHAR2 | (30) | Product type | |
| PRODUCT_AGREEMENT_ID | NUMBER | Product agreement identifier. | ||
| INSTALLATION_DATE | DATE | Date of installation of product at customer site | ||
| ORIGINAL_ORDER_LINE_ID | NUMBER | Holds the link to the sales order information. | ||
| ORIGINAL_LINE_SERV_DETAIL_ID | VARCHAR2 | (0) | The identifier of the installation details record from the sales order. | |
| ORIGINAL_NET_AMOUNT | NUMBER | The amount of the product in the Installed Base. Maybe different from the amount in the order line in case of splits, etc. | ||
| SHIP_TO_SITE_USE_ID | NUMBER | Identifies the location to which product was shipped | ||
| BILL_TO_SITE_USE_ID | NUMBER | Identifies the location to which product was invoiced | ||
| SHIPPED_FLAG | VARCHAR2 | (1) | Flag indicating whether product has been shipped | |
| DELIVERED_FLAG | VARCHAR2 | (0) | Flag indicating whether product has reached the customer | |
| PARENT_CP_ID | VARCHAR2 | (0) | See table description | |
| CUSTOMER_PRODUCT_STATUS_ID | NUMBER | Y | Status identifier of a customer product | |
| SHIPPED_DATE | DATE | Date product shipped to customer | ||
| RETURN_BY_DATE | DATE | The date by which the product should be returned | ||
| ACTUAL_RETURNED_DATE | DATE | The actual date on which the product was returned | ||
| RMA_LINE_ID | VARCHAR2 | (0) | Identifies the RMA line created for the return of the product | |
| SPLIT_FLAG | VARCHAR2 | (0) | Flag that gets set if the product has been split from/into another product(s) | |
| CONFIG_ENABLED_FLAG | CHAR | (1) | Determines if Configuration Management is enabled | |
| CONFIG_START_DATE | DATE | The date when a configuration type becomes active | ||
| CONFIG_END_DATE | DATE | The date when a configuration type becomes inactive | ||
| CONFIG_ROOT_ID | NUMBER | The customer product ID of the top most parent of the tree that includes the current product | ||
| CONFIG_TYPE | VARCHAR2 | (30) | The configuration type of the customer product | |
| PLATFORM_VERSION_ID | VARCHAR2 | (0) | Applicable only for software products in the installed base. Identifier of the platform version on which this product exists in the installed base. | |
| CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ORIGINAL_ORDER_CURRENCY_CODE | VARCHAR2 | (15) | ||
| PRICING_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE21 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE22 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE23 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE24 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE25 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE26 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE27 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE28 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE29 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE30 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE31 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE32 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE33 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE34 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE35 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE36 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE37 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE38 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE39 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE40 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE41 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE42 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE43 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE44 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE45 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE46 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE47 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE48 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE49 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE50 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE51 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE52 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE53 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE54 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE55 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE56 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE57 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE58 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE59 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE60 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE61 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE62 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE63 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE64 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE65 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE66 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE67 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE68 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE69 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE70 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE71 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE72 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE73 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE74 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE75 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE76 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE77 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE78 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE79 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE80 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE81 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE82 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE83 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE84 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE85 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE86 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE87 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE88 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE89 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE90 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE91 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE92 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE93 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE94 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE95 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE96 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE97 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE98 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE99 | VARCHAR2 | (150) | ||
| PRICING_ATTRIBUTE100 | VARCHAR2 | (150) | ||
| PRICING_CONTEXT | VARCHAR2 | (30) |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | |
| ID2 | CHAR | (1) | ||
| NAME | NUMBER | (15) | Y | |
| DESCRIPTION | NUMBER | (15) | Y | |
| STATUS | VARCHAR2 | (1) | Y | |
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| CUST_ACCOUNT_ID | NUMBER | (15) | Y | |
| PROFILE_CLASS_ID | NUMBER | (15) | ||
| SITE_USE_ID | NUMBER | (15) | ||
| ACCOUNT_STATUS | VARCHAR2 | (30) |
APPS.OKX_CUSTOMER_PROFILES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays customer's invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUSTOMER_TRX_ID | NUMBER | (15) | Y | Invoice identifier |
| TRX_NUMBER | VARCHAR2 | (20) | Y | Transaction number |
| CUST_TRX_TYPE_ID | NUMBER | (15) | Y | Transaction type identifier |
| TRX_DATE | DATE | Y | Invoice date | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set of books identifier |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier |
APPS.OKX_CUSTOMER_TRX_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUST_ACCOUNT_ID | NUMBER | (15) | Y | ID of first customer account in relationship. FK to HZ_CUST_ACCOUNTS_ALL |
| RELATED_CUST_ACCOUNT_ID | NUMBER | (15) | Y | ID of second customer account in relationship. FK to HZ_CUST_ACCOUNTS_ALL |
| RELATIONSHIP_TYPE | VARCHAR2 | (30) | Revenue Accounting code for 'RELATIONSHIP_TYPE' | |
| CUSTOMER_RECIPROCAL_FLAG | VARCHAR2 | (1) | Y | Y or N indicates whether this relationship is reciprocal |
| STATUS | VARCHAR2 | (1) | Y | Customer relationship status flag; lookup code for 'CODE_STATUS' |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier |
APPS.OKX_CUST_ACCT_RELATE_ALL_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | |
| ID2 | CHAR | (1) | ||
| NAME | VARCHAR2 | (240) | ||
| DESCRIPTION | VARCHAR2 | (30) | Y | |
| STATUS | VARCHAR2 | (1) | Y | |
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| CUSTOMER_ID | NUMBER | (15) | Y | |
| RELATIONSHIP_TYPE | VARCHAR2 | (30) | ||
| CUSTOMER_RECIPROCAL_FLAG | VARCHAR2 | (1) | Y | |
| ORG_ID | NUMBER | (15) | ||
| BILL_TO_FLAG | VARCHAR2 | (1) | ||
| SHIP_TO_FLAG | VARCHAR2 | (1) | ||
| PARTY_ID | NUMBER | (15) | Y |
APPS.OKX_CUST_ACCT_RELATE_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Unique identifier of the party playing a contact role in the customer account |
| ID2 | CHAR | (1) | Not used | |
| PARTY_ID | NUMBER | (15) | Y | Contact's party identifier (Primary key) |
| PARTY_ID2 | CHAR | (1) | Contact's party identifier (Multi-part primary key) | |
| DESCRIPTION | VARCHAR2 | (40) | Formatted address | |
| NAME | VARCHAR2 | (92) | Party name for the contact | |
| CUST_ACCT_ID | NUMBER | (15) | Y | FK to HZ_CUST_ACCOUNTS_ALL |
| ROLE_TYPE | VARCHAR2 | (30) | Y | Role type |
| CUST_ACCT_SITE_ID | NUMBER | (15) | Customer account site identifier. FK to HZ_CUST_ACCT_SITES_ALL | |
| STATUS | VARCHAR2 | (1) | Status | |
| EMAIL_ADDRESS | VARCHAR2 | (2000) | ||
| CONTACT_REFERENCE_ID | VARCHAR2 | (240) | Y | |
| JOB_TITLE | VARCHAR2 | (100) | ||
| DEPARTMENT | VARCHAR2 | (60) | ||
| ADDRESS | VARCHAR2 | (4000) | ||
| TITLE | VARCHAR2 | (30) | ||
| PERSON_PARTY_ID | NUMBER | (15) | Y |
APPS.OKX_CUST_CONTACTS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays all possible statuses that can be assigned to products in the installed base.
Pre-defined statuses have SEEDED_FLAG set to Y.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUSTOMER_PRODUCT_STATUS_ID | NUMBER | Y | Status identifier | |
| NAME | VARCHAR2 | (50) | Y | Status name |
| CANCELLED_FLAG | VARCHAR2 | (0) | Products having this status are deemed cancelled if this flag is set | |
| TERMINATED_FLAG | VARCHAR2 | (1) | Products having this status are deemed terminated if this flag is set | |
| STATUS_CHANGE_ALLOWED_FLAG | VARCHAR2 | (1) | The status of products having this status cannot be changed if this flag is set | |
| INCIDENT_ALLOWED_FLAG | VARCHAR2 | (1) | Indicates whether service requests can be logged for products having this status | |
| SERVICE_ORDER_ALLOWED_FLAG | VARCHAR2 | (1) | Indicates whether products having this status can have new service ordered or recorded against them | |
| SEEDED_FLAG | VARCHAR2 | (1) | Flag indicating pre-defined status | |
| SEEDED_STATUS_UPDATEABLE_FLAG | VARCHAR2 | (1) | Not currently used | |
| UPDATEABLE_FLAG | VARCHAR2 | (1) | Flag indicating whether status is updatable | |
| DESCRIPTION | VARCHAR2 | (240) | Status description | |
| START_DATE_ACTIVE | DATE | Effectivity start date | ||
| END_DATE_ACTIVE | DATE | Effectivity end date | ||
| OBJECT_VERSION_NUMBER | NUMBER | Y | Sequential number used for database locking control | |
| CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column |
APPS.OKX_CUST_PROD_STATUSES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUSTOMER_PRODUCT_ID | NUMBER | Y | Unique identifier for a product in the installed base | |
| CUSTOMER_ID | NUMBER | Identifier of the customer account. | ||
| INVENTORY_ITEM_ID | NUMBER | Y | Product identifier. | |
| LOT_NUMBER | VARCHAR2 | (80) | Lot number of product shipped | |
| CREATED_MANUALLY_FLAG | VARCHAR2 | (1) | Flag indicating whether record was created manually or imported from an "order management" system. | |
| MOST_RECENT_FLAG | CHAR | (1) | Flags the most recent of a set of related (i.e., upgraded, etc.) customer products | |
| CURRENT_CP_REVISION_I | VARCHAR2 | (3) | Identifies the current revision. | |
| CURRENT_SERIAL_NUMBER | VARCHAR2 | (30) | Serial number of product shipped | |
| TYPE_CODE | VARCHAR2 | (30) | Product type | |
| SYSTEM_ID | NUMBER | Identifies the system to which the product belongs | ||
| PRODUCT_AGREEMENT_ID | NUMBER | Product agreement identifier. | ||
| INSTALLATION_DATE | DATE | Date of installation of product at customer site | ||
| ORIGINAL_ORDER_LINE_I | NUMBER | Holds the link to the sales order information. | ||
| ORIGINAL_LINE_SERV_DE | VARCHAR2 | (0) | The identifier of the installation details record from the sales order. | |
| ORIGINAL_NET_AMOUNT | NUMBER | The amount of the product in the Installed Base. Maybe different from the amount in the order line in case of splits, etc. | ||
| SHIP_TO_SITE_USE_ID | NUMBER | Identifies the location to which product was shipped | ||
| BILL_TO_SITE_USE_ID | NUMBER | Identifies the location to which product was invoiced | ||
| INSTALL_SITE_USE_ID | NUMBER | Identifies the location where product is installed | ||
| QUANTITY | NUMBER | Y | Quantity of product. | |
| SHIPPED_FLAG | VARCHAR2 | (1) | Flag indicating whether product has been shipped | |
| DELIVERED_FLAG | VARCHAR2 | (0) | Flag indicating whether product has reached the customer | |
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Y | unit of measure of product |
| PARENT_CP_ID | VARCHAR2 | (0) | See table description | |
| CUSTOMER_PRODUCT_STAT | NUMBER | Y | Status identifier of a customer product | |
| SHIPPED_DATE | DATE | Date product shipped to customer | ||
| ORG_ID | NUMBER | Operating unit identifier | ||
| REFERENCE_NUMBER | VARCHAR2 | (30) | Y | Unique reference for a customer product |
| RETURN_BY_DATE | DATE | The date by which the product should be returned | ||
| ACTUAL_RETURNED_DATE | DATE | The actual date on which the product was returned | ||
| RMA_LINE_ID | VARCHAR2 | (0) | Identifies the RMA line created for the return of the product | |
| SPLIT_FLAG | VARCHAR2 | (0) | Flag that gets set if the product has been split from/into another product(s) | |
| PROJECT_ID | NUMBER | Project identifier | ||
| TASK_ID | NUMBER | Task identifier | ||
| CONFIG_ENABLED_FLAG | CHAR | (1) | Determines if Configuration Management is enabled | |
| CONFIG_START_DATE | DATE | The date when a configuration type becomes active | ||
| CONFIG_END_DATE | DATE | The date when a configuration type becomes inactive | ||
| CONFIG_ROOT_ID | NUMBER | The customer product ID of the top most parent of the tree that includes the current product | ||
| CONFIG_PARENT_ID | NUMBER | The customer product ID of the immediate parent customer product | ||
| CONFIG_TYPE | VARCHAR2 | (30) | The configuration type of the customer product | |
| PLATFORM_VERSION_ID | VARCHAR2 | (0) | Applicable only for software products in the installed base. Identifier of the platform version on which this product exists in the installed base. | |
| START_DATE_ACTIVE | DATE | Effective from | ||
| END_DATE_ACTIVE | DATE | Effective till | ||
| OBJECT_VERSION_NUMBER | NUMBER | Y | Sequential number used for database locking control | |
| CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ORIGINAL_ORDER_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of the amount of product in Installed Base | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE2 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE3 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE4 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE5 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE6 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE7 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE8 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE9 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE10 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE11 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE12 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE13 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE14 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE15 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE16 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE17 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE18 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE19 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE20 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE21 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE22 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE23 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE24 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE25 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE26 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE27 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE28 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE29 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE30 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE31 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE32 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE33 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE34 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE35 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE36 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE37 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE38 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE39 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE40 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE41 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE42 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE43 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE44 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE45 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE46 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE47 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE48 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE49 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE50 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE51 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE52 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE53 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE54 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE55 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE56 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE57 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE58 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE59 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE60 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE61 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE62 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE63 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE64 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE65 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE66 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE67 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE68 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE69 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE70 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE71 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE72 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE73 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE74 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE75 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE76 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE77 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE78 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE79 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE80 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE81 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE82 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE83 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE84 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE85 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE86 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE87 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE88 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE89 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE90 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE91 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE92 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE93 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE94 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE95 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE96 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE97 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE98 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE99 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_ATTRIBUTE100 | VARCHAR2 | (150) | Pricing Attribute | |
| PRICING_CONTEXT | VARCHAR2 | (30) | Pricing Context |
APPS.OKX_CUST_PROD_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Unique identifier of the party playing a contact role in the customer account |
| ID2 | CHAR | (1) | Not used | |
| PARTY_ID | NUMBER | (15) | Y | Contact's party identifier (Primary key) |
| PARTY_ID2 | CHAR | (1) | Contact's party identifier (Multi-part primary key) | |
| DESCRIPTION | VARCHAR2 | (360) | Y | Formatted address |
| NAME | VARCHAR2 | (360) | Y | Party name for the contact |
| EMAIL_ADDRESS | VARCHAR2 | (2000) | Contact email address | |
| CUST_ACCT_ID | NUMBER | (15) | Y | FK to HZ_CUST_ACCOUNTS_ALL |
| ROLE_TYPE | VARCHAR2 | (30) | Y | Role type |
| CUST_ACCT_SITE_ID | NUMBER | (15) | Customer account site identifier. FK to HZ_CUST_ACCT_SITES_ALL | |
| RESPONSIBILITY_TYPE | VARCHAR2 | (30) | Y | Lookup for Responsibility Type |
| PRIMARY_FLAG | VARCHAR2 | (1) | "Y" if this is the primary responsibility for the party for the role played by the party in the account. | |
| STATUS | VARCHAR2 | (1) | Y | Party relationship status flag |
APPS.OKX_CUST_ROLE_RESP_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Site use identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| CUST_ACCT_SITE_ID | NUMBER | (15) | Y | Customer Site identifier |
| CUST_ACCOUNT_ID | NUMBER | (15) | Y | Customer Account identifier. FK to HZ_CUST_ACCOUNTS_ALL |
| PARTY_SITE_ID | NUMBER | (15) | Y | Party Site identifier. FK to HZ_PARTY_SITES |
| PARTY_ID | NUMBER | (15) | Y | Party identifier and foreign key to HZ_PARTIES. |
| PARTY_SITE_NAME | VARCHAR2 | (240) | A user defined name for the site | |
| STATUS | VARCHAR2 | (1) | Y | Status |
| LOCATION_ID | NUMBER | (15) | Y | Location Identifier |
| NAME | VARCHAR2 | (240) | Site use identifier | |
| COUNTRY | VARCHAR2 | (60) | Y | FND_TERRITORY.TERRITORY_CODE |
| ADDRESS1 | VARCHAR2 | (240) | Y | First line for address |
| ADDRESS2 | VARCHAR2 | (240) | Second line for address | |
| ADDRESS3 | VARCHAR2 | (240) | Third line for address | |
| ADDRESS4 | VARCHAR2 | (240) | Fourth line for address | |
| CITY | VARCHAR2 | (60) | City | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
| STATE | VARCHAR2 | (60) | State | |
| PROVINCE | VARCHAR2 | (60) | Province | |
| COUNTY | VARCHAR2 | (60) | County | |
| LOCATION_DESCRIPTION | VARCHAR2 | (2000) | An extensive description of the location | |
| DESCRIPTION | VARCHAR2 | (4000) | Formatted address, country specific | |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Used for lines entry, list for UOM. | |
| ADDRESSEE | VARCHAR2 | (360) | addressee information |
APPS.OKX_CUST_SITES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Site use identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| CUST_ACCT_SITE_ID | NUMBER | (15) | Y | Customer Site identifier |
| CUST_ACCOUNT_ID | NUMBER | (15) | Y | Customer Account identifier. FK to HZ_CUST_ACCOUNTS_ALL |
| PARTY_SITE_ID | NUMBER | (15) | Y | Party Site identifier. FK to HZ_PARTY_SITES |
| PARTY_ID | NUMBER | (15) | Y | Party identifier and foreign key to HZ_PARTIES. |
| PARTY_SITE_NAME | VARCHAR2 | (240) | A user defined name for the site | |
| SITE_USE_CODE | VARCHAR2 | (30) | Y | Business Purpose |
| B_STATUS | VARCHAR2 | (1) | Y | Site use status flag; lookup code for 'CODE_STATUS' |
| STATUS | VARCHAR2 | (1) | Y | Status |
| CUST_ACCT_SITE_STATUS | VARCHAR2 | (1) | Y | Customer Status flag. Receivables lookup code for CODE_STATUS |
| LOCATION_ID | NUMBER | (15) | Y | Location Identifier |
| NAME | VARCHAR2 | (40) | Y | Site use identifier |
| COUNTRY | VARCHAR2 | (60) | Y | FND_TERRITORY.TERRITORY_CODE |
| ADDRESS1 | VARCHAR2 | (240) | Y | First line for address |
| ADDRESS2 | VARCHAR2 | (240) | Second line for address | |
| ADDRESS3 | VARCHAR2 | (240) | Third line for address | |
| ADDRESS4 | VARCHAR2 | (240) | Fourth line for address | |
| CITY | VARCHAR2 | (60) | City | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
| STATE | VARCHAR2 | (60) | State | |
| PROVINCE | VARCHAR2 | (60) | Province | |
| COUNTY | VARCHAR2 | (60) | County | |
| LOCATION_DESCRIPTION | VARCHAR2 | (2000) | An extensive description of the location | |
| IDENTIFYING_ADDRESS_FLAG | VARCHAR2 | (1) | Y | |
| DESCRIPTION | VARCHAR2 | (4000) | Formatted address, country specific | |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Used for lines entry, list for UOM. | |
| PAYMENT_TERM_ID | NUMBER | (15) |
A public view which may be useful for custom reporting or other data requirements.
Displays information about invoice, debit memo, credit memo, and commitment lines.
Invoice, debit memo, credit memo, and commitment lines are distinguished by the transaction type of the corresponding CUSTOMER_TRX_ID in the RA_CUSTOMER_TRX_ALL table.
An invoice may have different transaction lines distinguished by the different LINE_TYPE values.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Set of books identifier |
| CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Y | Invoice line identifier |
| CUSTOMER_TRX_ID | NUMBER | (15) | Y | Invoice identifier |
| INTERFACE_LINE_CONTEXT | VARCHAR2 | (30) | Interface line context | |
| INTERFACE_LINE_ATTRIBUTE1 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE3 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE4 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE6 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE7 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE8 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE10 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE11 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE12 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE13 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE14 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE15 | VARCHAR2 | (150) | Interface line attribute value | |
| INTERFACE_LINE_ATTRIBUTE9 | VARCHAR2 | (150) | Interface line attribute value | |
| LINE_TYPE | VARCHAR2 | (20) | Y | Receivables lookup code for STD_LINE_TYPE |
| EXTENDED_AMOUNT | NUMBER | Y | Transaction line amount | |
| LINK_TO_CUST_TRX_LINE_ID | NUMBER | (15) | Link to transaction line identifier |
APPS.OKX_CUST_TRX_LINES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays information about each transaction type used for invoices, commitments and credit memos.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Transaction type identifier |
| ID2 | CHAR | (1) | - | |
| STATUS | VARCHAR2 | (30) | Transaction type status flag. Lookup code for 'CODE_STATUS' | |
| NAME | VARCHAR2 | (20) | Transaction type name | |
| DESCRIPTION | VARCHAR2 | (80) | Transaction type description | |
| TYPE | VARCHAR2 | (20) | Transaction Class, could be one of: INV,CM,DM,GUAR,DEP,CB | |
| START_DATE_ACTIVE | DATE | Y | Transaction type start date | |
| END_DATE_ACTIVE | DATE | Transaction type end date | ||
| SET_OF_BOOKS_ID | NUMBER | (15) | Set of books identifier | |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier |
APPS.OKX_CUST_TRX_TYPES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | VARCHAR2 | (8) | Conversion date | |
| ID2 | VARCHAR2 | (62) | Currencies conversion type defined like: FROM_CURRENCY#TO_CURRENCY#CONVERSION_TYPE | |
| NAME | VARCHAR2 | (30) | Y | Conversion type |
| DESCRIPTION | VARCHAR2 | (92) | Currency type, rate and conversion date information | |
| STATUS | CHAR | (1) | Conversion rate status | |
| START_DATE_ACTIVE | DATE | Date before which the Daily Rate is invalid. (Column not in base table) | ||
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date after which the Daily Rate is invalid. (Null column, not in base table) | |
| CONVERSION_RATE | NUMBER | Y | Currency conversion rate | |
| STATUS_CODE | VARCHAR2 | (1) | Y | Daily balances up to date flag |
APPS.OKX_DAILY_RATES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (10) | Y | System generated person primary key from PER_PEOPLE_S. |
| ID2 | VARCHAR2 | (19) | Effective start/end dates | |
| NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by. | |
| DESCRIPTION | VARCHAR2 | (0) | ||
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | Number assigned to a person if they have been an employee. | |
| START_DATE_ACTIVE | DATE | Y | Effective start date. | |
| END_DATE_ACTIVE | DATE | Y | Effective end date. | |
| STATUS | VARCHAR2 | (1) | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Y | Foreign key to HR_ORGANIZATION_UNITS. |
| PERSON_TYPE_ID | NUMBER | (15) | Y | Foreign key to PER_PERSON_TYPES. |
| LAST_NAME | VARCHAR2 | (150) | Y | Last name of the person, (surname, family name). |
| FIRST_NAME | VARCHAR2 | (150) | First name of person. | |
| START_DATE | DATE | Y | Start date for the person (not the DateTrack attribute). | |
| EMAIL_ADDRESS | VARCHAR2 | (240) | Holds actual email identifier. | |
| INTERNAL_LOCATION | VARCHAR2 | (45) | Internal location. | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (0) | Not used in this view | |
| WOMEN_OWNED_FLAG | VARCHAR2 | (0) | Not used in this view | |
| MINORITY_GROUP_LOOKUP | VARCHAR2 | (0) | Not used in this view |
APPS.OKX_EMPLOYEES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (10) | Y | System generated person primary key from PER_PEOPLE_S. |
| ID2 | VARCHAR2 | (19) | Effective start/end dates | |
| NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by. | |
| DESCRIPTION | VARCHAR2 | (0) | ||
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | Number assigned to a person if they have been an employee. | |
| START_DATE_ACTIVE | DATE | Y | Effective start date. | |
| END_DATE_ACTIVE | DATE | Y | Effective end date. | |
| STATUS | VARCHAR2 | (1) | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Y | Foreign key to HR_ORGANIZATION_UNITS. |
| PERSON_TYPE_ID | NUMBER | (15) | Y | Foreign key to PER_PERSON_TYPES. |
| LAST_NAME | VARCHAR2 | (150) | Y | Last name of the person, (surname, family name). |
| FIRST_NAME | VARCHAR2 | (150) | First name of person. | |
| START_DATE | DATE | Y | Start date for the person (not the DateTrack attribute). | |
| EMAIL_ADDRESS | VARCHAR2 | (240) | Holds actual email identifier. | |
| INTERNAL_LOCATION | VARCHAR2 | (45) | Internal location. | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (0) | Not used in this view | |
| WOMEN_OWNED_FLAG | VARCHAR2 | (0) | Not used in this view | |
| MINORITY_GROUP_LOOKUP | VARCHAR2 | (0) | Not used in this view | |
| WORK_TELEPHONE | VARCHAR2 | (60) | ||
| NATIONALITY | VARCHAR2 | (30) | ||
| NATIONAL_IDENTIFIER | VARCHAR2 | (30) | ||
| ADDRESS_LINE1 | VARCHAR2 | (240) | ||
| ADDRESS_LINE2 | VARCHAR2 | (240) | ||
| ADDRESS_LINE3 | VARCHAR2 | (240) | ||
| ADDRESS_TYPE | VARCHAR2 | (30) | ||
| TOWN_OR_CITY | VARCHAR2 | (30) | ||
| POSTAL_CODE | VARCHAR2 | (30) | ||
| COUNTRY | VARCHAR2 | (60) | ||
| DATE_FROM | DATE | |||
| DATE_TO | DATE |
APPS.OKX_EMPLOYEE_DETAILS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | VARCHAR2 | (25) | Y | Freight code |
| ID2 | NUMBER | Y | Organization identifier | |
| NAME | VARCHAR2 | (25) | Y | Freight code |
| DESCRIPTION | VARCHAR2 | (80) | Freight code description | |
| STATUS | VARCHAR2 | (1) | Freight carriers status flag. (NULL value, not found in base table) | |
| START_DATE_ACTIVE | DATE | Date before which freight carriers are invalid | ||
| END_DATE_ACTIVE | VARCHAR2 | (9) | Disable date | |
| ORGANIZATION_ID | NUMBER | Y | Organization identifier |
APPS.OKX_FREIGHT_V is not referenced by any database object
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 |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | (15) | Y | Organization Identifier |
| ORGANIZATION_NAME | VARCHAR2 | (240) | Y | Organization Name |
| PERIOD_SET_NAME | VARCHAR2 | (15) | Y | Accounting calendar name |
| PERIOD_NAME | VARCHAR2 | (15) | Y | System generated accounting period name |
| START_DATE | DATE | Y | Date on which accounting period begins | |
| END_DATE | DATE | Y | Date on which accounting period ends | |
| PERIOD_TYPE | VARCHAR2 | (15) | Y | Accounting period type |
| PERIOD_YEAR | NUMBER | (15) | Y | Accounting period year |
| PERIOD_NUM | NUMBER | (15) | Y | Accounting period number |
| QUARTER_NUM | NUMBER | (15) | Y | Quarter number of accounting period |
APPS.OKX_GL_PERIODS_ORG_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Displays information about the severities defined for service requests and actions.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Severity unique identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| INCIDENT_SUBTYPE | VARCHAR2 | (30) | Y | Identifies whether the severity is for service requests or actions |
| START_DATE_ACTIVE | DATE | Date this severity becomes active, if limited | ||
| END_DATE_ACTIVE | DATE | Date this severity becomes inactive, if limited | ||
| STATUS | VARCHAR2 | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (720) | Severity description | |
| NAME | VARCHAR2 | (90) | Y | Severity name |
APPS.OKX_INCIDENT_SEVERITS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays information about the statuses defined for service requests and actions.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CONTRACT_SERVICE_ID | NUMBER | Service line unique identifier | ||
| STATUS_CODE | VARCHAR2 | (4) | Status code |
APPS.OKX_INCIDENT_STATUSES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary key column.Unique ID that identifies an item unit instance ( Internally generated sequence number) | |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (30) | Y | Functional, user key to the item instance |
| DESCRIPTION | CHAR | (1) | Not used | |
| START_DATE_ACTIVE | DATE | Instance effective from date | ||
| END_DATE_ACTIVE | DATE | Instance effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether the record is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Y | Primary unit of measure code |
| INSTANCE_ID | NUMBER | Y | Unique ID that identifies an item unit instance ( Internally generated sequence number) | |
| INSTANCE_NUMBER | VARCHAR2 | (30) | Y | Functional, user key to the item instance |
| EXTERNAL_REFERENCE | VARCHAR2 | (30) | External reference, like customer asset tag | |
| INVENTORY_ITEM_ID | NUMBER | Y | Inventory Item Identifier from MTL_SYSTEM_ITEMS_B | |
| INVENTORY_REVISION | VARCHAR2 | (3) | Inventory Revision Code | |
| INV_MASTER_ORGANIZATION_ID | NUMBER | Y | Inventory Master Organization Identifier from MTL_ORGANIZATIONS | |
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number of the Instance. | |
| MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | Flag indicating if the Serial Number is a manufacturer's Serial number | |
| LOT_NUMBER | VARCHAR2 | (80) | Lot Number | |
| QUANTITY | NUMBER | Y | Quantity | |
| UNIT_OF_MEASURE | VARCHAR2 | (3) | Y | Unit of Measure Code |
| ACCOUNTING_CLASS_CODE | VARCHAR2 | (10) | Accounting Classification Code | |
| INSTANCE_CONDITION_ID | NUMBER | Instance Condition Identifier | ||
| INSTANCE_STATUS_ID | NUMBER | Y | Instance Status Identifier | |
| CUSTOMER_VIEW_FLAG | VARCHAR2 | (1) | Y | Flag indicating if the Instance is as per the Customer Definition |
| MERCHANT_VIEW_FLAG | VARCHAR2 | (1) | Y | Flag indicating if the instance is as per the Merchant View |
| SELLABLE_FLAG | VARCHAR2 | (1) | Flag indicating if the Instance is sellable | |
| SYSTEM_ID | NUMBER | System Identifier to which the Instance is a part of | ||
| INSTANCE_TYPE_CODE | VARCHAR2 | (30) | Instance Type Code | |
| LOCATION_TYPE_CODE | VARCHAR2 | (30) | Location Type Code | |
| LOCATION_ID | NUMBER | Location Identifier | ||
| INV_ORGANIZATION_ID | NUMBER | Inventory Organization Identifier | ||
| INV_SUBINVENTORY_NAME | VARCHAR2 | (10) | Inventory Sub-Inventory Name | |
| INV_LOCATOR_ID | NUMBER | Inventory Locator Identifier | ||
| PA_PROJECT_ID | NUMBER | Project Identifier from Project Accounting | ||
| PA_PROJECT_TASK_ID | NUMBER | Project Task Identifier from Project Accounting | ||
| IN_TRANSIT_ORDER_LINE_ID | NUMBER | Order Line Identifier for an In-Transit Order (Internal Order) | ||
| WIP_JOB_ID | NUMBER | WIP Job Identifier | ||
| PO_ORDER_LINE_ID | NUMBER | Purchase Order Line Identifier | ||
| LAST_OE_ORDER_LINE_ID | NUMBER | Last Order Line Idetifier that touched the Instance | ||
| LAST_OE_RMA_LINE_ID | NUMBER | Last RMA Line Identifier that touched the Instance | ||
| LAST_PO_PO_LINE_ID | NUMBER | Last Purchase Order Line Identifier from Purchasing | ||
| LAST_OE_PO_NUMBER | VARCHAR2 | (50) | Last Order Entry Purchase Order Number | |
| LAST_WIP_JOB_ID | NUMBER | Last WIP job Identifier | ||
| LAST_PA_PROJECT_ID | NUMBER | Last Project Identifier from Project Accounting | ||
| LAST_PA_TASK_ID | NUMBER | Last Task Identifier from Project Accounting | ||
| LAST_OE_AGREEMENT_ID | NUMBER | Last Agreement Identifier from Order Entry | ||
| INSTALL_DATE | DATE | Installation Date for an Instance | ||
| MANUALLY_CREATED_FLAG | VARCHAR2 | (1) | Flag indicating if the instance is created manually | |
| RETURN_BY_DATE | DATE | Date the Instance to be returned | ||
| ACTUAL_RETURN_DATE | DATE | Date of the Actual Return | ||
| CREATION_COMPLETE_FLAG | VARCHAR2 | (1) | Flag indicating if the Instance Creation is complete | |
| COMPLETENESS_FLAG | VARCHAR2 | (1) | Flag indicating if the Instance Configuration is Complete | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Last updated by | |
| OBJECT_VERSION_NUMBER | NUMBER | Y | object version number | |
| SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
| LAST_TXN_LINE_DETAIL_ID | NUMBER | Transaction Line Detail Identifier | ||
| INSTALL_LOCATION_TYPE_CODE | VARCHAR2 | (30) | Install Location Type Code | |
| INSTALL_LOCATION_ID | NUMBER | Install Location Identifier | ||
| INSTANCE_USAGE_CODE | VARCHAR2 | (30) | Instance Usage Code | |
| OWNER_PARTY_SOURCE_TABLE | VARCHAR2 | (30) | De-normalized Column for Instance Owner Party Source Table | |
| OWNER_PARTY_ID | NUMBER | De-normalized Column for Instance Owner Party Identifier | ||
| OWNER_PARTY_ACCOUNT_ID | NUMBER | De-normalized Column for Instance Owner Party Account Identifier | ||
| LAST_VLD_ORGANIZATION_ID | NUMBER | The Organization Identifier by which the Instance was validated Last | ||
| MIGRATED_FLAG | VARCHAR2 | (1) | Not used |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTY_ID | NUMBER | (15) | Y | Party identifier |
| ID2 | CHAR | (1) | Reserved for future use. | |
| PARTY_NAME | VARCHAR2 | (360) | Y | Name of this party. |
| PARTY_NUMBER | VARCHAR2 | (30) | Y | Unique identification number for this party |
| CATEGORY_CODE | VARCHAR2 | (30) | User-definable category. Lookup type is CUSTOMER_CATEGORY. | |
| ADDRESS1 | VARCHAR2 | (240) | First line of the identifying address. | |
| ADDRESS2 | VARCHAR2 | (240) | Second line of the identifying address. | |
| ADDRESS3 | VARCHAR2 | (240) | Third line of the identifying address. | |
| ADDRESS4 | VARCHAR2 | (240) | Fourth line of the identifying address. | |
| CITY | VARCHAR2 | (60) | City of the identifying address. | |
| POSTAL_CODE | VARCHAR2 | (60) | Code of the identifying address | |
| STATE | VARCHAR2 | (60) | State of the identifying address | |
| COUNTRY | VARCHAR2 | (60) | Country of the identifying address. | |
| PROVINCE | VARCHAR2 | (60) | Province of the identifying address. | |
| STATUS | VARCHAR2 | (1) | Y | Party status flag. |
| COUNTY | VARCHAR2 | (60) | County of the identifying address. | |
| THIRD_PARTY_FLAG | VARCHAR2 | (1) | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory. | |
| FIRST_NAME | VARCHAR2 | (150) | First name of the person. | |
| MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
| LAST_NAME | VARCHAR2 | (150) | Last name of the person | |
| TITLE | VARCHAR2 | (60) | A professional or family title. For example, Don or The Right Honorable. | |
| ACADEMIC_TITLE | VARCHAR2 | (30) | Academic title that is part of a person's name, such as Dr. John Smith. | |
| EMAIL_ADDRESS | VARCHAR2 | (2000) | E- mail address. | |
| ADDRESS | VARCHAR2 | (1329) | Identifying address. | |
| AGENT_SITE_ID | NUMBER | (15) | Y | Agent party site identifier. |
| AGENT_TYPE | CHAR | (11) | Not used. |
APPS.OKX_INSURANCE_AGENT_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTY_ID | NUMBER | (15) | Y | Party identifier |
| ID2 | CHAR | (1) | Reserved for future use. | |
| PARTY_NAME | VARCHAR2 | (360) | Y | Name of this party. |
| PARTY_NUMBER | VARCHAR2 | (30) | Y | Unique identification number for this party |
| CATEGORY_CODE | VARCHAR2 | (30) | User-definable category. Lookup type is CUSTOMER_CATEGORY (INSURER). | |
| ADDRESS1 | VARCHAR2 | (240) | First line of the identifying address. | |
| ADDRESS2 | VARCHAR2 | (240) | Second line of the identifying address. | |
| ADDRESS3 | VARCHAR2 | (240) | Third line of the identifying address. | |
| ADDRESS4 | VARCHAR2 | (240) | ||
| CITY | VARCHAR2 | (60) | City of the identifying address. | |
| POSTAL_CODE | VARCHAR2 | (60) | Code of the identifying address. | |
| STATE | VARCHAR2 | (60) | State of the identifying address. | |
| COUNTRY | VARCHAR2 | (60) | Country of the identifying address. | |
| PROVINCE | VARCHAR2 | (60) | Province of the identifying address. | |
| STATUS | VARCHAR2 | (1) | Y | Party status flag. |
| COUNTY | VARCHAR2 | (60) | County of the identifying address. | |
| THIRD_PARTY_FLAG | VARCHAR2 | (1) | Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory. | |
| FIRST_NAME | VARCHAR2 | (150) | First name of the person. | |
| MIDDLE_NAME | VARCHAR2 | (60) | Middle name of the person | |
| LAST_NAME | VARCHAR2 | (150) | Last name of the person | |
| TITLE | VARCHAR2 | (60) | A professional or family title. For example, Don or The Right Honorable. | |
| ACADEMIC_TITLE | VARCHAR2 | (30) | Academic title that is part of a person's name, such as Dr. John Smith. | |
| EMAIL_ADDRESS | VARCHAR2 | (2000) | E-mail address. | |
| ADDRESS | VARCHAR2 | (1329) | Identifying address. | |
| SITE_ID | NUMBER | (15) | Y | Agency party site identifier. |
| INSURER_TYPE | CHAR | (11) | Insurer type (INSURER) |
APPS.OKX_INSURER_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTY_ID | NUMBER | Y | Supplier unique identifier | |
| ID2 | CHAR | (1) | Reserved for future use. | |
| PARTY_NAME | VARCHAR2 | (240) | Supplier name | |
| PARTY_NUMBER | VARCHAR2 | (30) | Y | Supplier number |
| CATEGORY_CODE | VARCHAR2 | (30) | Supplier type | |
| INSURER_TYPE | CHAR | (12) | Insurer Type (INSURER) |
APPS.OKX_INS_PROVIDER_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays information about bills of material components.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COMPONENT_SEQUENCE_ID | NUMBER | Y | Component unique identifier | |
| BILL_SEQUENCE_ID | NUMBER | Y | Bill of material unique identifier | |
| COMPONENT_QUANTITY | NUMBER | Y | Quantity of component in bill of material | |
| COMPONENT_ITEM_ID | NUMBER | Component item identifier | ||
| EFFECTIVITY_DATE | DATE | Y | Effective date | |
| DISABLE_DATE | DATE | Disable date |
APPS.OKX_INV_COMPONENTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Prepayment identifier |
| ID2 | NUMBER | (15) | Y | Invoice identifier |
| PREPAYMENT_AMOUNT_APPLIED | NUMBER | Y | Prepayment amount applied to an invoice | |
| DATE_REPORTED | DATE | Reported date | ||
| ORG_ID | NUMBER | (15) | Organization identifier | |
| NAME | NUMBER | (15) | Y | Invoice ID |
| DESCRIPTION | VARCHAR2 | (62) | Invoice amount and date information | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date record becomes inactive | |
| STATUS | CHAR | (1) | Status |
APPS.OKX_INV_PREPAYS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | ||
| ID2 | VARCHAR2 | (81) | ||
| NAME | VARCHAR2 | (480) | ||
| DESCRIPTION | VARCHAR2 | (204) | ||
| STATUS | VARCHAR2 | (0) | ||
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| INVENTORY_ITEM_ID | NUMBER | Y | ||
| ORGANIZATION_ID | NUMBER | Y | ||
| CATEGORY_SET_ID | NUMBER | Y | ||
| CATEGORY_ID | NUMBER | Y |
APPS.OKX_ITEM_CATEGORIES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary key column. Unique identifier for Install Base instance line of Lease contract | |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (150) | Instance number | |
| DESCRIPTION | VARCHAR2 | (150) | Y | Line number |
| ITEM_DESCRIPTION | VARCHAR2 | (1995) | Not used | |
| COMMENTS | VARCHAR2 | (1995) | Comments | |
| CHR_ID | NUMBER | Unique identifier for contract | ||
| DNZ_CHR_ID | NUMBER | Y | Denormalized unique identifier for contract | |
| LTY_CODE | VARCHAR2 | (30) | Y | Line style code |
| LSE_TYPE | VARCHAR2 | (10) | Y | Line style type. Indicates whether line is a top line or sub line |
| LSE_PARENT_ID | NUMBER | Parent line style identifier | ||
| LINE_NUMBER | VARCHAR2 | (150) | Y | Line number |
| DATE_TERMINATED | DATE | Date instance was terminated | ||
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether instance line is active or inactive | |
| CUSTOMER_PRODUCT_ID | VARCHAR2 | (40) | Unque identifier for customer product | |
| REFERENCE_NUMBER | VARCHAR2 | (200) | Customer product reference number | |
| ITEM_QUANTITY | NUMBER | Instance quantity | ||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure code | |
| INSTANCE_ID | NUMBER | Y | Unique ID that identifies an item unit instance ( Internally generated sequence number) | |
| INSTANCE_NUMBER | VARCHAR2 | (30) | Y | Functional, user key to the item instance |
| EXTERNAL_REFERENCE | VARCHAR2 | (30) | External reference, like customer asset tag | |
| INVENTORY_ITEM_ID | NUMBER | Y | Inventory Item Identifier from MTL_SYSTEM_ITEMS_B | |
| INVENTORY_REVISION | VARCHAR2 | (3) | Inventory Revision Code | |
| INV_MASTER_ORGANIZATION_ID | NUMBER | Y | Inventory Master Organization Identifier from MTL_ORGANIZATIONS | |
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number of the Instance | |
| MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | Flag indicating if the Serial Number is a manufacturer's Serial number | |
| LOT_NUMBER | VARCHAR2 | (80) | Lot Number | |
| QUANTITY | NUMBER | Y | Quantity | |
| UNIT_OF_MEASURE | VARCHAR2 | (3) | Y | Unit of Measure Code |
| ACCOUNTING_CLASS_CODE | VARCHAR2 | (10) | Accounting Classification Code | |
| INSTANCE_CONDITION_ID | NUMBER | Instance Condition Identifier | ||
| INSTANCE_STATUS_ID | NUMBER | Y | Instance Status Identifier | |
| CUSTOMER_VIEW_FLAG | VARCHAR2 | (1) | Y | Flag indicating if the Instance is as per the Customer Definition |
| MERCHANT_VIEW_FLAG | VARCHAR2 | (1) | Y | Flag indicating if the instance is as per the Merchant View |
| SELLABLE_FLAG | VARCHAR2 | (1) | Flag indicating if the Instance is sellable | |
| SYSTEM_ID | NUMBER | System Identifier to which the Instance is a part of | ||
| INSTANCE_TYPE_CODE | VARCHAR2 | (30) | Instance Type Code | |
| INSTANCE_ACTIVE_START_DATE | DATE | Activation Start Date | ||
| INSTANCE_ACTIVE_END_DATE | DATE | Activation End Date | ||
| LOCATION_TYPE_CODE | VARCHAR2 | (30) | Location Type Code | |
| LOCATION_ID | NUMBER | Location Identifier | ||
| INV_ORGANIZATION_ID | NUMBER | Inventory Organization Identifier | ||
| INV_SUBINVENTORY_NAME | VARCHAR2 | (10) | Inventory Sub-Inventory Name | |
| INV_LOCATOR_ID | NUMBER | Inventory Locator Identifier | ||
| PA_PROJECT_ID | NUMBER | Project Identifier from Project Accounting | ||
| PA_PROJECT_TASK_ID | NUMBER | Project Task Identifier from Project Accounting | ||
| IN_TRANSIT_ORDER_LINE_ID | NUMBER | Order Line Identifier for an In-Transit Order (Internal Order) | ||
| WIP_JOB_ID | NUMBER | WIP Job Identifier | ||
| PO_ORDER_LINE_ID | NUMBER | Purchase Order Line Identifier | ||
| LAST_OE_ORDER_LINE_ID | NUMBER | Last Order Line Idetifier that touched the Instance | ||
| LAST_OE_RMA_LINE_ID | NUMBER | Last RMA Line Identifier that touched the Instance | ||
| LAST_PO_PO_LINE_ID | NUMBER | Last Purchase Order Line Identifier from Purchasing | ||
| LAST_OE_PO_NUMBER | VARCHAR2 | (50) | Last Order Entry Purchase Order Number | |
| LAST_WIP_JOB_ID | NUMBER | Last WIP job Identifier | ||
| LAST_PA_PROJECT_ID | NUMBER | Last Project Identifier from Project Accounting | ||
| LAST_PA_TASK_ID | NUMBER | Last Task Identifier from Project Accounting | ||
| LAST_OE_AGREEMENT_ID | NUMBER | Last Agreement Identifier from Order Entry | ||
| INSTALL_DATE | DATE | Installation Date for an Instance | ||
| MANUALLY_CREATED_FLAG | VARCHAR2 | (1) | Flag indicating if the instance is created manually | |
| RETURN_BY_DATE | DATE | Date the Instance to be returned | ||
| ACTUAL_RETURN_DATE | DATE | Date of the Actual Return | ||
| CREATION_COMPLETE_FLAG | VARCHAR2 | (1) | Flag indicating if the Instance Creation is complete | |
| COMPLETENESS_FLAG | VARCHAR2 | (1) | Flag indicating if the Instance Configuration is Complete | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Identifier for last updated by person | |
| OBJECT_VERSION_NUMBER | NUMBER | Y | Object version number | |
| SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
| LAST_TXN_LINE_DETAIL_ID | NUMBER | Transaction Line Detail Identifier | ||
| INSTALL_LOCATION_TYPE_CODE | VARCHAR2 | (30) | Install Location Type Code | |
| INSTALL_LOCATION_ID | NUMBER | Install Location Identifier | ||
| INSTANCE_USAGE_CODE | VARCHAR2 | (30) | Instance Usage Code | |
| OWNER_PARTY_SOURCE_TABLE | VARCHAR2 | (30) | De-normalized Column for Instance Owner Party Source Table | |
| OWNER_PARTY_ID | NUMBER | De-normalized Column for Instance Owner Party Identifier | ||
| OWNER_PARTY_ACCOUNT_ID | NUMBER | De-normalized Column for Instance Owner Party Account Identifier | ||
| LAST_VLD_ORGANIZATION_ID | NUMBER | The Organization Identifier by which the Instance was validated Last | ||
| MIGRATED_FLAG | VARCHAR2 | (1) | Not used |
APPS.OKX_ITEM_INSTS_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
| INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
| UOM_TYPE | NUMBER | Allowed unit of measure conversion type | ||
| UOM_CODE | VARCHAR2 | (3) | Y | Abbreviated unit of measure code |
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Y | Unit of measure name |
| UNIT_OF_MEASURE_TL | VARCHAR2 | (25) | Y | Unit of measure name translation |
| UOM_CLASS | VARCHAR2 | (10) | Y | Unit of measure class |
| DESCRIPTION | VARCHAR2 | (50) | Unit of measure description |
APPS.OKX_ITEM_UOMS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| NOTIFICATION_ID | NUMBER | Y | Unique notification identifier | |
| GROUP_ID | NUMBER | Y | Grouping of notifications | |
| USER_ID | NUMBER | (15) | Y | Application user identifier |
| MESSAGE_TYPE | VARCHAR2 | (8) | Y | Item type of the message |
| MESSAGE_NAME | VARCHAR2 | (30) | Y | Internal name of the message |
| RECIPIENT_ROLE | VARCHAR2 | (320) | Y | Role of person to receive notification |
| STATUS | VARCHAR2 | (80) | Y | QuickCode meaning |
| STATUS_CODE | VARCHAR2 | (8) | Y | Status Code |
| PRIORITY | NUMBER | Priority assigned to the message (1-100) | ||
| BEGIN_DATE | DATE | Start Date | ||
| END_DATE | DATE | Date finished | ||
| DUE_DATE | DATE | Indicates the reply-by date | ||
| USER_COMMENT | VARCHAR2 | (4000) | User comment | |
| SUBJECT | VARCHAR2 | (4000) | Notification subject | |
| MESSAGE | VARCHAR2 | (4000) | Notification message | |
| CONTRACT_NUMBER | VARCHAR2 | (4000) | Contract number in notification | |
| CONTRACT_NUMBER_MODIFIER | VARCHAR2 | (4000) | Contract Number Modifier | |
| CONTRACT_ID | NUMBER | Contract identifier in notification | ||
| DUMMY_SORT | NUMBER |
APPS.OKX_LAUNCHPAD_INBOX_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | |
| ID2 | CHAR | (1) | ||
| NAME | VARCHAR2 | (240) | Y | |
| DESCRIPTION | VARCHAR2 | (240) | Y | |
| OPERATING_UNIT_ID | NUMBER | (15) | Y | |
| OPERATING_UNIT_NAME | VARCHAR2 | (240) | Y | |
| SET_OF_BOOKS_ID | VARCHAR2 | (150) | ||
| STATUS | VARCHAR2 | (1) | ||
| COUNTRY | VARCHAR2 | (0) | ||
| ADDRESS1 | VARCHAR2 | (0) | ||
| ADDRESS2 | VARCHAR2 | (0) | ||
| ADDRESS3 | VARCHAR2 | (0) | ||
| ADDRESS4 | VARCHAR2 | (0) | ||
| POSTAL_CODE | VARCHAR2 | (0) | ||
| STATE | VARCHAR2 | (0) | ||
| COUNTY | VARCHAR2 | (0) | ||
| CITY | VARCHAR2 | (0) |
APPS.OKX_LEGAL_ENTITIES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary Key of QP_LIST_HEADERS_B. System Generated ID | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| LIST_TYPE_CODE | VARCHAR2 | (30) | Y | This stores the type of modifier list like promotion, price list, discount list,surcharge list and price modifier list. |
| START_DATE_ACTIVE | DATE | This is the start date of the effective period for the modifier list | ||
| END_DATE_ACTIVE | DATE | This is the end date of the effective period for the modifier list | ||
| AUTOMATIC_FLAG | VARCHAR2 | (1) | The flag indicates whether this is an automatic or ask for promotion/discount | |
| CURRENCY_CODE | VARCHAR2 | (30) | Price List Currency | |
| DISCOUNT_LINES_FLAG | VARCHAR2 | (1) | This column is used for backward compatibility. Tells you whether there are lines in the oe_discount_lines table. | |
| NAME | VARCHAR2 | (240) | Y | Name of Modifier List |
| DESCRIPTION | VARCHAR2 | (2000) | Description of Modifier List | |
| B_STATUS | VARCHAR2 | (1) | Active Flag | |
| STATUS | VARCHAR2 | (1) | Status |
APPS.OKX_LIST_HEADERS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | System-generated primary key column. |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (60) | Y | Translated location name |
| LOCATION_DESCRIPTION | VARCHAR2 | (240) | Translated description of the location. | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Business Group ID associated with location. | |
| IN_ORGANIZATION_FLAG | VARCHAR2 | (30) | Indicates whether this location is an internal site. | |
| ORGANIZATION_ID | NUMBER | (15) | Inventory organization foreign key. | |
| END_DATE_ACTIVE | VARCHAR2 | (9) | Date after which this location is no longer valid. | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| STATUS | VARCHAR2 | (1) | Status | |
| ADDRESS_LINE_1 | VARCHAR2 | (240) | 1st line of location address. | |
| ADDRESS_LINE_2 | VARCHAR2 | (240) | 2nd line of location address. | |
| ADDRESS_LINE_3 | VARCHAR2 | (240) | 3rd line of location address. | |
| TOWN_OR_CITY | VARCHAR2 | (30) | Town or city. | |
| COUNTRY | VARCHAR2 | (60) | Country. | |
| POSTAL_CODE | VARCHAR2 | (30) | Postal code. | |
| DESCRIPTION | VARCHAR2 | (80) | Formatted address, country specific |
APPS.OKX_LOCATIONS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | VARCHAR2 | (30) | Y | QuickCode lookup type |
| ID2 | VARCHAR2 | (112) | QuickCode code | |
| NAME | VARCHAR2 | (80) | Y | QuickCode meaning |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| LOOKUP_TYPE | VARCHAR2 | (30) | Y | QuickCode lookup type |
| LOOKUP_CODE | VARCHAR2 | (30) | Y | Lookup code |
| B_STATUS | VARCHAR2 | (1) | Y | Enabled flag |
| STATUS | VARCHAR2 | (1) | Status | |
| START_DATE_ACTIVE | DATE | The date when the QuickCode becomes active | ||
| END_DATE_ACTIVE | DATE | The date when the QuickCode becomes inactive | ||
| VIEW_APPLICATION_ID | NUMBER | (15) | Y | Identifies which application's view will include the lookup values |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Used for lines entry, list of UOM. |
APPS.OKX_LOOKUPS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary key column. Unique identifier for model line | |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (240) | Model name. This is inventory item name | |
| DESCRIPTION | VARCHAR2 | (150) | Y | Line number |
| ITEM_DESCRIPTION | VARCHAR2 | (1995) | Model item description | |
| COMMENTS | VARCHAR2 | (1995) | Comments | |
| CHR_ID | NUMBER | Unique identifier for contract | ||
| DNZ_CHR_ID | NUMBER | Y | De-normalized unique identifier for contract | |
| PARENT_LINE_ID | NUMBER | Identifier for parent line | ||
| LTY_CODE | VARCHAR2 | (30) | Y | Line style code |
| LSE_TYPE | VARCHAR2 | (10) | Y | line style type. Whether line is a top-line or sub-line |
| LSE_PARENT_ID | NUMBER | Parent line style identifier | ||
| LINE_NUMBER | VARCHAR2 | (150) | Y | Line number |
| DATE_TERMINATED | DATE | Date line terminated | ||
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether model line is active or inactive | |
| INVENTORY_ITEM_ID | VARCHAR2 | (40) | Identifier for model line inventory item | |
| ORGANIZATION_ID | NUMBER | Identifier for model line inventory organization | ||
| QUANTITY | NUMBER | Quantity | ||
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Unit of measure code | |
| ITEM_NAME | VARCHAR2 | (240) | Name of model line item | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measue code |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | ||
| ID2 | CHAR | (1) | ||
| NAME | VARCHAR2 | (30) | Y | |
| DESCRIPTION | VARCHAR2 | (240) | ||
| STATUS | VARCHAR2 | (30) | Y | |
| CUSTOMER_ID | NUMBER | Y | ||
| ADDRESS_ID | NUMBER | |||
| SALES_STAGE_ID | NUMBER | |||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| TOTAL_AMOUNT | NUMBER | |||
| DECISION_DATE | DATE | |||
| WIN_PROBABILITY | NUMBER | |||
| CLOSE_REASON | VARCHAR2 | (30) | ||
| ORG_ID | NUMBER |
APPS.OKX_OPP_HEADERS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | ||
| ID2 | CHAR | (1) | ||
| OPP_HEADER_ID | NUMBER | Y | ||
| INVENTORY_ITEM_ID | NUMBER | |||
| ORGANIZATION_ID | NUMBER | |||
| UOM_CODE | VARCHAR2 | (3) | ||
| QUANTITY | NUMBER | |||
| TOTAL_AMOUNT | NUMBER | |||
| SALES_STAGE_ID | NUMBER | |||
| WIN_PROBABILITY | NUMBER | |||
| STATUS_CODE | VARCHAR2 | (30) | ||
| DECISION_DATE | DATE | |||
| ORG_ID | NUMBER |
APPS.OKX_OPP_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SALES_STAGE_ID | NUMBER | Y | ||
| MIN_WIN_PROBABILITY | NUMBER | Y | ||
| MAX_WIN_PROBABILITY | NUMBER | Y | ||
| ENABLED_FLAG | VARCHAR2 | (1) | Y | |
| START_DATE_ACTIVE | DATE | Y | ||
| END_DATE_ACTIVE | DATE | |||
| ORG_ID | NUMBER |
APPS.OKX_OPP_SALES_STAGES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROBABILITY_VALUE | NUMBER | Y | Win probability value of sales opportunity in the range from 0 to 100 | |
| START_DATE_ACTIVE | DATE | Y | Date which the win probability becomes active | |
| ENABLED_FLAG | VARCHAR2 | (1) | Y | Flag to indicate if the win probability is enabled |
| LEAD_STATUS_CHANGE_CODE | VARCHAR2 | (30) | After an opportunity win probability exceeds this record's value, the opportunity status changes to this value | |
| END_DATE_ACTIVE | DATE | Date which the win probability becomes inactive | ||
| MEANING | VARCHAR2 | (80) | Text description of the win probability | |
| ORG_ID | NUMBER | Operating unit which performed this transaction | ||
| USAGE_INDICATOR | VARCHAR2 | (30) | Usage Indicator | |
| INTERNAL_UPGRADE_PROB_VALUE | NUMBER | For internal use only on data migration- to keep the new probability value |
APPS.OKX_OPP_WIN_PROB_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | ||
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | NUMBER | Y | Name | |
| STATUS | CHAR | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (0) | Description | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date record becomes inactive | |
| ORG_ID | NUMBER | |||
| ORDER_NUMBER | NUMBER | Y | ||
| ORDER_TYPE_ID | NUMBER | Y | ||
| VERSION_NUMBER | NUMBER | Y | ||
| CREATION_DATE | DATE | Y | Standard who column | |
| EXPIRATION_DATE | DATE | |||
| ORDER_SOURCE_ID | NUMBER | |||
| ORDERED_DATE | DATE | |||
| AGREEMENT_ID | NUMBER | |||
| CUST_PO_NUMBER | VARCHAR2 | (50) | ||
| PAYMENT_TERM_ID | NUMBER | (15) | ||
| FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | ||
| FOB_POINT_CODE | VARCHAR2 | (30) | ||
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | ||
| SHIP_TO_ORG_ID | NUMBER | |||
| INVOICE_TO_ORG_ID | NUMBER | Invoice To Organization ID | ||
| INVOICE_TO_CONTACT_ID | NUMBER | Invoice To Contact ID | ||
| CANCELLED_FLAG | VARCHAR2 | (1) | Indicates whether order is cancelled ('Y') or not ('N') | |
| OPEN_FLAG | VARCHAR2 | (1) | Y | Indicates whether the order has been closed ('N') or not ('Y') |
| BOOKED_FLAG | VARCHAR2 | (1) | Y | Indicates whether order is booked ('Y') or not ('N') |
| PAYMENT_TYPE_CODE | VARCHAR2 | (30) | Stores type of payment for orders (cash, check, credit) | |
| ORDER_CATEGORY_CODE | VARCHAR2 | (30) | Y | Order category code |
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | ||
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | ||
| REQUEST_DATE | DATE | |||
| RETURN_REASON_CODE | VARCHAR2 | (30) | This column stores return reason code for a return order, and is for defaulting to a return line | |
| PAYMENT_AMOUNT | NUMBER | Stores amount of payment | ||
| PRICE_LIST_ID | NUMBER | |||
| TRANSACTIONAL_CURR_CODE | VARCHAR2 | (15) | ||
| INVOICING_RULE_ID | NUMBER | (15) | Invoicing rule used by AR for generating Invoice | |
| ACCOUNTING_RULE_ID | NUMBER | (15) | Accounting rule used by AR for generating Invoice | |
| SOLD_TO_ORG_ID | NUMBER | |||
| SOLD_TO_CONTACT_ID | NUMBER | |||
| DELIVER_TO_CONTACT_ID | NUMBER | |||
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | The Tax exemption Number | |
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | It will decide the tax handling for the order. Possible values can be S - Standard, E - Exempt, R - Required | |
| CONVERSION_RATE | NUMBER | Rate of the currency conversion | ||
| CONVERSION_TYPE_CODE | VARCHAR2 | (30) | Currency Conversion type | |
| CONVERSION_RATE_DATE | DATE | Date of the currency conversion | ||
| SALESREP_ID | NUMBER | (15) | ||
| BOOKED_DATE | DATE | |||
| PRICING_DATE | DATE | |||
| TOTAL_AMOUNT | NUMBER | |||
| FLOW_STATUS_CODE | VARCHAR2 | (30) |
APPS.OKX_ORDER_HEADERS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | System Generated Line Identifier. | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (0) | Name | |
| DESCRIPTION | VARCHAR2 | (0) | Description | |
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date record becomes inactive | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| STATUS | CHAR | (1) | Status | |
| ORG_ID | NUMBER | Operating Unit which performed this transaction. | ||
| HEADER_ID | NUMBER | Y | Foreign key refernence to OE_ORDER_HEADERS_ALL; the order to which this line belongs. | |
| LINE_TYPE_ID | NUMBER | Y | ||
| LINE_NUMBER | NUMBER | Y | Line sequence number within the order | |
| ORDERED_ITEM | VARCHAR2 | (2000) | Stores name of Ordered Item | |
| SCHEDULE_SHIP_DATE | DATE | Date Scheduled to ship item | ||
| ORDER_QUANTITY_UOM | VARCHAR2 | (3) | Ordered quantity Unit of measure | |
| PRICING_QUANTITY | NUMBER | |||
| PRICING_QUANTITY_UOM | VARCHAR2 | (3) | ||
| CANCELLED_QUANTITY | NUMBER | Cancelled Quantity | ||
| SHIPPED_QUANTITY | NUMBER | Shipped Quantity | ||
| ORDERED_QUANTITY | NUMBER | Quantity Ordered | ||
| FULFILLED_QUANTITY | NUMBER | Fulfilled Quantity | ||
| SHIPPING_QUANTITY | NUMBER | Shipping Quantity | ||
| SHIPPING_QUANTITY_UOM | VARCHAR2 | (3) | Shipping Quantity UOM | |
| DELIVERY_LEAD_TIME | NUMBER | |||
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | It will decide the tax handling for the order line. Possible values can be S - Standard, E - Exempt, R - Required | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | The Tax exemption Number | |
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | The reason code for Tax exemption | |
| SHIP_FROM_ORG_ID | NUMBER | Ship from organization id -warehouse | ||
| SHIP_TO_ORG_ID | NUMBER | Ship to Organization Id | ||
| INVOICE_TO_ORG_ID | NUMBER | Invoice To Organization ID | ||
| DELIVER_TO_ORG_ID | NUMBER | Deliver to Organization Id | ||
| SHIP_TO_CONTACT_ID | NUMBER | Person to which line is to be shipped | ||
| DELIVER_TO_CONTACT_ID | NUMBER | Deliver to Contact Id | ||
| INVOICE_TO_CONTACT_ID | NUMBER | Invoice To Contact ID | ||
| SOLD_FROM_ORG_ID | NUMBER | |||
| SOLD_TO_ORG_ID | NUMBER | Customer to whom the item is sold to | ||
| CUST_PO_NUMBER | VARCHAR2 | (50) | ||
| SHIP_TOLERANCE_ABOVE | NUMBER | Over Shipment/Return Tolerance | ||
| SHIP_TOLERANCE_BELOW | NUMBER | Under Shipment/Return Tolerance | ||
| CUST_MODEL_SERIAL_NUMBER | VARCHAR2 | (50) | Vehicle Id Number (VIN) | |
| INVENTORY_ITEM_ID | NUMBER | Y | Inventory Item ID | |
| TAX_DATE | DATE | It will store the date for tax calculation | ||
| TAX_CODE | VARCHAR2 | (50) | Tax code for the line | |
| TAX_RATE | NUMBER | The tax rate in percentage | ||
| INVOICE_INTERFACE_STATUS_CODE | VARCHAR2 | (30) | To indicate whether the invoicing activity is complete | |
| DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand Class | |
| PRICE_LIST_ID | NUMBER | Price List | ||
| PRICING_DATE | DATE | |||
| SHIPMENT_NUMBER | NUMBER | Y | System generated identifer of a shipment within a line | |
| AGREEMENT_ID | NUMBER | Internal use only | ||
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | Shipment Priority Code | |
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Shipping method | |
| FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Freight carrier for the order line. | |
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight Terms, specifying the responsibility for Freight charges | |
| FOB_POINT_CODE | VARCHAR2 | (30) | FOB Point Code | |
| TAX_POINT_CODE | VARCHAR2 | (30) | For Future release | |
| PAYMENT_TERM_ID | NUMBER | (15) | Payment Terms | |
| INVOICING_RULE_ID | NUMBER | (15) | Invoicing rule used by AR for generating Invoice | |
| ACCOUNTING_RULE_ID | NUMBER | (15) | Accounting rule used by AR for generating Invoice | |
| SOURCE_DOCUMENT_LINE_ID | NUMBER | |||
| REFERENCE_LINE_ID | NUMBER | This column stores the sales order line id this return line references | ||
| REFERENCE_TYPE | VARCHAR2 | (30) | This column is now obsolete | |
| REFERENCE_HEADER_ID | NUMBER | This column stores the sales order header id this return line references | ||
| ITEM_REVISION | VARCHAR2 | (3) | This column stores the item revision for a return line | |
| UNIT_SELLING_PRICE | NUMBER | Actual price chaged to customer | ||
| UNIT_LIST_PRICE | NUMBER | Price List price for the item | ||
| TAX_VALUE | NUMBER | The Tax amount in order currency | ||
| REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
| TOP_MODEL_LINE_ID | NUMBER | System-generated identifier of configuration top parent line | ||
| LINK_TO_LINE_ID | NUMBER | System-generated identifier of immediate parent component line | ||
| COMPONENT_SEQUENCE_ID | NUMBER | Bill of materials component (option) or bill (top model) | ||
| COMPONENT_CODE | VARCHAR2 | (1000) | Identifier of component within an exploded bill | |
| CONFIG_DISPLAY_SEQUENCE | NUMBER | Not used | ||
| SORT_ORDER | VARCHAR2 | (2000) | Sorting sequence for a component within ordered bill | |
| ITEM_TYPE_CODE | VARCHAR2 | (30) | Type of item | |
| OPTION_NUMBER | NUMBER | System generated identifer for an option or a class within a model | ||
| OPTION_FLAG | VARCHAR2 | (1) | Not used | |
| DEP_PLAN_REQUIRED_FLAG | VARCHAR2 | (1) | Departure Planning Required Flag possible values Y/N | |
| VISIBLE_DEMAND_FLAG | VARCHAR2 | (1) | Indicated line is visible to planning as demand | |
| LINE_CATEGORY_CODE | VARCHAR2 | (30) | Y | |
| ACTUAL_SHIPPMENT_DATE | DATE | Actual Shipment Date of the line | ||
| CUSTOMER_TRX_LINE_ID | NUMBER | |||
| ACTUAL_ARRIVAL_DATE | DATE | Date the item actually arrived at customer's site | ||
| ATO_LINE_ID | NUMBER | System-generated identifier if ATO configuration top model line | ||
| AUTO_SELECTED_QUANTITY | NUMBER | Not used | ||
| COMPONENT_NUMBER | NUMBER | System Generated Identifier of the included item within a model or a class | ||
| EARLIEST_ACCEPTABLE_DATE | DATE | Earliest Date the item is acceptable. | ||
| EXPLOSION_DATE | DATE | Date when the included items were exploded and frozen | ||
| LATEST_ACCEPTABLE_DATE | DATE | Latest Date the item is acceptable. | ||
| MODEL_GROUP_NUMBER | NUMBER | Not used | ||
| SCHEDULE_ARRIVAL_DATE | DATE | Date Scheduled for the item to arrive at the customer site | ||
| SHIP_MODEL_COMPLETE_FLAG | VARCHAR2 | (1) | Indicates whether line is in ship-complete configuration | |
| SCHEDULE_STATUS_CODE | VARCHAR2 | (30) | Indicates if the line is scheduled | |
| SOURCE_TYPE_CODE | VARCHAR2 | (30) | Sourcing indicator (internal or external) | |
| CANCELLED_FLAG | VARCHAR2 | (1) | Indicates whether line is completely cancelled | |
| OPEN_FLAG | VARCHAR2 | (1) | Y | Indicates whether the line has been closed ('N') or not ('Y') |
| BOOKED_FLAG | VARCHAR2 | (1) | Y | Indicates whether order line is booked ('Y') or not ('N') |
| SALESREP_ID | NUMBER | (15) | Sales person identifier | |
| RETURN_REASON_CODE | VARCHAR2 | (30) | This column stores return reason code for a return line, and is required for a return line | |
| ARRIVAL_SET_ID | NUMBER | |||
| SHIP_SET_ID | NUMBER | Ship Set Id; if the line belongs to a ship set | ||
| SPLIT_FROM_LINE_ID | NUMBER | System generated identifier of original line which was split | ||
| CUST_PRODUCTION_SEQ_NUM | VARCHAR2 | (50) | ||
| AUTHORIZED_TO_SHIP_FLAG | VARCHAR2 | (1) | ||
| OVER_SHIP_REASON_CODE | VARCHAR2 | (30) | Overshipment Reason Code | |
| OVER_SHIP_RESOLVED_FLAG | VARCHAR2 | (1) | Overshipment Resolved Flag | |
| ORDERED_ITEM_ID | NUMBER | Stores Id of Ordered Item | ||
| ITEM_IDENTIFIER_TYPE | VARCHAR2 | (30) | To distinguish different types of items (internal, customer. and generic items) | |
| CONFIGURATION_ID | NUMBER | |||
| COMMITMENT_ID | NUMBER | Commitment to apply line against | ||
| SHIPPING_INTERFACED_FLAG | VARCHAR2 | (1) | Shipping Interfaced Flag to indicate whether a line has been interfaced to shipping or not | |
| CREDIT_INVOICE_LINE_ID | NUMBER | This column stores the invoice line id this return line applies credit to | ||
| ORDER_SOURCE_ID | NUMBER | |||
| ORIG_SYS_SHIPMENT_REF | VARCHAR2 | (50) | ||
| DROP_SHIP_FLAG | VARCHAR2 | (1) | ||
| CUSTOMER_LINE_NUMBER | VARCHAR2 | (50) | ||
| CUSTOMER_SHIPMENT_NUMBER | VARCHAR2 | (50) | ||
| CUSTOMER_ITEM_NET_PRICE | NUMBER | |||
| SHIP_REASON_CODE | VARCHAR2 | (30) | Overshipment Reason Code | |
| CUSTOMER_PAYMENT_TERM_ID | NUMBER | |||
| FULFILLED_FLAG | VARCHAR2 | (1) | Fulfilled Flag to indicate whether the line has been fulfilled. | |
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
| CONFIG_HEADER_ID | NUMBER | System-generated identifier for Oracle Configurator reference | ||
| CONFIG_REV_NBR | NUMBER | System-generated identifier for Oracle Configurator reference | ||
| MFG_COMPONENT_SEQUENCE_ID | NUMBER | Not used | ||
| INVOICED_QUANTITY | NUMBER | To indicate whether the invoicing activity is complete | ||
| REFERENCE_CUSTOMER_TRX_LINE_ID | NUMBER | This column stores the invoice line id this return line references | ||
| SPLIT_BY | VARCHAR2 | (30) | ||
| LINE_SET_ID | NUMBER | Line Set id | ||
| SERVICE_TXN_REASON_CODE | VARCHAR2 | (30) | ||
| SERVICE_TXN_COMMENT | VARCHAR2 | (2000) | ||
| SERVICE_DURATION | NUMBER | Internal use only | ||
| SERVICE_START_DATE | DATE | |||
| SERVICE_END_DATE | DATE | Internal use only | ||
| SERVICE_COTERMINATE_FLAG | VARCHAR2 | (1) | ||
| UNIT_LIST_PERCENT | NUMBER | Price list percent of the item (percent-based pricing only) | ||
| UNIT_SELLING_PERCENT | NUMBER | Percent actually charged to customer (percent based pricing only) | ||
| UNIT_PERCENT_BASE_PRICE | NUMBER | Based price used for percent based pricing | ||
| SERVICE_NUMBER | NUMBER | |||
| SERVICE_PERIOD | VARCHAR2 | (3) | ||
| SHIPPABLE_FLAG | VARCHAR2 | (1) | A flag to indicate whether a line is shippale or not. | |
| MODEL_REMNANT_FLAG | VARCHAR2 | (1) | Indicates whether model has partially shipped components | |
| FULFILLMENT_METHOD_CODE | VARCHAR2 | (30) | Fulfillment Method Code | |
| MARKETING_SOURCE_CODE_ID | NUMBER | |||
| SERVICE_REFERENCE_TYPE_CODE | VARCHAR2 | (30) | ||
| SERVICE_REFERENCE_LINE_ID | NUMBER | |||
| SERVICE_REFERENCE_SYSTEM_ID | NUMBER | |||
| CALCULATE_PRICE_FLAG | VARCHAR2 | (1) | ||
| REVENUE_AMOUNT | NUMBER | |||
| FULFILLMENT_DATE | DATE | Fulfillment Date for the Line | ||
| TOTAL_AMOUNT | NUMBER | |||
| FLOW_STATUS_CODE | VARCHAR2 | (30) |
APPS.OKX_ORDER_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRICE_ADJUSTMENT_ID | NUMBER | Y | ||
| HEADER_ID | NUMBER | Y | ||
| AUTOMATIC_FLAG | VARCHAR2 | (1) | Y | |
| DISCOUNT_ID | NUMBER | |||
| DISCOUNT_LINE_ID | NUMBER | |||
| PERCENT | NUMBER | |||
| LINE_ID | NUMBER | |||
| CONTEXT | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| ORIG_SYS_DISCOUNT_REF | VARCHAR2 | (50) | ||
| CHANGE_SEQUENCE | VARCHAR2 | (50) | ||
| LIST_HEADER_ID | NUMBER | |||
| LIST_LINE_ID | NUMBER | |||
| LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | ||
| MODIFIED_FROM | VARCHAR2 | (240) | ||
| MODIFIED_TO | VARCHAR2 | (240) | ||
| UPDATE_ALLOWED | VARCHAR2 | (1) | ||
| CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
| CHANGE_REASON_TEXT | VARCHAR2 | (2000) | ||
| UPDATED_FLAG | VARCHAR2 | (1) | ||
| APPLIED_FLAG | VARCHAR2 | (1) | ||
| OPERAND | NUMBER | |||
| ARITHMETIC_OPERATOR | VARCHAR2 | (30) | ||
| COST_ID | NUMBER | |||
| TAX_CODE | VARCHAR2 | (50) | ||
| INVOICED_FLAG | VARCHAR2 | (1) | ||
| ESTIMATED_FLAG | VARCHAR2 | (1) | ||
| ADJUSTED_AMOUNT | NUMBER | |||
| PRICING_PHASE_ID | NUMBER | |||
| CHARGE_TYPE_CODE | VARCHAR2 | (30) | ||
| CHARGE_SUBTYPE_CODE | VARCHAR2 | (30) | ||
| RANGE_BREAK_QUANTITY | NUMBER | |||
| ACCRUAL_CONVERSION_RATE | NUMBER | |||
| PRICING_GROUP_SEQUENCE | NUMBER | |||
| ACCRUAL_FLAG | VARCHAR2 | (1) | ||
| LIST_LINE_NO | VARCHAR2 | (240) | ||
| SOURCE_SYSTEM_CODE | VARCHAR2 | (30) | ||
| BENEFIT_QTY | NUMBER | |||
| BENEFIT_UOM_CODE | VARCHAR2 | (3) | ||
| PRINT_ON_INVOICE_FLAG | VARCHAR2 | (1) | ||
| EXPIRATION_DATE | DATE | |||
| PRORATION_TYPE_CODE | VARCHAR2 | (30) | ||
| REBATE_TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | ||
| REBATE_TRANSACTION_REFERENCE | VARCHAR2 | (80) | ||
| REBATE_PAYMENT_SYSTEM_CODE | VARCHAR2 | (30) | ||
| REDEEMED_DATE | DATE | |||
| REDEEMED_FLAG | VARCHAR2 | (1) | ||
| MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | ||
| PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | ||
| SUBSTITUTION_ATTRIBUTE | VARCHAR2 | (30) | ||
| INCLUDE_ON_RETURNS_FLAG | VARCHAR2 | (1) | ||
| CREDIT_OR_CHARGE_FLAG | VARCHAR2 | (1) | ||
| LOCK_CONTROL | NUMBER | |||
| OPERAND_PER_PQTY | NUMBER | |||
| ADJUSTED_AMOUNT_PER_PQTY | NUMBER |
APPS.OKX_ORD_PRC_ADJMNTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRICE_ADJUSTMENT_ID | NUMBER | Y | ||
| PRICING_CONTEXT | VARCHAR2 | (30) | Y | |
| PRICING_ATTRIBUTE | VARCHAR2 | (30) | Y | |
| PRICING_ATTR_VALUE_FROM | VARCHAR2 | (240) | ||
| PRICING_ATTR_VALUE_TO | VARCHAR2 | (240) | ||
| COMPARISON_OPERATOR | VARCHAR2 | (30) | ||
| FLEX_TITLE | VARCHAR2 | (60) | Y | |
| PRICE_ADJ_ATTRIB_ID | NUMBER | Y | ||
| LOCK_CONTROL | NUMBER |
APPS.OKX_ORD_PRC_ADJ_ATRBS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LINE_ID | NUMBER | |||
| PRICE_ADJUSTMENT_ID | NUMBER | Y | ||
| PRICE_ADJ_ASSOC_ID | NUMBER | Y | ||
| RLTD_PRICE_ADJ_ID | NUMBER | |||
| LOCK_CONTROL | NUMBER |
APPS.OKX_ORD_PRC_ADJ_RLSHP_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| HEADER_ID | NUMBER | Y | ||
| LINE_ID | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PRICING_CONTEXT | VARCHAR2 | (30) | Y | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE2 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE3 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE4 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE5 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE6 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE7 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE8 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE9 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE10 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE11 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE12 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE13 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE14 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE15 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE16 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE17 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE18 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE19 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE20 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE21 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE22 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE23 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE24 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE25 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE26 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE27 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE28 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE29 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE30 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE31 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE32 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE33 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE34 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE35 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE36 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE37 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE38 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE39 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE40 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE41 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE42 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE43 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE44 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE45 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE46 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE47 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE48 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE49 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE50 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE51 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE52 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE53 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE54 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE55 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE56 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE57 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE58 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE59 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE60 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE61 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE62 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE63 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE64 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE65 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE66 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE67 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE68 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE69 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE70 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE71 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE72 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE73 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE74 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE75 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE76 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE77 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE78 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE79 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE80 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE81 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE82 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE83 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE84 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE85 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE86 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE87 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE88 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE89 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE90 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE91 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE92 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE93 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE94 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE95 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE96 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE97 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE98 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE99 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE100 | VARCHAR2 | (240) | ||
| CONTEXT | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| FLEX_TITLE | VARCHAR2 | (60) | Y | |
| ORDER_PRICE_ATTRIB_ID | NUMBER | Y | ||
| OVERRIDE_FLAG | VARCHAR2 | (1) | ||
| LOCK_CONTROL | NUMBER |
APPS.OKX_ORD_PRC_ATRBS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SALES_CREDIT_ID | NUMBER | Y | ||
| HEADER_ID | NUMBER | Y | ||
| SALESREP_ID | NUMBER | (15) | Y | |
| PERCENT | NUMBER | Y | ||
| LINE_ID | NUMBER | |||
| CONTEXT | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| DW_UPDATE_ADVICE_FLAG | VARCHAR2 | (1) | ||
| WH_UPDATE_DATE | DATE | |||
| ORIG_SYS_CREDIT_REF | VARCHAR2 | (50) | ||
| SALES_CREDIT_TYPE_ID | NUMBER | |||
| LOCK_CONTROL | NUMBER |
APPS.OKX_ORD_SLS_CREDITS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | System-generated primary key column. |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Y | Foreign key to HR_ORGANIZATION_UNITS. |
| ORGANIZATION_ID | NUMBER | (15) | Y | Inventory Organization identifier |
| NAME | VARCHAR2 | (240) | Y | Translated name of the organization |
| B_STATUS | VARCHAR2 | (150) | Status | |
| STATUS | VARCHAR2 | (1) | Status | |
| ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
| ORGANIZATION_TYPE | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
| SET_OF_BOOKS_ID | VARCHAR2 | (150) | Set of books identifier | |
| LEGAL_ENTITY | VARCHAR2 | (150) | Legal Entity | |
| OPERATING_UNIT | VARCHAR2 | (150) | Operating Unit | |
| DESCRIPTION | VARCHAR2 | (3) | Description (Organization code) | |
| INFORMATION_TYPE | VARCHAR2 | (40) | Y | Developer descriptive flexfield column. |
| START_DATE_ACTIVE | DATE | Y | Start date of the organization. | |
| END_DATE_ACTIVE | DATE | End date of the organization. | ||
| PARTY_NUMBER | VARCHAR2 | (3) | Organization code | |
| ADDRESS | VARCHAR2 | (80) | Organization's address | |
| WOMEN_OWNED_FLAG | VARCHAR2 | (0) | Indicates whether the organization is a woman-owned business | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (0) | Indicates that the organization is a small business | |
| MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | (0) | Type of minority-owned business | |
| COUNTRY | VARCHAR2 | (60) | ||
| ADDRESS1 | VARCHAR2 | (240) | ||
| ADDRESS2 | VARCHAR2 | (240) | ||
| ADDRESS3 | VARCHAR2 | (240) | ||
| ADDRESS4 | VARCHAR2 | (0) | ||
| POSTAL_CODE | VARCHAR2 | (30) | ||
| STATE | VARCHAR2 | (0) | ||
| COUNTY | VARCHAR2 | (0) | ||
| CITY | VARCHAR2 | (30) |
APPS.OKX_ORGANIZATION_DEFS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays information about parties such as organizations, people, and groups, including the identifying address information for the party.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Party Identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| DESCRIPTION | VARCHAR2 | (30) | Y | Description (party number) |
| PARTY_NUMBER | VARCHAR2 | (30) | Y | Party number |
| ADDRESS | VARCHAR2 | (80) | Party's address | |
| NAME | VARCHAR2 | (360) | Y | Party name |
| PARTY_TYPE | VARCHAR2 | (30) | Y | Type of party |
| B_STATUS | VARCHAR2 | (1) | Y | Party status flag |
| STATUS | VARCHAR2 | (1) | Y | Status |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | DATE | Date record becomes inactive | ||
| WOMEN_OWNED_FLAG | VARCHAR2 | (0) | Indicates whether the party is a woman-owned business | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (0) | Indicates that the party is a small business | |
| MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | (0) | Type of minority-owned business |
APPS.OKX_ORG_PARTIES_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Displays information about containers during shipping confirm.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Container identifier | |
| ID2 | CHAR | (1) | ||
| DELIVERY_ID | NUMBER | Delivery identifier | ||
| CONTAINER_INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier for the container | |
| QUANTITY | NUMBER | Y | Number of containers | |
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| NAME | VARCHAR2 | (40) | ||
| DESCRIPTION | VARCHAR2 | (347) | ||
| STATUS | CHAR | (1) | Status | |
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | VARCHAR2 | (0) |
APPS.OKX_PACKING_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Party Identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| DESCRIPTION | VARCHAR2 | (30) | Y | Description (party number) |
| PARTY_NUMBER | VARCHAR2 | (30) | Y | Party number |
| CUSTOMER_PROSPECT_CODE | VARCHAR2 | (8) | Party's address | |
| NAME | VARCHAR2 | (360) | Y | Party name |
| PARTY_TYPE | VARCHAR2 | (30) | Y | Type of party |
| B_STATUS | VARCHAR2 | (1) | Y | Party status flag |
| STATUS | VARCHAR2 | (1) | Y | Status |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | DATE | Date record becomes inactive | ||
| WOMEN_OWNED_FLAG | VARCHAR2 | (0) | Indicates whether the party is a woman-owned business | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (0) | Indicates that the party is a small business | |
| MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | (0) | Type of minority-owned business | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Used for lines entry, list of UOM. | |
| GSA_INDICATOR_FLAG | VARCHAR2 | (1) | Y if the organization is a public sector service agency | |
| COUNTRY | VARCHAR2 | (60) | The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address. | |
| ADDRESS1 | VARCHAR2 | (240) | First line of the Identifying address | |
| ADDRESS2 | VARCHAR2 | (240) | Second line of the Identifying address | |
| ADDRESS3 | VARCHAR2 | (240) | Third line of the Identifying address | |
| ADDRESS4 | VARCHAR2 | (240) | Fourth line of the Identifying address | |
| CITY | VARCHAR2 | (60) | City of the Identifying address | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal Code of the Identifying address | |
| STATE | VARCHAR2 | (60) | State of the Identifying address | |
| PROVINCE | VARCHAR2 | (60) | Province of the Identifying address | |
| COUNTY | VARCHAR2 | (60) | County of the Identifying address |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Party Identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| DESCRIPTION | VARCHAR2 | (30) | Y | Description (party number) |
| PARTY_NUMBER | VARCHAR2 | (30) | Y | Party number |
| CUSTOMER_PROSPECT_CODE | VARCHAR2 | (8) | Party's address | |
| NAME | VARCHAR2 | (360) | Y | Party name |
| PARTY_TYPE | VARCHAR2 | (30) | Y | Type of party |
| B_STATUS | VARCHAR2 | (1) | Y | Party status flag |
| STATUS | VARCHAR2 | (1) | Status | |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | DATE | Date record becomes inactive | ||
| WOMEN_OWNED_FLAG | VARCHAR2 | (0) | Indicates whether the party is a woman-owned business | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (0) | Indicates that the party is a small business | |
| MINORITY_GROUP_LOOKUP_CODE | VARCHAR2 | (0) | Type of minority-owned business |
APPS.OKX_PARTIES_WITH_ACCTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Contact identifier (Primary key) | |
| ID2 | CHAR | (1) | (Multi-part primary key) | |
| B_STATUS | VARCHAR2 | (1) | Y | Party contact status |
| STATUS | VARCHAR2 | (1) | Y | Status |
| PARTY_ID | NUMBER | (15) | Y | Contact's party identifier (Primary key) |
| PARTY_ID2 | CHAR | (1) | Contact's party identifier (Multi-part primary key) | |
| PARTY_NUMBER | VARCHAR2 | (30) | Y | Contact party number |
| NAME | VARCHAR2 | (255) | Contact name | |
| DESCRIPTION | VARCHAR2 | (360) | Y | Contact formatted address |
| PARTY_TYPE | VARCHAR2 | (30) | Y | Type of party for the contact |
| PARTY_RELATIONSHIP_ID | NUMBER | (15) | Y | Party Relationship identifier |
| PARTY_RELATIONSHIP_TYPE | VARCHAR2 | (30) | Y | Lookup code for party_relations_type lookup type |
| DIRECTION_FLAG | VARCHAR2 | (1) | Y | Y if this is a directional relationship, N otherwise |
| START_DATE_ACTIVE | DATE | Y | Date relationship begins | |
| END_DATE_ACTIVE | DATE | Date relationship ends | ||
| EMAIL_ADDRESS | VARCHAR2 | (2000) |
APPS.OKX_PARTY_CONTACTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Party site use identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| LOCATION_ID | NUMBER | (15) | Y | Location identifier and foreign key to HZ_LOCATIONS. |
| PARTY_SITE_NUMBER | VARCHAR2 | (30) | Y | Party site number |
| PARTY_ID | NUMBER | (15) | Y | Party identifier and foreign key to HZ_PARTIES. |
| NAME | VARCHAR2 | (240) | A user defined name for the site | |
| STATUS | VARCHAR2 | (1) | Y | Party site status flag |
| COUNTRY | VARCHAR2 | (60) | Y | FND_TERRITORY.TERRITORY_CODE |
| ADDRESS1 | VARCHAR2 | (240) | Y | First line for address |
| ADDRESS2 | VARCHAR2 | (240) | Second line for address | |
| ADDRESS3 | VARCHAR2 | (240) | Third line for address | |
| ADDRESS4 | VARCHAR2 | (240) | Fourth line for address | |
| CITY | VARCHAR2 | (60) | City | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
| STATE | VARCHAR2 | (60) | State | |
| PROVINCE | VARCHAR2 | (60) | Province | |
| COUNTY | VARCHAR2 | (60) | County | |
| LOCATION_DESCRIPTION | VARCHAR2 | (2000) | Description of the site use | |
| DESCRIPTION | VARCHAR2 | (80) | Formatted address, country specific | |
| IDENTIFYING_ADDRESS_FLAG | VARCHAR2 | (1) | Y | Y or N indicates whether this is the identifying address for the party. |
| ADDRESSEE | VARCHAR2 | (360) | addressee information |
APPS.OKX_PARTY_SITES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Party site use identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| PARTY_SITE_ID | NUMBER | (15) | Y | Party site identifier. FK to HZ_PARTY_SITES |
| LOCATION_ID | NUMBER | (15) | Y | Location identifier and foreign key to HZ_LOCATIONS. |
| PARTY_SITE_NUMBER | VARCHAR2 | (30) | Y | Party site number |
| PARTY_ID | NUMBER | (15) | Y | Party identifier and foreign key to HZ_PARTIES. |
| NAME | VARCHAR2 | (240) | A user defined name for the site | |
| COMMENTS | VARCHAR2 | (240) | A textual description of the possible use of a site by a party. | |
| STATUS | VARCHAR2 | (1) | Party site status flag | |
| COUNTRY | VARCHAR2 | (60) | Y | FND_TERRITORY.TERRITORY_CODE |
| ADDRESS1 | VARCHAR2 | (240) | Y | First line for address |
| ADDRESS2 | VARCHAR2 | (240) | Second line for address | |
| ADDRESS3 | VARCHAR2 | (240) | Third line for address | |
| ADDRESS4 | VARCHAR2 | (240) | Fourth line for address | |
| CITY | VARCHAR2 | (60) | City | |
| POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
| STATE | VARCHAR2 | (60) | State | |
| PROVINCE | VARCHAR2 | (60) | Province | |
| COUNTY | VARCHAR2 | (60) | County | |
| LOCATION_DESCRIPTION | VARCHAR2 | (2000) | Description of the site use | |
| DESCRIPTION | VARCHAR2 | (80) | Formatted address, country specific | |
| SITE_USE_TYPE | VARCHAR2 | (30) | Site use type | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Used for lines entry, list of UOM. |
APPS.OKX_PARTY_SITE_USES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Term identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (50) | Y | Name of payment term |
| DESCRIPTION | VARCHAR2 | (240) | Description | |
| START_DATE_ACTIVE | DATE | Date from which payment term is valid | ||
| END_DATE_ACTIVE | DATE | Date after which a payment term is invalid | ||
| B_STATUS | VARCHAR2 | (1) | Y | No longer used |
| STATUS | VARCHAR2 | (1) | Status |
APPS.OKX_PAYABLES_TERMS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (10) | Y | System generated person primary key from PER_PEOPLE_S. |
| EFFECTIVE_START_DATE | DATE | Y | Effective start date. | |
| EFFECTIVE_END_DATE | DATE | Y | Effective end date. | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Y | Foreign key to HR_ORGANIZATION_UNITS. |
| PERSON_TYPE_ID | NUMBER | (15) | Y | Foreign key to PER_PERSON_TYPES. |
| LAST_NAME | VARCHAR2 | (150) | Y | Last name of the person, (surname, family name). |
| START_DATE | DATE | Y | Start date for the person (not the DateTrack attribute). | |
| EMAIL_ADDRESS | VARCHAR2 | (240) | Holds actual email identifier. | |
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | Number assigned to a person if they have been an employee. | |
| FIRST_NAME | VARCHAR2 | (150) | First name of person. | |
| FULL_NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by. | |
| VENDOR_ID | NUMBER | (15) | Not used. | |
| WORK_TELEPHONE | VARCHAR2 | (60) | Unsupported. |
APPS.OKX_PER_ALL_PEOPLE_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
This view is the source for all the activities associated to a preventive maintenance program.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Id1 | |
| ID2 | CHAR | (1) | Id2 | |
| NAME | VARCHAR2 | (80) | Y | Name |
| DESCRIPTION | VARCHAR2 | (2000) | Description | |
| TYPE_CODE | VARCHAR2 | (30) | Type Code | |
| TYPE | VARCHAR2 | (80) | Type | |
| EFFECTIVE_FROM | DATE | Y | Effective From | |
| EFFECTIVE_TO | DATE | Effective To | ||
| MR_STATUS_CODE | VARCHAR2 | (30) | Y | MR Status Code |
| STATUS | VARCHAR2 | (80) | Y | Status |
| DOWN_TIME | NUMBER | Down Time | ||
| UOM | VARCHAR2 | (80) | Uom | |
| PROGRAM_ID | NUMBER | Y | Program Id |
APPS.OKX_PM_ACTIVITIES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View for preventive maintenance programs.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary Key for AHL_MR_HEADERS_B, unique identifier of a MR | |
| ID2 | CHAR | (1) | Id2 | |
| NAME | VARCHAR2 | (80) | Y | Name |
| DESCRIPTION | VARCHAR2 | (2000) | Description | |
| TYPE_CODE | VARCHAR2 | (30) | Type Code | |
| TYPE | VARCHAR2 | (80) | Type | |
| EFFECTIVE_FROM | DATE | Y | Effective From | |
| EFFECTIVE_TO | DATE | Effective To | ||
| MR_STATUS_CODE | VARCHAR2 | (30) | Y | MR Status Code |
| STATUS | VARCHAR2 | (80) | Y | Status |
APPS.OKX_PM_PROGRAMS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Surrogate key used for primary unique identifiers | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (240) | Item name. | |
| DESCRIPTION | VARCHAR2 | (150) | Y | Sequencial line number. |
| ITEM_DESCRIPTION | VARCHAR2 | (1995) | Item description. | |
| COMMENTS | VARCHAR2 | (1995) | User entered comment. | |
| CHR_ID | NUMBER | Foreign key to OKC_K_HEADERS_B. | ||
| DNZ_CHR_ID | NUMBER | Y | Contract ID. Denormalized for performance. | |
| LTY_CODE | VARCHAR2 | (30) | Y | Foreign key to FND_LOOKUP_VALUES. |
| LSE_TYPE | VARCHAR2 | (10) | Y | Line style type ID. |
| LSE_PARENT_ID | NUMBER | Parent ID. | ||
| LINE_NUMBER | VARCHAR2 | (150) | Y | Sequencial line number |
| DATE_TERMINATED | DATE | Date contract was terminated. | ||
| START_DATE_ACTIVE | DATE | The beginning of the active period, one second after midnight on the date indicated. | ||
| END_DATE_ACTIVE | DATE | The end of the active period, one second before midnight on the date indicated. | ||
| STATUS | VARCHAR2 | (1) | Status | |
| INVENTORY_ITEM_ID | VARCHAR2 | (40) | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view. This is here the id of the inventory item. | |
| ORGANIZATION_ID | NUMBER | Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view. This is here the id of the inventory organization the item belongs to. | ||
| QUANTITY | NUMBER | Number of items. | ||
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Unit of Measure code. | |
| ITEM_NAME | VARCHAR2 | (240) | Item name. | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Used for lines entry, list of UOM. |
APPS.OKX_PRODUCT_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | ||
| ID2 | CHAR | (1) | ||
| LIST_HEADER_ID | NUMBER | Y | ||
| LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Y | |
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| AUTOMATIC_FLAG | VARCHAR2 | (1) | Y | |
| MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | Y | |
| PRICE_BY_FORMULA_ID | NUMBER | |||
| LIST_PRICE | NUMBER | |||
| LIST_PRICE_UOM_CODE | VARCHAR2 | (3) | ||
| PRIMARY_UOM_FLAG | VARCHAR2 | (1) | ||
| INVENTORY_ITEM_ID | NUMBER | |||
| ORGANIZATION_ID | NUMBER | |||
| PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | ||
| PERCENT_PRICE | NUMBER | |||
| ARITHMETIC_OPERATOR | VARCHAR2 | (30) | ||
| OPERAND | NUMBER | |||
| OVERRIDE_FLAG | VARCHAR2 | (1) | ||
| LIST_LINE_NO | VARCHAR2 | (30) | ||
| PRICING_PHASE_ID | NUMBER | |||
| PRICING_GROUP_SEQUENCE | NUMBER |
APPS.OKX_QP_LIST_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LINE_RELATIONSHIP_ID | NUMBER | Y | Line relationship identifier | |
| CREATION_DATE | DATE | Y | Standard Who column | |
| CREATED_BY | NUMBER | Y | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Request identifier | ||
| PROGRAM_APPLICATION_ID | NUMBER | Application identifier of last concurrent program to update record | ||
| PROGRAM_ID | NUMBER | Identifier of last concurrent program to update record | ||
| PROGRAM_UPDATE_DATE | DATE | Last date concurrent program updated record | ||
| QUOTE_LINE_ID | NUMBER | Y | Quote line identifier | |
| RELATED_QUOTE_LINE_ID | NUMBER | Y | Related quote line identifier | |
| RELATIONSHIP_TYPE_CODE | VARCHAR2 | (30) | Code defined in ASO_LOOKUPS that describes the relationship type | |
| RECIPROCAL_FLAG | VARCHAR2 | (1) | Flag indicating if this is a reciprocal relationship | |
| OBJECT_VERSION_NUMBER | NUMBER | Used in hosted environments |
APPS.OKX_QTE_LINE_RLSHPS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| MODIFIED_FROM | NUMBER | |||
| MODIFIED_TO | NUMBER | |||
| OPERAND | NUMBER | |||
| ARITHMETIC_OPERATOR | VARCHAR2 | (30) | ||
| AUTOMATIC_FLAG | VARCHAR2 | (1) | ||
| UPDATE_ALLOWABLE_FLAG | VARCHAR2 | (1) | ||
| UPDATED_FLAG | VARCHAR2 | (1) | ||
| APPLIED_FLAG | VARCHAR2 | (1) | ||
| ON_INVOICE_FLAG | VARCHAR2 | (1) | ||
| PRICING_PHASE_ID | NUMBER | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| ORIG_SYS_DISCOUNT_REF | VARCHAR2 | (50) | ||
| CHANGE_SEQUENCE | VARCHAR2 | (50) | ||
| LIST_HEADER_ID | NUMBER | |||
| LIST_LINE_ID | NUMBER | |||
| LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | ||
| UPDATE_ALLOWED | VARCHAR2 | (1) | ||
| CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
| CHANGE_REASON_TEXT | VARCHAR2 | (2000) | ||
| COST_ID | NUMBER | |||
| TAX_CODE | VARCHAR2 | (50) | ||
| TAX_EXEMPT_FLAG | VARCHAR2 | (1) | ||
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | ||
| TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
| PARENT_ADJUSTMENT_ID | NUMBER | |||
| INVOICED_FLAG | VARCHAR2 | (1) | ||
| ESTIMATED_FLAG | VARCHAR2 | (1) | ||
| INC_IN_SALES_PERFORMANCE | VARCHAR2 | (1) | ||
| SPLIT_ACTION_CODE | VARCHAR2 | (30) | ||
| ADJUSTED_AMOUNT | NUMBER | |||
| CHARGE_TYPE_CODE | VARCHAR2 | (30) | ||
| CHARGE_SUBTYPE_CODE | VARCHAR2 | (30) | ||
| RANGE_BREAK_QUANTITY | NUMBER | |||
| ACCRUAL_CONVERSION_RATE | NUMBER | |||
| PRICING_GROUP_SEQUENCE | NUMBER | |||
| ACCRUAL_FLAG | VARCHAR2 | (1) | ||
| LIST_LINE_NO | VARCHAR2 | (240) | ||
| SOURCE_SYSTEM_CODE | VARCHAR2 | (30) | ||
| BENEFIT_QTY | NUMBER | |||
| BENEFIT_UOM_CODE | VARCHAR2 | (3) | ||
| PRINT_ON_INVOICE_FLAG | VARCHAR2 | (1) | ||
| EXPIRATION_DATE | DATE | |||
| REBATE_TRANSACTION_TYPE_CODE | VARCHAR2 | (30) | ||
| REBATE_TRANSACTION_REFERENCE | VARCHAR2 | (80) | ||
| REBATE_PAYMENT_SYSTEM_CODE | VARCHAR2 | (30) | ||
| REDEEMED_DATE | DATE | |||
| REDEEMED_FLAG | VARCHAR2 | (1) | ||
| MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | ||
| PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | ||
| SUBSTITUTION_ATTRIBUTE | VARCHAR2 | (30) | ||
| PRORATION_TYPE_CODE | VARCHAR2 | (30) | ||
| INCLUDE_ON_RETURNS_FLAG | VARCHAR2 | (1) | ||
| CREDIT_OR_CHARGE_FLAG | VARCHAR2 | (1) | ||
| QUOTE_SHIPMENT_ID | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER | |||
| PRICE_ADJUSTMENT_ID | NUMBER | Y | ||
| CREATION_DATE | DATE | Y | ||
| CREATED_BY | NUMBER | Y | ||
| LAST_UPDATE_DATE | DATE | Y | ||
| LAST_UPDATED_BY | NUMBER | Y | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | |||
| QUOTE_HEADER_ID | NUMBER | Y | ||
| QUOTE_LINE_ID | NUMBER | |||
| MODIFIER_HEADER_ID | NUMBER | |||
| MODIFIER_LINE_ID | NUMBER | |||
| MODIFIER_LINE_TYPE_CODE | VARCHAR2 | (30) | ||
| MODIFIER_MECHANISM_TYPE_CODE | VARCHAR2 | (30) |
APPS.OKX_QTE_PRC_ADJMNTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRICE_ADJ_ATTRIB_ID | NUMBER | Y | ||
| CREATION_DATE | DATE | Y | ||
| CREATED_BY | NUMBER | Y | ||
| LAST_UPDATE_DATE | DATE | Y | ||
| LAST_UPDATED_BY | NUMBER | Y | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | |||
| PRICE_ADJUSTMENT_ID | NUMBER | Y | ||
| PRICING_CONTEXT | VARCHAR2 | (30) | Y | |
| PRICING_ATTRIBUTE | VARCHAR2 | (30) | Y | |
| PRICING_ATTR_VALUE_FROM | VARCHAR2 | (240) | ||
| PRICING_ATTR_VALUE_TO | VARCHAR2 | (240) | ||
| COMPARISON_OPERATOR | VARCHAR2 | (30) | ||
| FLEX_TITLE | VARCHAR2 | (60) | ||
| OBJECT_VERSION_NUMBER | NUMBER |
APPS.OKX_QTE_PRC_ADJ_ATRBS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ADJ_RELATIONSHIP_ID | NUMBER | Y | ||
| CREATION_DATE | DATE | Y | ||
| CREATED_BY | NUMBER | Y | ||
| LAST_UPDATE_DATE | DATE | Y | ||
| LAST_UPDATED_BY | NUMBER | Y | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | |||
| QUOTE_LINE_ID | NUMBER | |||
| PRICE_ADJUSTMENT_ID | NUMBER | Y | ||
| RLTD_PRICE_ADJ_ID | NUMBER | |||
| QUOTE_SHIPMENT_ID | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER |
APPS.OKX_QTE_PRC_ADJ_RLSHP_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRICE_ATTRIBUTE_ID | NUMBER | Y | ||
| CREATION_DATE | DATE | Y | ||
| CREATED_BY | NUMBER | Y | ||
| LAST_UPDATE_DATE | DATE | Y | ||
| LAST_UPDATED_BY | NUMBER | Y | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| REQUEST_ID | NUMBER | |||
| QUOTE_HEADER_ID | NUMBER | Y | ||
| QUOTE_LINE_ID | NUMBER | |||
| FLEX_TITLE | VARCHAR2 | (60) | ||
| PRICING_CONTEXT | VARCHAR2 | (30) | Y | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE2 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE3 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE4 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE5 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE6 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE7 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE8 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE9 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE10 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE11 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE12 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE13 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE14 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE15 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE16 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE17 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE18 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE19 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE20 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE21 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE22 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE23 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE24 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE25 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE26 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE27 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE28 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE29 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE30 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE31 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE32 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE33 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE34 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE35 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE36 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE37 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE38 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE39 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE40 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE41 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE42 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE43 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE44 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE45 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE46 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE47 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE48 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE49 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE50 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE51 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE52 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE53 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE54 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE55 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE56 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE57 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE58 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE59 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE60 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE61 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE62 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE63 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE64 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE65 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE66 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE67 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE68 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE69 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE70 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE71 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE72 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE73 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE74 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE75 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE76 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE77 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE78 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE79 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE80 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE81 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE82 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE83 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE84 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE85 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE86 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE87 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE88 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE89 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE90 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE91 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE92 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE93 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE94 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE95 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE96 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE97 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE98 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE99 | VARCHAR2 | (240) | ||
| PRICING_ATTRIBUTE100 | VARCHAR2 | (240) | ||
| CONTEXT | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| OBJECT_VERSION_NUMBER | NUMBER | |||
| OVERRIDE_FLAG | VARCHAR2 | (1) |
APPS.OKX_QTE_PRC_ATRBS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SHIPMENT_ID | NUMBER | Y | ||
| CREATION_DATE | DATE | Y | ||
| CREATED_BY | NUMBER | Y | ||
| LAST_UPDATE_DATE | DATE | Y | ||
| LAST_UPDATED_BY | NUMBER | Y | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| QUOTE_HEADER_ID | NUMBER | Y | ||
| QUOTE_LINE_ID | NUMBER | |||
| PROMISE_DATE | DATE | |||
| REQUEST_DATE | DATE | |||
| SCHEDULE_SHIP_DATE | DATE | |||
| SHIP_TO_PARTY_SITE_ID | NUMBER | |||
| SHIP_TO_PARTY_ID | NUMBER | |||
| SHIP_PARTIAL_FLAG | VARCHAR2 | (240) | ||
| SHIP_SET_ID | NUMBER | |||
| SHIP_METHOD_CODE | VARCHAR2 | (30) | ||
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | ||
| FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | ||
| FOB_CODE | VARCHAR2 | (30) | ||
| SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | ||
| PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | ||
| QUANTITY | NUMBER | |||
| RESERVED_QUANTITY | VARCHAR2 | (240) | ||
| RESERVATION_ID | NUMBER | |||
| ORDER_LINE_ID | NUMBER | |||
| SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) | ||
| SHIP_QUOTE_PRICE | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER | |||
| SHIP_TO_CUST_ACCOUNT_ID | NUMBER |
APPS.OKX_QTE_SHIPMENTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SALES_CREDIT_ID | NUMBER | Y | ||
| CREATION_DATE | DATE | Y | ||
| CREATED_BY | NUMBER | Y | ||
| LAST_UPDATED_BY | VARCHAR2 | (240) | Y | |
| LAST_UPDATE_DATE | DATE | Y | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| QUOTE_HEADER_ID | NUMBER | Y | ||
| QUOTE_LINE_ID | NUMBER | |||
| PERCENT | NUMBER | Y | ||
| RESOURCE_ID | NUMBER | Y | ||
| RESOURCE_GROUP_ID | NUMBER | |||
| SALES_CREDIT_TYPE_ID | NUMBER | |||
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | ||
| OBJECT_VERSION_NUMBER | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| EMPLOYEE_PERSON_ID | NUMBER | |||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | VARCHAR2 | (240) | ||
| ATTRIBUTE12 | VARCHAR2 | (240) | ||
| ATTRIBUTE13 | VARCHAR2 | (240) | ||
| ATTRIBUTE14 | VARCHAR2 | (240) | ||
| ATTRIBUTE15 | VARCHAR2 | (240) |
APPS.OKX_QTE_SLS_CREDITS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Unique identifier for quote | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| ORG_ID | NUMBER | Operating unit which performed this transaction | ||
| NAME | VARCHAR2 | (40) | Quote name | |
| DESCRIPTION | VARCHAR2 | (240) | Quote number. Quote number and version uniquely identifies a quote | |
| QUOTE_NUMBER | NUMBER | Y | Quote number. Quote number and version uniquely identifies a quote | |
| QUOTE_VERSION | NUMBER | Y | Quote version. Quote number and quote version uniquely identifies a quote | |
| CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency code |
| TOTAL_QUOTE_PRICE | NUMBER | Total quote price | ||
| B_STATUS | VARCHAR2 | (30) | Y | Status code |
| CONTRACT_ID | NUMBER | |||
| STATUS | VARCHAR2 | (1) | Status | |
| QUOTE_SOURCE_CODE | VARCHAR2 | (240) | Source of the quote | |
| QUOTE_EXPIRATION_DATE | DATE | Expiration date of the quote | ||
| PARTY_ID | NUMBER | Customer Identifier | ||
| CUST_ACCOUNT_ID | NUMBER | Customer Account identifier | ||
| ORG_CONTACT_ID | NUMBER | Contact identifier | ||
| ORDER_ID | NUMBER | |||
| START_DATE_ACTIVE | DATE | effective start date of quote status | ||
| ORDER_TYPE_ID | NUMBER | Order type identifier, determines the type of order to be created | ||
| END_DATE_ACTIVE | DATE | end date of quote status | ||
| PRICE_LIST_ID | NUMBER | Price list identifier | ||
| INVOICING_RULE_ID | NUMBER | Invoicing rule identifier | ||
| INVOICE_TO_PARTY_SITE_ID | NUMBER | Bill to site identifier | ||
| INVOICE_TO_PARTY_ID | NUMBER | Bill to contact identifier | ||
| EXCHANGE_RATE | NUMBER | Exchange rate | ||
| EXCHANGE_RATE_DATE | DATE | Date of exchange rate | ||
| EXCHANGE_TYPE_CODE | VARCHAR2 | (15) | Exchange type code | |
| TOTAL_LIST_PRICE | NUMBER | |||
| TOTAL_ADJUSTED_AMOUNT | NUMBER | |||
| RESOURCE_ID | NUMBER | |||
| INVOICE_TO_CUST_ACCOUNT_ID | NUMBER | |||
| LAST_UPDATE_DATE | DATE | Y |
APPS.OKX_QUOTE_HEADERS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Quote line identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| QUOTE_HEADER_ID | NUMBER | Y | Quote header identifier to which the quote line is attached | |
| ORG_ID | NUMBER | Operating unit which performed this transaction | ||
| LINE_CATEGORY_CODE | VARCHAR2 | (30) | Category Code | |
| ITEM_TYPE_CODE | VARCHAR2 | (30) | Type of item quoted on this line | |
| LINE_NUMBER | NUMBER | Line number | ||
| START_DATE_ACTIVE | DATE | Effective start date | ||
| END_DATE_ACTIVE | DATE | Effective end date | ||
| CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
| ORDER_LINE_TYPE_ID | NUMBER | Order line type identifier | ||
| ORGANIZATION_ID | NUMBER | Y | Inventory organization identifier | |
| INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
| QUANTITY | NUMBER | Y | Quantity quoted | |
| UOM_CODE | VARCHAR2 | (3) | Y | Unit of measure |
| STATUS | VARCHAR2 | (1) | ||
| NAME | VARCHAR2 | (0) | Quote line name | |
| DESCRIPTION | VARCHAR2 | (0) | Description | |
| LINE_LIST_PRICE | NUMBER | Unit price for the item | ||
| AGREEMENT_ID | NUMBER | |||
| LINE_QUOTE_PRICE | NUMBER | Summation of line list price and line adjusted amount | ||
| PRICE_LIST_ID | NUMBER | Price list identifier | ||
| PRICE_LIST_LINE_ID | NUMBER | Price list line identifier | ||
| INVOICING_RULE_ID | NUMBER | Invoicing rule identifier | ||
| INVOICE_TO_PARTY_SITE_ID | NUMBER | Bill to site identifier | ||
| INVOICE_TO_PARTY_ID | NUMBER | Bill to contact identifier | ||
| INVOICE_TO_CUST_ACCOUNT_ID | NUMBER |
APPS.OKX_QUOTE_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Quote line detail identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| QUOTE_LINE_ID | NUMBER | Y | Quote line identifier | |
| COMPONENT_CODE | VARCHAR2 | (1200) | Concatenation of component item ids | |
| SERVICE_COTERMINATE_FLAG | VARCHAR2 | (1) | Cotermination indicator for service order lines | |
| SERVICE_DURATION | NUMBER | Duration for which the product is serviced | ||
| SERVICE_PERIOD | VARCHAR2 | (3) | Period for which the product is serviced. | |
| SERVICE_UNIT_SELLING_PERCE | NUMBER | Percent actually charged to customer (percent based pricing only) | ||
| CONFIG_HEADER_ID | NUMBER | Configuration header id | ||
| SERVICE_UNIT_LIST_PERCENT | NUMBER | Price list percent of the item (percent based pricing only) | ||
| CONFIG_REVISION_NUM | NUMBER | Configuration revision number | ||
| CONFIG_ITEM_ID | NUMBER | Unique identifier for a configured item in CZ table. | ||
| COMPLETE_CONFIGURATION_FLAG | VARCHAR2 | (1) | Value is set to 'Y' if configuration is complete | |
| VALID_CONFIGURATION_FLAG | VARCHAR2 | (1) | Value set to 'Y' if configuration is valid | |
| SERVICE_NUMBER | NUMBER | service number | ||
| UNIT_PERCENT_BASE_PRICE | NUMBER | Base price used for percent based pricing | ||
| STATUS | CHAR | (1) | Status | |
| START_DATE_ACTIVE | DATE | Start date active | ||
| END_DATE_ACTIVE | DATE | End date active | ||
| NAME | VARCHAR2 | (0) | Quote line detail name | |
| DESCRIPTION | VARCHAR2 | (0) | Description | |
| SERVICE_REF_TYPE_CODE | VARCHAR2 | (30) | type of object to which the service is linked | |
| SERVICE_REF_SYSTEM_ID | NUMBER | system id | ||
| SERVICE_REF_LINE_ID | NUMBER | line id of the line to which the service is linked if the service reference is ORDER or QUOTE | ||
| SERVICE_REF_LINE_NUMBER | NUMBER | line number if the service reference is ORDER | ||
| SERVICE_REF_ORDER_NUMBER | NUMBER | order number if the service reference is ORDER |
APPS.OKX_QUOTE_LINE_DETAIL_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Id1 | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| RATE_TYPE_CODE | VARCHAR2 | (30) | Y | Rate Type Code |
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Unit Of Measure Code | |
| FLAT_RATE | NUMBER | Flat Rate | ||
| PERCENT_RATE | NUMBER | Percent Rate | ||
| NAME | VARCHAR2 | (30) | Y | Name |
| STATUS | CHAR | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (85) | Description | |
| START_DATE_ACTIVE | DATE | Date record becomes inactive | ||
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date record becomes inactive |
APPS.OKX_RATE_SCHEDULES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Primary key column. Uniquely identifies the Bank Account uses | |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (121) | Bank account name concatenated with location | |
| DESCRIPTION | VARCHAR2 | (100) | Bank account number | |
| BANK_NAME | VARCHAR2 | (360) | Bank name | |
| BANK_ACCOUNT_ID | NUMBER | (15) | Bank account identifier | |
| BANK_ACCOUNT_NUM | VARCHAR2 | (100) | Bank account number | |
| BANK_BRANCH_ID | NUMBER | Identifier for bank branch | ||
| SET_OF_BOOKS_ID | VARCHAR2 | (0) | No Longer Used | |
| CURRENCY_CODE | VARCHAR2 | (15) | Account currency code | |
| ACCOUNT_TYPE | VARCHAR2 | (30) | Bank account type code. Possible values are: INTERNAL or SUPPLIER for banks defined for Oracle Payables, INTERNAL or EXTERNAL for banks defined for Oracle Receivables and PAYROLL for banks defined for Payroll | |
| CUSTOMER_ID | NUMBER | (15) | Identifier for customer | |
| CUSTOMER_SITE_USE_ID | NUMBER | (15) | Identifier for customer site use | |
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether the record is active or inactive | |
| ORG_ID | NUMBER | (15) | Identifier for operating unit | |
| MULTI_CURRENCY_FLAG | VARCHAR2 | (0) | No Longer Used | |
| RECEIPT_MULTI_CURRENCY_FLAG | VARCHAR2 | (0) | No Longer Used | |
| CONTACT_FIRST_NAME | VARCHAR2 | (0) | No Longer Used | |
| CONTACT_MIDDLE_NAME | VARCHAR2 | (0) | No Longer Used | |
| CONTACT_LAST_NAME | VARCHAR2 | (0) | No Longer Used | |
| CONTACT_PREFIX | VARCHAR2 | (0) | No Longer Used | |
| CONTACT_TITLE | VARCHAR2 | (0) | No Longer Used | |
| CONTACT_AREA_CODE | VARCHAR2 | (0) | No Longer Used | |
| CONTACT_PHONE | VARCHAR2 | (0) | No Longer Used | |
| BANK | VARCHAR2 | (360) | Bank Name or Credit Card Issuer Name | |
| HOLDER_NAME | VARCHAR2 | (80) | Bank Account Name or Credit Card Holder Name | |
| EXPIRATION_STATUS | VARCHAR2 | (80) | Null (for bank account) Or Credit Card Expiration Status (for Credit Card) |
APPS.OKX_RCPT_METHOD_ACCOUNTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Primary key column. Uniquely identifies the customer receipt method |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (30) | Y | Receipt method name |
| DESCRIPTION | VARCHAR2 | (30) | Receipt method description | |
| CUSTOMER_ID | NUMBER | (15) | Y | Identifier for customer |
| SITE_USE_ID | NUMBER | (15) | Identifier for site use for this receipt method | |
| RECEIPT_METHOD_ID | NUMBER | (15) | Y | Identifier for receipt method |
| PRIMARY_FLAG | VARCHAR2 | (1) | Y | Indicates whether receipt method is the primary receipt method for that custome and/or site |
| START_DATE_ACTIVE | DATE | Y | Effective from date | |
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether recipt method is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code | |
| RECEIPT_CLASS_ID | NUMBER | (15) | Y | Identifier for receipt class |
| LEAD_DAYS | NUMBER | (5) | Number of days before the invoice due date that an invoice will become eligible to be selected for receipt application of automatic receipts that you create using this payment method | |
| PAYMENT_TYPE_CODE | VARCHAR2 | (30) | Payment type code |
APPS.OKX_RECEIPT_METHODS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Payment term identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| CREDIT_CHECK_FLAG | VARCHAR2 | (1) | Credit Checking flag | |
| START_DATE_ACTIVE | DATE | Y | Date record becomes active | |
| END_DATE_ACTIVE | DATE | Date record becomes inactive | ||
| DESCRIPTION | VARCHAR2 | (240) | Description of this payment term | |
| NAME | VARCHAR2 | (15) | Y | Name of this payment term |
| IN_USE | VARCHAR2 | (1) | Y | Flag to indicate whether this payment term has been referenced in a transaction |
| STATUS | VARCHAR2 | (1) | Status |
APPS.OKX_RECEIVABLES_TERMS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Unique resource identifier | ||
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| RESOURCE_NUMBER | VARCHAR2 | (30) | Resource Number | |
| RESOURCE_TYPE | VARCHAR2 | (30) | Resource category. Allowed values: Employee, Partner, Party, Supplier Contact or Others (lookup type: RESOURCE_PEOPLE_CATEGORY | |
| NAME | VARCHAR2 | (360) | Concatenation of last name, title, first name, middle names and the name the person is known by. | |
| DESCRIPTION | VARCHAR2 | (100) | Formatted address, email or telephone number used to help describe resource | |
| SOURCE_ID | NUMBER | Source identifier (foreign key to PER_ALL_PEOPLE_F) or(foreign key to HZ_PARTIES) or ( foreign key to PO_VENDOR_CONTACTS) | ||
| ADDRESS_ID | NUMBER | Address identifier (foreign key to HZ_PARTY_SITES) | ||
| CONTACT_ID | NUMBER | Contact identifier (foreign key to HZ_ORG_CONTACTS) | ||
| SUPPORT_SITE_ID | NUMBER | Support Site from Service | ||
| ORG_ID | NUMBER | Operating unit identifier | ||
| START_DATE_ACTIVE | DATE | Effective start date. | ||
| END_DATE_ACTIVE | DATE | Effective end date. | ||
| USER_ID | NUMBER | Application user identifier | ||
| B_STATUS | VARCHAR2 | (1) | Original status flag | |
| STATUS | VARCHAR2 | (1) | Status | |
| EMAIL_ADDRESS | VARCHAR2 | (2000) |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Role Relation identifier (PK) | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| RESOURCE_ID | NUMBER | Y | Resource identifier (foreign key to JTF_RESOURCE_EXTN) or (foreign key to JTF_RS_GROUPS_VL) or (foreign key to JTF_RS_GROUPS_MEMBERS or (foreign key to JTF_RS_TEAMS_VL) or (foreign key to JTF_RS_TEAM_MEMBERS) | |
| RESOURCE_TYPE | VARCHAR2 | (30) | Y | Resource type. (lookup type: JTF_RS_ ROLE_RES_TYPE) |
| ROLE_RELATE_ID | NUMBER | Y | Role Relation identifier (PK) | |
| ROLE_ID | NUMBER | Y | Role identifier (foreign key to JTF_RS_ROLES) | |
| NAME | VARCHAR2 | (60) | Y | Role name |
| DESCRIPTION | VARCHAR2 | (120) | Role Description | |
| STATUS | VARCHAR2 | (1) | Flag indicating this role is an active role or not | |
| START_DATE_ACTIVE | DATE | Y | Date this role-resource becomes active | |
| END_DATE_ACTIVE | DATE | Date this role-resource becomes inactive | ||
| ROLE_TYPE_CODE | VARCHAR2 | (240) | Y | Role type identifier ( lookup type: JTF_RS_ROLE_TYPE ) |
| ROLE_CODE | VARCHAR2 | (30) | Y | Role Code |
| DELETE_FLAG | VARCHAR2 | (1) | Delete Flag indicates whether this record is logically deleted or not? | |
| SEEDED_FLAG | VARCHAR2 | (1) | Flag indicating pre-defined role types | |
| MEMBER_FLAG | VARCHAR2 | (1) | Flag indicating this role is a member role or not | |
| ADMIN_FLAG | VARCHAR2 | (1) | Flag indicating this role is a admin role or not | |
| LEAD_FLAG | VARCHAR2 | (1) | Flag indicating this role is a leader role or not | |
| MANAGER_FLAG | VARCHAR2 | (1) | Flag indicating this role is a manager role or not |
APPS.OKX_RESOURCE_ROLES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Revenue recognition rule identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (30) | Y | Revenue recognition rule name |
| TYPE | VARCHAR2 | (10) | Y | Lookup code for 'RULE_TYPE' |
| B_STATUS | VARCHAR2 | (1) | Y | Rule status flag; lookup code for 'CODE_STATUS' |
| STATUS | VARCHAR2 | (1) | Y | Status |
| DESCRIPTION | VARCHAR2 | (80) | Description | |
| START_DATE_ACTIVE | DATE | Date before which the rule is invalid | ||
| END_DATE_ACTIVE | VARCHAR2 | (0) | Date after which the rule is invalid |
APPS.OKX_RULES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Salesrep identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| RESOURCE_ID | NUMBER | Y | Resource Identifier | |
| ORG_ID | NUMBER | Operating Unit Identifier | ||
| SET_OF_BOOKS_ID | NUMBER | Set of books identifier (not currently used) | ||
| SALES_CREDIT_TYPE_ID | NUMBER | Y | Sales Credit Type Identifier ( FK to so_sales_credit_types) | |
| PERSON_ID | NUMBER | Person id of salesrep ( In case of EMPLOYEE ) | ||
| NAME | VARCHAR2 | (360) | Salesrep name | |
| DESCRIPTION | VARCHAR2 | (0) | Email Address | |
| B_STATUS | VARCHAR2 | (30) | Salesrep status flag Lookup code for 'CODE_STATUS' | |
| STATUS | VARCHAR2 | (30) | Status | |
| START_DATE_ACTIVE | DATE | Y | Date record becomes active (not currently used) | |
| END_DATE_ACTIVE | DATE | Date record becomes inactive (not currently used) | ||
| EMAIL_ADDRESS | VARCHAR2 | (240) | Email Address |
APPS.OKX_SALESREPS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays the types of sales credit available.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Sales Credit Type Id | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (240) | Y | Transaction type name |
| DESCRIPTION | VARCHAR2 | (2000) | Description | |
| STATUS | VARCHAR2 | (1) | Enabled flag | |
| QUOTA_FLAG | VARCHAR2 | (1) | Y | Quota flag |
| ENABLED_FLAG | VARCHAR2 | (1) | Y | Flag to indicate the sales credit type is active |
| START_DATE_ACTIVE | DATE | Date record becomes active | ||
| END_DATE_ACTIVE | DATE | Date record becomes inactive |
APPS.OKX_SALES_CRED_TYPES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays information about the sets of books (Accounting Entities) you define in your Oracle General Ledger application.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
| NAME | VARCHAR2 | (30) | Y | Accounting books name |
| SHORT_NAME | VARCHAR2 | (20) | Y | Accounting books short name |
| CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency |
| MRC_SOB_TYPE_CODE | VARCHAR2 | (1) | MRC set of books type (Parent, Reporting, None) | |
| DESCRIPTION | VARCHAR2 | (240) | Accounting books description |
APPS.OKX_SET_OF_BOOKS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays information about specifications and standards.
A specification could be associated with an item, item-supplier, or item-customer.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Specification identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| ORGANIZATION_ID | NUMBER | Inventory organization Identifier | ||
| NAME | VARCHAR2 | (30) | Y | Specification name |
| START_DATE_ACTIVE | DATE | Date specification is effective from | ||
| END_DATE_ACTIVE | DATE | Date up to which specification is effective | ||
| STATUS | VARCHAR2 | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (150) | Specification element value |
APPS.OKX_SPECS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Primary key column. Unique identifier for location | |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (240) | Y | Location name |
| DESCRIPTION | VARCHAR2 | (4000) | Not used | |
| LOCATION_AREA_ID | NUMBER | Y | Unique identifier for location area | |
| ORIG_SYSTEM_REF | NUMBER | Reference code of the application which created this geographic area | ||
| ORIG_SYSTEM_ID | VARCHAR2 | (30) | Reference id of the geographic area in the originating system | |
| LOCATION_TYPE_CODE | VARCHAR2 | (30) | Y | Foreign key to JTF_LOC_TYPES_B |
| LOCATION_AREA_CODE | VARCHAR2 | (30) | The short name for the location area | |
| PARENT_LOCATION_AREA_ID | NUMBER | Identifier for the parent location area | ||
| SECURITY_GROUP_ID | NUMBER | Identifier for security group | ||
| START_DATE_ACTIVE | DATE | Y | Effective from date | |
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether record is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code |
APPS.OKX_STATES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | System identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| CUSTOMER_ID | NUMBER | Y | Customer identifier | |
| NAME | VARCHAR2 | (50) | Y | System name |
| DESCRIPTION | VARCHAR2 | (240) | System description | |
| SERIAL_NUMBER | VARCHAR2 | (30) | System number | |
| COTERMINATE_DAY_MONTH | VARCHAR2 | (6) | The day and month when every service and product under the system expires | |
| INSTALL_SITE_USE_ID | NUMBER | Installed site identifier | ||
| BILL_TO_SITE_USE_ID | NUMBER | Y | Identifier for bill-to site use | |
| START_DATE_ACTIVE | DATE | Start date for the system | ||
| END_DATE_ACTIVE | DATE | End date for the system | ||
| ORG_ID | VARCHAR2 | (0) | Operating unit identifier | |
| SHIP_TO_SITE_USE_ID | NUMBER | Y | Identifier for ship-to site use | |
| SYSTEM_TYPE_CODE | VARCHAR2 | (30) | Y | System type lookup code |
| PARENT_SYSTEM_ID | NUMBER | Parent system identifier | ||
| CONFIG_SYSTEM_TYPE | VARCHAR2 | (30) | Describes the type of system used by Oracle Product Configurator to validate configurations owned by the customer | |
| STATUS | VARCHAR2 | (1) | Status | |
| INVENTORY_ITEM_ID | VARCHAR2 | (0) | Inventory item identifier | |
| ORGANIZATION_ID | VARCHAR2 | (0) | Organization identifier | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Inventory item identifier | |
| ID2 | NUMBER | Y | Organization identifier | |
| NAME | VARCHAR2 | (240) | Item name. | |
| DESCRIPTION | VARCHAR2 | (40) | This column contains Item translated description | |
| CUSTOMER_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Y | Flag indicating item is customer orderable |
| SERVICE_ITEM_FLAG | VARCHAR2 | (1) | Y | Flag indicating service item |
| VENDOR_WARRANTY_FLAG | VARCHAR2 | (1) | Y | Flag indicating service for the item is provided by a supplier |
| SERVICEABLE_PRODUCT_FLAG | VARCHAR2 | (1) | Y | Indicates whether the item is serviceable by other service-type items and can have service requests reported against it |
| COVERAGE_TEMPLATE_ID | NUMBER | Coverage schedule identifier | ||
| ITEM_TYPE | VARCHAR2 | (30) | User-defined item type | |
| B_STATUS | VARCHAR2 | (1) | Y | Flexfield segment enabled flag |
| STATUS | VARCHAR2 | (1) | Status | |
| START_DATE_ACTIVE | DATE | Flexfield segment start date | ||
| END_DATE_ACTIVE | DATE | Flexfield segment end date | ||
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Y | Flag indicating shippable item |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure code | |
| USAGE_ITEM_FLAG | VARCHAR2 | (1) | Flag indicating an item represents usage. Usage items can be sold as a use of something | |
| SERVICE_STARTING_DELAY | NUMBER | Days after shipment that service begins | ||
| INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
| ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
| SEGMENT1 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT2 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT3 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT4 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT5 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT6 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT7 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT8 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT9 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT10 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT11 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT12 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT13 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT14 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT15 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT16 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT17 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT18 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT19 | VARCHAR2 | (40) | Key flexfield segment | |
| SEGMENT20 | VARCHAR2 | (40) | Key flexfield segment | |
| CUSTOMER_ORDER_FLAG | VARCHAR2 | (1) | Y | |
| INTERNAL_ORDER_FLAG | VARCHAR2 | (1) | Y | |
| INTERNAL_ORDER_ENABLED_FLAG | VARCHAR2 | (1) | Y | |
| INVOICEABLE_ITEM_FLAG | VARCHAR2 | (1) | Y | |
| INVOICE_ENABLED_FLAG | VARCHAR2 | (1) | Y | |
| BOM_ITEM_TYPE | NUMBER | Y | Type of item | |
| INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Y | Flag indicating inventory item |
| BOM_ENABLED_FLAG | VARCHAR2 | (1) | Y | Flag indicating item may appear on a BOM |
| LIST_PRICE_PER_UNIT | NUMBER | Unit list price - purchasing | ||
| ATP_FLAG | VARCHAR2 | (1) | Y | Flag indicating ATP must be checked when item is ordered |
| INVENTORY_ITEM_STATUS_CODE | VARCHAR2 | (10) | Y | Material status code |
| PURCHASING_ITEM_FLAG | VARCHAR2 | (1) | Y | Purchasing Item Flag |
| EXPENSE_ACCOUNT | NUMBER | Refer to column description of the base table | ||
| PURCHASING_ENABLED_FLAG | VARCHAR2 | (1) | Y | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Global descriptive flexfield structure defining column | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Global descriptive flexfield segment | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Global descriptive flexfield segment |
MultiLingual view (a language resolved view of the data.)
Displays tax codes and rates.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Unique identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (50) | Y | The tax code associated with a rate user specified in the Tax Codes and Rates window |
| TAX_RATE | NUMBER | The tax rate associated with the tax code the user specified in the Tax Codes and Rates window | ||
| TAX_TYPE | VARCHAR2 | (30) | Y | This is a lookup column that uses the lookup_type TAX_TYPE. |
| START_DATE_ACTIVE | DATE | Y | First date that the tax code is active | |
| END_DATE_ACTIVE | DATE | Last date that the tax code is active | ||
| DESCRIPTION | VARCHAR2 | (60) | Description of tax code (legal requirement in Italy) | |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Y | The unique identifier of the set of book |
| PRINTED_TAX_NAME | VARCHAR2 | (60) | The name of this tax code as it appears on the printed invoice | |
| VALIDATE_FLAG | VARCHAR2 | (1) | Indicates whether the tax code is of type Ad Hoc | |
| B_STATUS | VARCHAR2 | (1) | Y or N indicates whether the tax code is enabled. This field is used in conjunction with START_DATE and END_DATE and allows the tax code to be enabled/disabled even for the start date specified in the START_DATE field. | |
| STATUS | VARCHAR2 | (1) | Status | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | When this flag is set to 'Y', the tax code is inclusive by default. Otherwise, it is exclusive. | |
| AMOUNT_INCLUDES_TAX_OVERRIDE | VARCHAR2 | (1) | When this flag is set to 'Y', the value of AMOUNT_INCLUDES_TAX_FLAG can be overridden at time of usage. Otherwise, the AMOUNT_INCLUDES_TAX_FLAG at the tax code level must be used. |
APPS.OKX_TAX_CODES_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
This table stores tax exemptions for either customers, sites or items.
Each tax exemption is for a particular tax code and a particular percentage of exemption.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | (15) | Y | Internal Exemption Identifier |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| APPROVAL_STATUS | VARCHAR2 | (30) | Y | Approval Status for this exemption |
| NAME | VARCHAR2 | (30) | Y | Exemptions can be for Customers at a location, or for Items at a location, but not Customers and Items at a location. |
| TAX_CODE | VARCHAR2 | (50) | Y | Tax Code to which this exemption applies |
| PERCENT_EXEMPT | NUMBER | Y | 100% means that this is a full exemption from tax | |
| START_DATE_ACTIVE | DATE | Y | First date that this exemption is effective | |
| END_DATE_ACTIVE | DATE | Last date that this exemption is effective | ||
| B_STATUS | VARCHAR2 | (30) | Y | Approval Status for this exemption |
| STATUS | VARCHAR2 | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (30) | The reason for this exemption | |
| ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
| INVENTORY_ITEM_ID | NUMBER | (15) | Inventory Item for which this exemption applies | |
| CUSTOMER_ID | NUMBER | (15) | Ship to Customer for whom this exemption applies | |
| SITE_USE_ID | NUMBER | (15) | Ship to Site Use for which this exemption applies | |
| CUSTOMER_EXCEPTION_NUMBER | VARCHAR2 | (80) | Exemption certificate number | |
| IN_USE_FLAG | VARCHAR2 | (1) | Y | In Use Flag |
APPS.OKX_TAX_EXEMPTIONS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Displays information about timezones.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TIMEZONE_ID | NUMBER | (15) | Y | Primary Key |
| GLOBAL_TIMEZONE_NAME | VARCHAR2 | (50) | Y | Global Timezone Name which associates with a value of GMT Deviation Hour |
| GMT_DEVIATION_HOURS | NUMBER | Y | Deviation Hours from Greenwich Mean Time | |
| DAYLIGHT_SAVINGS_TIME_FLAG | VARCHAR2 | (1) | Y | Deviation Hours from Greenwich Mean Time |
| BEGIN_DST_MONTH | VARCHAR2 | (3) | Month in which daylight savings begin | |
| BEGIN_DST_DAY | NUMBER | Day of the Month daylight savings begin | ||
| BEGIN_DST_WEEK_OF_MONTH | NUMBER | Week of the Month daylight savings begin | ||
| BEGIN_DST_DAY_OF_MONTH | NUMBER | Day of the Week daylight savings begin | ||
| BEGIN_DST_HOUR | NUMBER | Hour of the day daylight savings begin | ||
| END_DST_MONTH | VARCHAR2 | (3) | Month in which daylight savings end | |
| END_DST_DAY | NUMBER | Day of the Month daylight savings end | ||
| END_DST_WEEK_OF_MONTH | NUMBER | Week of the Month daylight savings end | ||
| END_DAY_OF_WEEK | NUMBER | Day of the Week daylight savings end | ||
| END_DST_HOUR | NUMBER | Hour of the day daylight savings end | ||
| NAME | VARCHAR2 | (80) | Y | Timezone Name associated with a timezone id |
| DESCRIPTION | VARCHAR2 | (80) | Y | Description |
APPS.OKX_TIMEZONES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_TYPE_ID | NUMBER | (15) | Y | Unique identifier |
| NAME | VARCHAR2 | (90) | Y | Transaction type name |
| DESCRIPTION | VARCHAR2 | (720) | Description of the Transaction type | |
| END_DATE_ACTIVE | DATE | Date this transaction type becomes inactive, if limited | ||
| START_DATE_ACTIVE | DATE | Date this transaction type becomes active, if limited |
APPS.OKX_TRANSACTION_TYPES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | VARCHAR2 | (3) | Y | Primary key column. Abbreviated unit of measure code |
| ID2 | CHAR | (1) | Primary key column | |
| NAME | VARCHAR2 | (25) | Y | Unit of measure name |
| DESCRIPTION | VARCHAR2 | (50) | Description | |
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Y | Unit of measure name |
| UOM_CODE | VARCHAR2 | (3) | Y | Abbreviated unit of measure code |
| UOM_CLASS | VARCHAR2 | (10) | Y | Unit of measure class |
| BASE_UOM_FLAG | VARCHAR2 | (1) | Y | Base unit of measure flag |
| UNIT_OF_MEASURE_TL | VARCHAR2 | (25) | Y | Unit of measure name translation |
| SOURCE_LANG | VARCHAR2 | (4) | Y | SOURCE_LANG indicated the Actual language code of the row |
| START_DATE_ACTIVE | DATE | Effective from date | ||
| END_DATE_ACTIVE | DATE | Effective to date | ||
| STATUS | VARCHAR2 | (1) | Indicates whether uom code is active or inactive | |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Y | Primary unit of measure code |
APPS.OKX_TUOM_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | ||
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| BILLING_TYPE | VARCHAR2 | (30) | Y | |
| TRANSACTION_TYPE_ID | NUMBER | Y | ||
| STATUS | VARCHAR2 | (1) | Status | |
| NAME | VARCHAR2 | (90) | Y | Transaction type |
| DESCRIPTION | VARCHAR2 | (720) | Description of the Transaction type | |
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| INVENTORY_ITEM_ID | VARCHAR2 | (0) | Inventory item identifier | |
| ORGANIZATION_ID | VARCHAR2 | (0) | Organization identifier | |
| PRIMARY_UOM_CODE | VARCHAR2 | (0) | Primary unit of measure code |
APPS.OKX_TXN_BILLING_TYPES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Y | Unit of measure name |
| UOM_CODE | VARCHAR2 | (3) | Y | Abbreviated unit of measure code |
| UOM_CLASS | VARCHAR2 | (10) | Y | Unit of measure class |
| DISABLE_DATE | DATE | Date when the unit can no longer be used to define conversions | ||
| DESCRIPTION | VARCHAR2 | (50) | Unit of measure description | |
| UNIT_OF_MEASURE_TL | VARCHAR2 | (25) | Y | Unit of measure name translation |
APPS.OKX_UNITS_OF_MEASURE_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| UOM_CLASS | VARCHAR2 | (10) | Y | Unit of measure class name (eg, volume, weight) |
| DESCRIPTION | VARCHAR2 | (50) | Class description |
APPS.OKX_UOM_CLASSES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Supplier unique identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| NAME | VARCHAR2 | (240) | Supplier name | |
| B_STATUS | VARCHAR2 | (1) | Y | Key flexfield summary flag |
| STATUS | VARCHAR2 | (1) | Status | |
| START_DATE_ACTIVE | DATE | Key flexfield start date | ||
| END_DATE_ACTIVE | DATE | Key flexfield end date | ||
| MINORITY_GROUP_LOOKUP | VARCHAR2 | (30) | Type of minority-owned business | |
| WOMEN_OWNED_FLAG | VARCHAR2 | (1) | Indicates whether the supplier is a woman-owned business or not | |
| SMALL_BUSINESS_FLAG | VARCHAR2 | (1) | Indicates that the supplier is a small business | |
| DESCRIPTION | VARCHAR2 | (30) | Y | Supplier number |
| SET_OF_BOOKS_ID | NUMBER | Set of Books unique identifier | ||
| PARTY_NUMBER | VARCHAR2 | (30) | Y | Supplier number |
| ADDRESS | VARCHAR2 | (0) | Supplier's address | |
| VENDOR_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | ||
| COUNTRY | VARCHAR2 | (0) | ||
| ADDRESS1 | VARCHAR2 | (0) | ||
| ADDRESS2 | VARCHAR2 | (0) | ||
| ADDRESS3 | VARCHAR2 | (0) | ||
| ADDRESS4 | VARCHAR2 | (0) | ||
| POSTAL_CODE | VARCHAR2 | (0) | ||
| STATE | VARCHAR2 | (0) | ||
| COUNTY | VARCHAR2 | (0) | ||
| CITY | VARCHAR2 | (0) |
APPS.OKX_VENDORS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Supplier contact unique identifier | ||
| ID2 | CHAR | (1) | Not used | |
| VENDOR_SITE_ID | NUMBER | Supplier site unique identifier | ||
| NAME | VARCHAR2 | (31) | Contact last name | |
| END_DATE_ACTIVE | DATE | Date at which the contact is inactive | ||
| START_DATE_ACTIVE | DATE | Date at which the contact is active | ||
| STATUS | VARCHAR2 | (1) | Contact status flag | |
| DESCRIPTION | VARCHAR2 | (71) | Contact description | |
| PHONE | VARCHAR2 | (40) | Contact phone number | |
| PARTY_ID | NUMBER | Y | Contact's party identifier (Primary key) | |
| PARTY_ID2 | CHAR | (1) | Contact's party identifier (Multi-part primary key) | |
| ORG_ID | NUMBER | Operating unit unique identifier | ||
| EMAIL_ADDRESS | VARCHAR2 | (2000) |
APPS.OKX_VENDOR_CONTACTS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID1 | NUMBER | Y | Supplier site unique identifier | |
| ID2 | CHAR | (1) | (Multi-part) Primary Key | |
| VENDOR_ID | NUMBER | Y | Supplier unique identifier | |
| NAME | VARCHAR2 | (15) | Site code name | |
| ORG_ID | NUMBER | Operating unit unique identifier | ||
| END_DATE_ACTIVE | DATE | Inactive date for record | ||
| START_DATE_ACTIVE | DATE | Active date for record | ||
| STATUS | VARCHAR2 | (1) | Status | |
| DESCRIPTION | VARCHAR2 | (80) | Formatted address | |
| PAY_SITE_FLAG | VARCHAR2 | (1) | Indicates whether you can send payments to this site | |
| PARTY_ID | NUMBER | Y | Supplier unique identifier | |
| PARTY_ID2 | CHAR | (1) | Supplier unique identifier (Multi-part primary key) |
APPS.OKX_VENDOR_SITES_V is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |