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.
Description: | This table will store that product-ingredient associations which support |
---|
This table will store that product-ingredient associations which support
The PMI Lot Genealogy Views. These associations cover both direct and indirect
product-ingredient associations. This table is populated by the package PMI_LOT_GENEALOGY_PKG.
Index | Type | Tablespace | Column |
---|---|---|---|
PK_BATCH_STATUS | UNIQUE | APPS_TS_SUMMARY |
PLANT_CODE
WHSE_CODE FISCAL_YEAR PERIOD_NUM ITEM_ID BATCH_STATUS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | Company Code | |
PLANT_CODE | VARCHAR2 | (4) | Y | Plant Code |
WHSE_CODE | VARCHAR2 | (4) | Y | Warehouse Code |
FISCAL_YEAR | NUMBER | (15) | Y | Fiscal Year |
PERIOD_NUM | NUMBER | (15) | Y | Period |
PERIOD_NAME | VARCHAR2 | (15) | Period Name | |
ITEM_ID | NUMBER | (10) | Y | Item Surrogate key |
BATCH_STATUS_CODE | VARCHAR2 | (30) | Y | Batch status code |
BATCH_COUNT | NUMBER | (15) | Number of batches of the status on batch_status_code | |
LAST_UPDATE_DATE | DATE | Last Update date |
PMI.PMI_BATCH_STATUS does not reference any database object
PMI.PMI_BATCH_STATUS is referenced by following:
Description: | This table will store that product-ingredient which support the PMI Lot Genealogy Views |
---|
This table will store that product-ingredient which support the PMI Lot Genealogy Views. These associations cover both direct and indirect product-ingredient associations.
Index | Type | Tablespace | Column |
---|---|---|---|
PMI_LOT_GENEALOGY_PK | UNIQUE | APPS_TS_SUMMARY |
PRODUCT_LOT_ID
INGRED_LOT_ID |
PMI_LOT_GENEALOGY_I2 | NONUNIQUE | APPS_TS_SUMMARY | INGRED_LOT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | the item number of a lot that contains the ingredient lot | ||
PRODUCT_LOT_ID | NUMBER | Y | the lot number of a lot that contains the ingredient lot | |
INGRED_ITEM_ID | NUMBER | the item number of a lot that is contained in the product lot | ||
INGRED_LOT_ID | NUMBER | Y | the lot number of a lot that is containted in the produc lot | |
ASSOCIATION_COUNT | NUMBER | the number of physical associations for this distinct association |
PMI.PMI_LOT_GENEALOGY does not reference any database object
PMI.PMI_LOT_GENEALOGY is referenced by following:
Description: | Summary table for OPM transactions related with inventory and sales. |
---|
This table hold the summary of total Inventory . The summary consists of
On-Hand inventory and value, Sold inventory and value, Returned
inventory and value at Fiscal year,Quarter,Period,Warehouse level. The
Quanatities are calculated ina common UOM.This data is populated by a
Concurrent program 'PMI OnHand Sales Summary' registered under Process
Manufacturing Intelligence. This Table is used by Process Manufacturing
Intelligence reports and KPI.
Index | Type | Tablespace | Column |
---|---|---|---|
PMI_ONHAND_SALE_SUM_PK | UNIQUE | APPS_TS_SUMMARY |
FISCAL_YEAR
ORGN_CODE WHSE_CODE PERIOD_ID ITEM_ID |
PMI_ONHAND_SALE_SUM_I1 | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_ID
FISCAL_YEAR |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FISCAL_YEAR | VARCHAR2 | (4) | Y | GL Fiscal Year |
CO_CODE | VARCHAR2 | (4) | Company Code | |
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
WHSE_CODE | VARCHAR2 | (4) | Y | Warehouse Code |
PERIOD_ID | NUMBER | (10) | Y | Period ID |
QUARTER | NUMBER | (15) | GL Calendar Quarter | |
PERIOD | NUMBER | (15) | GL Calendar Period | |
CONVERTIBLE_UOM | VARCHAR2 | (4) | To convert entire data into single UOM | |
ITEM_ID | NUMBER | (10) | Y | Item ID |
ITEM_NO | VARCHAR2 | (32) | Item Name | |
ITEM_UM | VARCHAR2 | (4) | Item UOM | |
WHSE_ONHAND_QTY | NUMBER | Warehouse On-Hand Quantity in Primary UOM | ||
WHSE_ONHAND_CONV | NUMBER | Warehouse On-Hand Quantity in Converted UOM | ||
WHSE_ONHAND_VALUE | NUMBER | Warehouse On-Hand Inventory Value | ||
WHSE_SALE_QTY | NUMBER | Warehouse Sale Quantity in Primary UOM | ||
WHSE_SALE_CONV | NUMBER | Warehouse Sale Quantity in Converted UOM | ||
WHSE_SALE_VALUE | NUMBER | Warehouse Sale Inventory Value | ||
WHSE_RTRN_QTY | NUMBER | Warehouse Return Quantity in Primary UOM | ||
WHSE_RTRN_CONV | NUMBER | Warehouse Return Quantity in Converted UOM | ||
WHSE_RTRN_VALUE | NUMBER | Warehouse Return Inventory Value | ||
LOG_END_DATE | DATE | Last Populated Date | ||
PERIOD_IND | NUMBER | Period Indicator which indicates whether the period is open/closed (preliminary/final) | ||
WHSE_NAME | VARCHAR2 | (40) | Warehouse Name | |
ORGN_NAME | VARCHAR2 | (40) | Organization name | |
PERIOD_NAME | VARCHAR2 | (40) | GL Period Name | |
QUARTER_NAME | VARCHAR2 | (40) | GL Quarter Name | |
PERIOD_SET_NAME | VARCHAR2 | (40) | GL Period Set Name | |
GL_PERIOD_YEAR | NUMBER | (15) | GL Period Year | |
GL_FISCAL_YEAR_NAME | VARCHAR2 | (15) | Gl Fiscal Year Name | |
GL_PERIOD_END_DATE | DATE | GL Period End Date | ||
GL_PERIOD_START_DATE | DATE | GL Period Start Date | ||
MISS_CONV_FACT_CNT | NUMBER | This column is required to show visual queue on the reports | ||
GL_FISCAL_YEAR | NUMBER | (15) | GL Fiscal Year |
PMI.PMI_ONHAND_SALE_SUM does not reference any database object
PMI.PMI_ONHAND_SALE_SUM is referenced by following:
Description: |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FISCAL_YEAR | VARCHAR2 | (4) | ||
CO_CODE | VARCHAR2 | (4) | ||
ORGN_CODE | VARCHAR2 | (4) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
PERIOD_ID | NUMBER | (10) | ||
QUARTER | NUMBER | (15) | ||
PERIOD | NUMBER | (15) | ||
CONVERTIBLE_UOM | VARCHAR2 | (4) | ||
ITEM_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | ||
ITEM_UM | VARCHAR2 | (4) | ||
WHSE_ONHAND_QTY | NUMBER | |||
WHSE_ONHAND_CONV | NUMBER | |||
WHSE_ONHAND_VALUE | NUMBER | |||
WHSE_SALE_QTY | NUMBER | |||
WHSE_SALE_CONV | NUMBER | |||
WHSE_SALE_VALUE | NUMBER | |||
WHSE_RTRN_QTY | NUMBER | |||
WHSE_RTRN_CONV | NUMBER | |||
WHSE_RTRN_VALUE | NUMBER | |||
LOG_END_DATE | DATE | |||
PERIOD_IND | NUMBER | |||
WHSE_NAME | VARCHAR2 | (40) | ||
ORGN_NAME | VARCHAR2 | (40) | ||
PERIOD_NAME | VARCHAR2 | (40) | ||
QUARTER_NAME | VARCHAR2 | (40) | ||
PERIOD_SET_NAME | VARCHAR2 | (40) | ||
GL_PERIOD_YEAR | NUMBER | (15) | ||
GL_FISCAL_YEAR_NAME | VARCHAR2 | (15) | ||
GL_PERIOD_END_DATE | DATE | |||
GL_PERIOD_START_DATE | DATE | |||
MISS_CONV_FACT_CNT | NUMBER |
PMI.PMI_ONHAND_SALE_SUM_CUR_TEMP does not reference any database object
PMI.PMI_ONHAND_SALE_SUM_CUR_TEMP is referenced by following:
Description: |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FISCAL_YEAR | VARCHAR2 | (4) | ||
CO_CODE | VARCHAR2 | (4) | ||
ORGN_CODE | VARCHAR2 | (4) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
PERIOD_ID | NUMBER | (10) | ||
QUARTER | NUMBER | (15) | ||
PERIOD | NUMBER | (15) | ||
CONVERTIBLE_UOM | VARCHAR2 | (4) | ||
ITEM_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | ||
ITEM_UM | VARCHAR2 | (4) | ||
WHSE_ONHAND_QTY | NUMBER | |||
WHSE_ONHAND_CONV | NUMBER | |||
WHSE_ONHAND_VALUE | NUMBER | |||
WHSE_SALE_QTY | NUMBER | |||
WHSE_SALE_CONV | NUMBER | |||
WHSE_SALE_VALUE | NUMBER | |||
WHSE_RTRN_QTY | NUMBER | |||
WHSE_RTRN_CONV | NUMBER | |||
WHSE_RTRN_VALUE | NUMBER | |||
LOG_END_DATE | DATE | |||
PERIOD_IND | NUMBER | |||
WHSE_NAME | VARCHAR2 | (40) | ||
ORGN_NAME | VARCHAR2 | (40) | ||
PERIOD_NAME | VARCHAR2 | (40) | ||
QUARTER_NAME | VARCHAR2 | (40) | ||
PERIOD_SET_NAME | VARCHAR2 | (40) | ||
GL_PERIOD_YEAR | NUMBER | (15) | ||
GL_FISCAL_YEAR_NAME | VARCHAR2 | (15) | ||
GL_PERIOD_END_DATE | DATE | |||
GL_PERIOD_START_DATE | DATE | |||
MISS_CONV_FACT_CNT | NUMBER |
PMI.PMI_ONHAND_SALE_SUM_TEMP does not reference any database object
PMI.PMI_ONHAND_SALE_SUM_TEMP is referenced by following:
Description: |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WHSE_CODE | VARCHAR2 | (4) | ||
ITEM_ID | NUMBER | (10) | ||
PERD_TRANS_QTY | NUMBER | |||
PERD_SALES_QTY | NUMBER |
PMI.PMI_PERD_TRANS_SUM_TEMP does not reference any database object
PMI.PMI_PERD_TRANS_SUM_TEMP is referenced by following:
Description: | Summary table for OPM transactions related with production |
---|
This table hold the summary of total Production usage and yield . The
summary consists of Production Usage and value, Produciton Yield and
value at Fiscal year,Quarter,Period,Warehouse level. The Quanatities are
calculated ina common UOM. This data is populated by a Concurrent
program 'PMI Production Summary' registered under Process Manufacturing
Intelligence. This Table is used by Process Manufacturing Intelligence
reports .
Index | Type | Tablespace | Column |
---|---|---|---|
PMI_PROD_SUM_PK | UNIQUE | APPS_TS_SUMMARY |
FISCAL_YEAR
ORGN_CODE WHSE_CODE PERIOD_ID ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FISCAL_YEAR | VARCHAR2 | (4) | Y | GL Fiscal Year |
CO_CODE | VARCHAR2 | (4) | Company Code | |
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
WHSE_CODE | VARCHAR2 | (4) | Y | Warehouse Code |
PERIOD_ID | NUMBER | (10) | Y | Period ID |
QUARTER | NUMBER | (15) | GL Calendar Quarter | |
PERIOD | NUMBER | (15) | GL Calendar Period | |
CONVERTIBLE_UOM | VARCHAR2 | (4) | To convert entire data into single UOM | |
ITEM_ID | NUMBER | (10) | Y | Item ID |
ITEM_NO | VARCHAR2 | (32) | Item Name | |
ITEM_UM | VARCHAR2 | (4) | Item Primary UOM | |
WHSE_USAGE_QTY | NUMBER | Warehouse Usage Quantity in Primary UOM | ||
WHSE_USAGE_CONV | NUMBER | Warehouse Usage Quantity in Converted UOM | ||
WHSE_USAGE_VALUE | NUMBER | Warehouse Usage Inventory Value | ||
WHSE_YIELD_QTY | NUMBER | Warehouse Yield Quantity in Primary UOM | ||
WHSE_YIELD_CONV | NUMBER | Warehouse Usage Quantity in Converted UOM | ||
WHSE_YIELD_VALUE | NUMBER | Warehouse Yield Inventory Value | ||
LOG_END_DATE | DATE | Last Populated Date | ||
PERIOD_IND | NUMBER | Period Indicator which indicates whether the period is open/closed (preliminary/final) | ||
WHSE_NAME | VARCHAR2 | (40) | Warehouse Name | |
ORGN_NAME | VARCHAR2 | (40) | Organization Name | |
PERIOD_NAME | VARCHAR2 | (40) | GL Period Name | |
QUARTER_NAME | VARCHAR2 | (40) | GL Quarter Name | |
PERIOD_SET_NAME | VARCHAR2 | (40) | GL Period Set Name | |
GL_PERIOD_YEAR | NUMBER | (15) | GL Period Year | |
GL_FISCAL_YEAR_NAME | VARCHAR2 | (15) | GL Fiscal Year Name | |
GL_PERIOD_START_DATE | DATE | GL Period Start Date | ||
GL_PERIOD_END_DATE | DATE | GL Period End Date | ||
MISS_CONV_FACT_CNT | NUMBER | This column is required to show visual queue on the reports. | ||
GL_FISCAL_YEAR | NUMBER | (15) | GL Fiscal Year |
PMI.PMI_PROD_SUM does not reference any database object
PMI.PMI_PROD_SUM is referenced by following:
Description: |
---|
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Index | Type | Tablespace | Column |
---|---|---|---|
PMI_SUMMARY_LOG_TABLE_U | UNIQUE | APPS_TS_INTERFACE | SUMMARY_TABLE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_TABLE | VARCHAR2 | (40) | Y | |
LAST_RUN_DATE | DATE | |||
ATTR1 | VARCHAR2 | (40) | ||
ATTR2 | VARCHAR2 | (40) | ||
ATTR3 | VARCHAR2 | (40) | ||
ATTR4 | VARCHAR2 | (40) | ||
ATTR5 | VARCHAR2 | (40) | ||
ATTR6 | VARCHAR2 | (40) |
PMI.PMI_SUMMARY_LOG_TABLE does not reference any database object
PMI.PMI_SUMMARY_LOG_TABLE is referenced by following:
A Business Intelligence System view
Info. on a batch and ingredients, prods, and byprods of that batch.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (10) | Y | Surrogate key to FPO or batch. |
PLANT_CODE | VARCHAR2 | (4) | Production organization in which the batch or FPO is/was/will be run. | |
BATCH_NUMBER | VARCHAR2 | (32) | Y | Batch or FPO number. |
BATCH_TYPE | NUMBER | (5) | Y | Differentiates between Firm Planned Order(10) and batches (0). |
PRODUCTION_ID | NUMBER | (10) | Reserved for future use. Used for tying multiple batches to a campaign/prod ord. When used, validate against PM_PROD_MST. | |
PRODUCTION_SEQUENCE | NUMBER | (5) | Y | Reserved for future use. Batch sequence in campaign/prod order. |
FORMULA_ID | NUMBER | (10) | Surrogate key to formula on which batch or FPO is based. | |
ROUTING_ID | NUMBER | (10) | Surrogate key to routing used. | |
PLAN_START_DATE | DATE | Y | Planned release date/time for batch. | |
ACTUAL_START_DATE | DATE | Actual start date/time for batch. | ||
DUE_DATE | DATE | Y | Required batch completion date/time, notational. | |
EXPECT_COMPLETION_DATE | DATE | Y | Planned batch completion date/time. | |
ACTUAL_COMPLETION_DATE | DATE | Actual completion date. | ||
BATCH_STATUS | NUMBER | (5) | Y | Batch or FPO status. -3=Converted FPO, -1=Cancelled,1=Pending; 2=WIP; 3=Certified; 4=Closed. |
PRIORITY_VALUE | NUMBER | Y | Not currently used. | |
PRIORITY_CODE | VARCHAR2 | (4) | Y | Not currently used. |
PRINT_COUNT | NUMBER | (5) | Y | Number of times batch ticket was printed. |
FORMULA_EFFECTIVITY_ID | NUMBER | (10) | Surrogate key to the formula effectivity the batch or FPO was based on. | |
FMCONTROL_CLASS | VARCHAR2 | (8) | Not currently used. | |
WIP_WAREHOUSEE_CODE | VARCHAR2 | (4) | Warehouse used to cost production activity. | |
BATCH_CLOSE_DATE | DATE | Date/time the batch was closed. | ||
PARENTLINE_ID | NUMBER | (10) | For phantom batches. Surrogate key to the batch ingredient line for which this phantom batch produces product. | |
CREATED_BY | NUMBER | (10) | Y | Standard who column |
CREATION_DATE | NUMBER | (10) | Standard who column | |
LAST_UPDATE_DATE | NUMBER | (5) | Y | Standard who column |
LAST_UPDATED_BY | NUMBER | (10) | Standard who column | |
LINE_ID | NUMBER | (5) | Y | Key that uniquely identifies a batch or FPO line. |
FORMULALINE_ID | VARCHAR2 | (80) | Surrogate key to the formula line on which the batch line was based, if any. | |
LINE_NO | NUMBER | Y | Sequential line number for each line type in a batch or FPO. | |
ITEM_ID | VARCHAR2 | (0) | Surrogate key to the item that is a product, ingredient, or byproduct. | |
LINE_TYPE | VARCHAR2 | (4) | -1=Ingredient; 1=Product; 2=Byproduct. | |
LINE_TYPE_MEANING | VARCHAR2 | (4) | -1=Ingredient; 1=Product; 2=Byproduct. | |
PLAN_QTY | NUMBER | Y | The quantity that this line was planned to produce or consume, in the batch UOM (item_um column). | |
PLAN_QTY2 | VARCHAR2 | (0) | The quantity that this line was planned to produce or consume, in the secondary UOM of an item(for dual UOM items). | |
ITEM_UOM | NUMBER | (5) | Y | UOM in which planned and actual qty is entered on the batch. |
ITEM_UOM2 | NUMBER | Y | Secondary UOM of item. | |
ACTUAL_QTY | NUMBER | (5) | Y | Sum (trans_qty) of completed transactions for line, in the batch UOM. |
ACTUAL_QTY2 | NUMBER | (5) | Y | Sum (trans_qty) of completed transactions for line, in the secondary UOM of an item(for dual UOM items). |
RELEASE_TYPE | NUMBER | Release (or certification) type. 0=Automatic release (certification), 1=Manual release (certification). | ||
SCRAP_FACTOR | NUMBER | (5) | Scrap factor decimal used to a trans_qty that allows for scrap. | |
SCALE_TYPE | NUMBER | 0=Fixed qty (non-scalable), 1=Linear scaling. | ||
PHANTOM_TYPE | NUMBER | (10) | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. | |
COST_ALLOC | NUMBER | (15) | Y | For products, fraction of cost allocated to this product. |
ALLOC_IND | DATE | Y | Allocation indicator. 0=Not fully allocated, 1=Fully allocated. | |
COST | DATE | Y | Not currently used. | |
PHANTOM_ID | NUMBER | Y | For phantoms. Surrogate key of the phantom batch which produces the ingredient. |
APPS.PMIBV_BATCH_MATERIAL_V is not referenced by any database object
A Business Intelligence System view
Costing information for Burden (overhead) details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BURDEN_QTY | NUMBER | Y | Quantity of Burden used in calculating the burden cost | |
BURDEN_USAGE | NUMBER | Y | Burden Usage - used in calculating the burden cost | |
BURDEN_UM | VARCHAR2 | (4) | Burden uom used in calculating the burden cost | |
BURDEN_FACTOR | NUMBER | Y | Burden factor used in calculating the burden cost | |
ROLLOVER_IND | NUMBER | (5) | Indicates if the burden cost has been frozen or not - 0 = not frozen | |
ITEM_QTY | NUMBER | Y | Quantity of item used in calculating the burden cost | |
ITEM_UM | VARCHAR2 | (4) | Item uom used in calculating the burden cost | |
BURDENLINE_ID | NUMBER | (10) | Y | Surrogate for this burden line. (also posted to cm_acst_led.transline_id by Actual Cost Process) |
ORGN_CODE | VARCHAR2 | (4) | Organization for the burden | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse | |
ITEM_ID | NUMBER | (10) | Surrogate for item | |
RESOURCES | VARCHAR2 | (16) | Y | Resource used for the burden cost |
CALENDAR_CODE | VARCHAR2 | (4) | Cost Calendar | |
PERIOD_CODE | VARCHAR2 | (4) | Cost Period - specifies the start and end dates for the burden cost | |
COST_MTHD_CODE | VARCHAR2 | (4) | Specific costing method that the burden cost will be applied under | |
COST_CMPNTCLS_ID | NUMBER | (10) | Y | Surrogate for component class |
CMPNTCOST_ID | NUMBER | (10) | Surrogate to cost component details | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Y | Analysis code |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column |
APPS.PMIBV_BURDEN_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Plant
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
ORGN_NAME | VARCHAR2 | (40) | Y | Organization Name |
APPS.PMIBV_COMPANY_LOV_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Cost Calendar Period
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_CODE | VARCHAR2 | (10) | Y | Calendar Code |
PERIOD_CODE | VARCHAR2 | (10) | Y | Calendar Period Code |
PERIOD_DESC | VARCHAR2 | (40) | Y | Calendar Period Description |
START_DATE | DATE | Y | ||
END_DATE | DATE | Y |
APPS.PMIBV_COSTCALPERIOD_LOV_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Cost Calendar
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_CODE | VARCHAR2 | (10) | Y | Calendar Code |
CALENDAR_DESC | VARCHAR2 | (40) | Y | Calendar Description |
APPS.PMIBV_COSTCAL_LOV_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Cost Method
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COST_MTHD_CODE | VARCHAR2 | (10) | Y | Cost Method Code |
COST_MTHD_DESC | VARCHAR2 | (40) | Y | Cost Method Description |
APPS.PMIBV_COSTMETHOD_LOV_V is not referenced by any database object
A Business Intelligence System view
Qty and availability info for Items in Inv at the present time by warehouse, loc, lot and item.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QTY_ONHAND | NUMBER | Current onhand quantity of the item/lot/sublot in the warehouse/location, expressed in the primary unit of measure for the item. | ||
QTY_ONHAND_IN_UOM2 | NUMBER | Current onhand quantity of the item/lot/sublot in the warehouse/location, expressed in the secondary unit of measure for the item, for dual UOM items. | ||
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse in which the item is located. | |
LOT_ID | NUMBER | (10) | Y | Surrogate key for the lot/sublot. 0 identifies the default lot. LOT_ID is set to '0' for items without lot control. |
LOCATION | VARCHAR2 | (16) | Location in which the item is located. | |
ITEM_ID | NUMBER | (10) | Y | Surrogate key for the item. |
LOT_STATUS | VARCHAR2 | (4) | Status of the lot in the warehouse/location. | |
QC_HOLD_REASON_CODE | VARCHAR2 | (4) | QC hold reason code. | |
LAST_UPDATED_BY | VARCHAR2 | (32) | Y | Standard who column |
CREATED_BY | VARCHAR2 | (32) | Standard who column | |
LAST_UPDATE_DATE | VARCHAR2 | (4) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LOT_NUMBER | DATE | Y | Code for the lot. | |
SUBLOT_NUMBER | VARCHAR2 | (32) | Code for the sublot. | |
QC_GRADE | NUMBER | (15) | QC grade of the lot. | |
LOT_EXPIRE_DATE | NUMBER | (15) | Lot expiration date. | |
LOT_CREATION_DATE | DATE | Standard who column | ||
VENDOR_LOT_NUMBER | DATE | Vendor lot number. |
APPS.PMIBV_CURRENTINVENTORY_V is not referenced by any database object
A Business Intelligence System view
Costing Information for product by formula
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_NO | VARCHAR2 | (32) | Y | Alphanumeric formula name or number. |
FORMULA_VERSION | NUMBER | Y | Formula version. | |
FORMULA_TYPE | NUMBER | (5) | Y | 0=std formula; 1=packaged item formula (these are not currently used). |
FORMULE_TYPE_MEANING | VARCHAR2 | (80) | 0=std formula; 1=packaged item formula (these are not currently used). | |
SCALE_TYPE | NUMBER | (5) | Y | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
FORMULA_ID | NUMBER | (10) | Y | Surrogate for formula_no + formula_vers. |
FORMULA_EFECTIVITY_ID | NUMBER | (15) | Surrogate key for this effectivity row. | |
ORGANIZATION_CODE | VARCHAR2 | (4) | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | |
EFFECTIVITY_ITEM_ID | NUMBER | (15) | Surrogate key for the item which is produced by the formula. | |
EFECTIVITY_ROUTING_ID | NUMBER | (15) | Surrogate key for the routing/routing version to be used, if any. | |
EFFECTIVITY_FORMULA_ID | NUMBER | (10) | Surrogate key for the formula /formula version to be used. | |
EFFECTIVITY_CUST_ID | NUMBER | Surrogate key for the customer for which this effectivity is used, if any. | ||
EFFECTIVITY_FORMULA_USE | VARCHAR2 | (30) | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. | |
EFF_FORMULA_USE_MEANING | VARCHAR2 | (80) | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. | |
EFFECTIVITY_END_DATE | DATE | The end date of the effectivity. | ||
EFFECTIVITY_START_DATE | DATE | The start date of the effectivity. | ||
MIN_OUTPUT_QTY_PRIMARY_UOM | NUMBER | The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item. | ||
MAX_OUTPUT_QTY_PRIMARY_UOM | NUMBER | The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item. | ||
MIN_OUTPUT_QTY_EFF_UOM | NUMBER | The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | ||
MAX_OUTPUT_QTY_EFF_UOM | NUMBER | The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | ||
PRODUCT_QTY | NUMBER | Standard batch size for this rec. | ||
PRODUCT_UOM | VARCHAR2 | (4) | UOM for min_qty and max_qty. | |
EFFECTIVITY_PREFERENCE | NUMBER | (15) | Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column. | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Name of the item. | |
PRODUCT_DESC1 | VARCHAR2 | (70) | Short description of the item that is displayed during the item look up. | |
PRODUCT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
PRODUCT_PRIMARY_UOM | VARCHAR2 | (4) | Uom of the item by which the inventory balances are maintained. | |
PRODUCT_SECONDARY_UOM | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
CUSTOMER_NO | VARCHAR2 | (4000) | Unique identifier of a customer. | |
CUSTOMER_NAME | VARCHAR2 | (40) | Customer name | |
ROUTING_ID | NUMBER | (10) | Routing Id. | |
ROUTING_NO | VARCHAR2 | (32) | Routing name. | |
ROUTING_VERSION | NUMBER | (5) | Routing version. | |
ROUTING_DESCRIPTION | VARCHAR2 | (240) | Routing description. | |
ROUTING_CLASS | VARCHAR2 | (4) | User defined class for routings. | |
ROUTING_QTY | NUMBER | Used in ratio with formula and batch qty to scale individual step requirements. | ||
ROUTING_ITEM_UOM | VARCHAR2 | (4) | Uom of routing qty. | |
COST_LEVEL | NUMBER | (5) | Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Actual Cost Process, 1= Costs via Ingredient calculated by Cost Rollup Process. | |
COMPONENT_COST | NUMBER | Component cost | ||
BURDEN_INDICATOR | NUMBER | (5) | Indicates if costs came from burdens 0=No 1=Yes | |
ROLLOVER_INDICATOR | NUMBER | (5) | Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated. | |
COSTING_TOTAL_QTY | NUMBER | Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs. | ||
COSTCALC_ORIG | NUMBER | (5) | Cost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development Process | |
RMCALC_TYPE | NUMBER | (5) | Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI | |
ROLLUP_REF_NO | NUMBER | (10) | Reference number of the Cost Rollup process that calculated this cost | |
COMPONENT_COST_ID | NUMBER | (10) | Surrogate ID for the Cost Component | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse for which the cost is specified | |
WHSE_NAME | VARCHAR2 | (40) | Name of the warehouse. | |
CALENDAR_CODE | VARCHAR2 | (4) | Cost Calendar for which the cost is specified | |
CALENDAR_DESCRIPTION | VARCHAR2 | (40) | Costing Calendar description | |
PERIOD_CODE | VARCHAR2 | (4) | Costing Period for which the cost is specified | |
PERIOD_DESCRIPTION | VARCHAR2 | (40) | Costing Period Description | |
COST_MTHD_CODE | VARCHAR2 | (4) | Cost Method for which the cost is specified | |
COST_CMPNTCLS_ID | NUMBER | (10) | Surrogate for component class | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Analysis code | |
COST_CMPNTCLS_CODE | VARCHAR2 | (32) | Y | Cost component class |
COST_CMPNTCLS_DESC | VARCHAR2 | (240) | Y | Cost component class description |
SORT_SEQUENCE | NUMBER | (10) | Y | Sequence the component costs are sorted by on Cost details screen |
USAGE_IND | NUMBER | (5) | Y | Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment |
PRIMARY_COMPONENT_CLASS_ID | NUMBER | (10) | Y | Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. Default is Primary Class. |
PRODUCT_COST_IND | NUMBER | (5) | Y | This field indicates whether the component class will affect the cost of a product or not. Valid values are: 0 = Not a product cost , 1 = Product Cost. |
UPDATE_COST_IND | NUMBER | (5) | Y | This field indicates whether the component cost will be updated to the GL area. Valid Values are 0 = Do not update to GL area, 1 = Update to GL Area. |
CMPNT_GROUP | VARCHAR2 | (32) | Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group | |
PPV_IND | NUMBER | (5) | Y | Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations. |
LEDGER_STD_QTY | NUMBER | Effectivity standard quantity converted to an item inventory uom. | ||
LEDGER_FORM_PROD_UOM | VARCHAR2 | (4) | UOM of the product within the formula | |
LEDGER_ROUTING_QTY | NUMBER | Routing quantity converted to product inventory uom | ||
LEDGER_PRODUCT_QTY | NUMBER | Product qty converted to product inventory uom | ||
LEDGER_COST_ALLOC | NUMBER | (10) | Cost allocation percentage - The percentage of the ingredient costs that contribute towards the Product cost | |
LEDGER_LINE_TYPE | NUMBER | (10) | Type of line 1=ingredient, -1=byproduct | |
LEDGER_LINE_TYPE_MEANING | VARCHAR2 | (80) | Type of line 1=ingredient, -1=byproduct | |
LEDGER_ITEM_QTY | NUMBER | Ingredient/byproduct quantity converted to inventory uom | ||
LEDGER_ITEM_FMQTY | NUMBER | Ingredient/byproduct quantity at formula uom | ||
LEDGER_ITEM_FMQTY_UM | VARCHAR2 | (4) | Ingredient/byproduct formula uom | |
LEDGER_COMPONENT_COST | NUMBER | Ingredient/byproduct Component cost | ||
LEDGER_RESOURCE_COUNT | NUMBER | Resource count from the operation details | ||
LEDGER_RESOURCE_USAGE | NUMBER | Resource usage from the operation details | ||
LEDGER_NOMINAL_COST | NUMBER | Nominal cost for the resource at usage uom | ||
LEDGER_USAGE_UOM | VARCHAR2 | (4) | Standard resource uom | |
LEDGER_RUDTL_ID | NUMBER | (10) | Surrogate for this row | |
LEDGER_ITEM_ID | NUMBER | (10) | Surrogate for the ingedient/byproduct | |
LEDGER_WHSE_CODE | VARCHAR2 | (4) | Warehouse code | |
LEDGER_RESOURCES | VARCHAR2 | (16) | Resource | |
LEDGER_ITEM_NUMBER | VARCHAR2 | (32) | Y | Name of the item. |
LEDGER_ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
LEDGER_ITEM_UOM | VARCHAR2 | (4) | Y | Uom of the item by which the inventory balances are maintained. |
LEDGER_ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIBV_FORMULA_COST_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Formula
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_ID | NUMBER | (10) | Y | Formula ID |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula Description |
FORMULA_NO | VARCHAR2 | (32) | Y | Formula Number |
APPS.PMIBV_FORMULA_LOV_V is not referenced by any database object
A Business Intelligence System view
The prod and effectivity info for a formula incl. routing info. This does'nt contain ingredient info.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_NO | VARCHAR2 | (32) | Y | Alphanumeric formula name or number. |
FORMULA_VERSION | NUMBER | Y | Formula version. | |
FORMULA_TYPE | NUMBER | (5) | Y | 0=std formula; 1=packaged item formula (these are not currently used). |
SCALE_TYPE | NUMBER | (5) | Y | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
FORMULA_ID | NUMBER | (10) | Y | Surrogate for formula_no + formula_vers. |
FORMULA_EFECTIVITY_ID | NUMBER | (15) | Surrogate key for this effectivity row. | |
ORGNIZATION_CODE | VARCHAR2 | (4) | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | |
EFFECTIVITY_ITEM_ID | NUMBER | (15) | Surrogate key for the item which is produced by the formula. | |
EFECTIVITY_ROUTING_ID | NUMBER | (15) | Surrogate key for the routing/routing version to be used, if any. | |
EFFECTIVITY_FORMULA_ID | NUMBER | (10) | Surrogate key for the formula /formula version to be used. | |
EFFECTIVITY_CUST_ID | NUMBER | Surrogate key for the customer for which this effectivity is used, if any. | ||
EFFECTIVITY_FORMULA_USE | VARCHAR2 | (30) | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. | |
EFFECTIVITY_END_DATE | DATE | The end date of the effectivity. | ||
EFFECTIVITY_START_DATE | DATE | The start date of the effectivity. | ||
MIN_OUTPUT_QTY_PRIMARY_UOM | NUMBER | The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item. | ||
MAX_OUTPUT_QTY_PRIMARY_UOM | NUMBER | The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item. | ||
MIN_OUTPUT_QTY_EFF_UOM | NUMBER | The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | ||
MAX_OUTPUT_QTY_EFF_UOM | NUMBER | The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | ||
PRODUCT_QTY | NUMBER | Standard batch size for this rec. | ||
PRODUCT_UOM | VARCHAR2 | (4) | UOM for min_qty and max_qty. | |
EFFECTIVITY_PREFERENCE | NUMBER | (15) | Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column. | |
CREATED_BY | VARCHAR2 | (32) | Standard who column | |
CREATION_DATE | NUMBER | (5) | Standard who column | |
LAST_UPDATE_DATE | VARCHAR2 | (240) | Standard who column | |
LAST_UPDATED_BY | VARCHAR2 | (4) | Standard who column | |
ROUTING_NO | NUMBER | Routing name. | ||
ROUTING_VERSION | VARCHAR2 | (4) | Routing version. | |
ROUTING_DESCRIPTION | NUMBER | (15) | Y | Routing description. |
ROUTING_CLASS | DATE | Y | User defined class for routings. | |
ROUTING_QTY | DATE | Y | Used in ratio with formula and batch qty to scale individual step requirements. | |
ROUTING_ITEM_UOM | NUMBER | (15) | Y | Uom of routing qty. |
APPS.PMIBV_FORMULA_SUMMARY_V is not referenced by any database object
A Business Intelligence System view
Costing info from the GL and OPM tables combined to facilitate comparison.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | ID of the Item | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse | |
CALENDAR_CODE | VARCHAR2 | (4) | Calendar specified by start date and end date | |
PERIOD_CODE | VARCHAR2 | (4) | Period specified by start date and end date | |
CDA_COST_MTHD_CODE | VARCHAR2 | (4) | Not currently used. | |
GL_COST_MTHD_CODE | VARCHAR2 | (4) | Cost method for accounting cost. | |
COST_COMPONENT_CLASS_CODE | VARCHAR2 | (32) | Cost component class | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Analysis Code | |
COST | NUMBER | Cost | ||
GL_COST | NUMBER | Component Cost |
APPS.PMIBV_GL_CM_COST_COMPARISON_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Cost Calendar Period
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
FISCAL_YEAR | VARCHAR2 | (4) | Y | Fiscal Year |
PERIOD | NUMBER | (5) | Y | Calendar Period Number |
PERIOD_DESC | VARCHAR2 | (40) | Y | Calendar Period Description |
PERIOD_END_DATE | DATE | Y | Calendar Period Ending Date |
APPS.PMIBV_INVCALPERIOD_LOV_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Inventory Calendar
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
FISCAL_YEAR | VARCHAR2 | (4) | Y | Fiscal Year |
CALENDAR_DESC | VARCHAR2 | (40) | Y | Calendar Description |
APPS.PMIBV_INVCAL_LOV_V is not referenced by any database object
A Business Intelligence System view
All inventory transactions from the completed transactions table and the pending transactions table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE | CHAR | (1) | C=from completed transactions, P=from pending transactions | |
TRANS_ID | NUMBER | (10) | Surrogate key for the item. | |
ITEM_ID | NUMBER | (10) | Unique key for the transaction. | |
LINE_ID | NUMBER | (10) | Surrogate key for the document line that produced the transaction. | |
CO_CODE | VARCHAR2 | (4) | Company affected by the transaction (company which owns the organization which created the transaction). | |
ORGN_CODE | VARCHAR2 | (4) | Organization which created the transaction. | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse affected by the transaction. | |
LOT_ID | NUMBER | (10) | Surrogate key of the lot. | |
LOCATION | VARCHAR2 | (16) | Location affected by the transaction. | |
DOC_ID | NUMBER | (10) | Surrogate key of the document that created the transaction. | |
DOC_TYPE | VARCHAR2 | (4) | Type of document which created the transaction. | |
DOC_LINE | NUMBER | (10) | Not currently used. | |
LINE_TYPE | NUMBER | (5) | Line type. | |
REASON_CODE | VARCHAR2 | (4) | Reason code associated with the transaction. | |
TRANS_DATE | DATE | Transaction date. | ||
TRANS_QTY | NUMBER | Quantity of the transaction in the primary UOM of an item. | ||
TRANS_QTY2 | NUMBER | Quantity of the transaction in the secodary UOM of an item, if dual UOM controlled. | ||
QC_GRADE | VARCHAR2 | (4) | Grade associated with the transaction. | |
LOT_STATUS | VARCHAR2 | (4) | Lot status associated with the transaction. | |
TRANS_STAT | VARCHAR2 | (4) | Not currently used. | |
TRANS_UM | VARCHAR2 | (4) | UOM in which trans_qty is expressed. | |
TRANS_UM2 | VARCHAR2 | (4) | UOM in which trans_qty2 is expressed. | |
OP_CODE | NUMBER | (15) | Operator who created the transaction. | |
GL_POSTED_IND | NUMBER | (10) | GL posted indicator. 0=Not posted to GL, 1=Posted to GL. | |
EVENT_ID | NUMBER | (10) | Event ID. | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
APPS.PMIBV_INVENTORY_TRANSACTIONS_V is not referenced by any database object
A Business Intelligence System view
The purpose of this view is to find the Inventory balance by item/warehouse/grade. This view also birngs in the item information from the Item Master Table.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ONHAND_QTY | NUMBER | Total nettable qty of this item/grade in this warehouse, expressed in the primary unit of measure of an item. | ||
ONHAND_QTY2 | NUMBER | Total nettable qty of this item/grade in this warehouse, expressed in the secondary unit of measure of an item, if dual UOM controlled. | ||
ONHAND_PRODUCTION_QTY | NUMBER | Total qty available for use as a production ingredient, expressed in the primary UOM of an item. | ||
ONHAND_PRODUCTION_QTY2 | NUMBER | Total qty available for use as a production ingredient, expressed in the secondary UOM of an itemif dual UOM controlled. | ||
ONHAND_ORDER_QTY | NUMBER | Total qty available for ordering, expressed in the primary UOM of an item. | ||
ONHAND_ORDER_QTY2 | NUMBER | Total qty available for ordering, expressed in the secondary UOM of an item, if dual UOM controlled. | ||
ONHAND_SHIP_QTY | NUMBER | Total qty available for shipping, expressed in the primary UOM of an item. | ||
ONHAND_SHIP_QTY2 | NUMBER | Total qty available for shipping, expressed in the secondary UOM of an item, if dual UOM controlled. | ||
ONPURCH_QTY | NUMBER | Total qty pending from purchase orders, expressed in the primary UOM of an item. | ||
ONPURCH_QTY2 | NUMBER | Total qty pending from purchase orders, expressed in the secondary UOM of an item if dual UOM controlled. | ||
PRODUCTION_PENDING_QTY | NUMBER | Total qty of product pending from production, expressed in the primary UOM of an item. | ||
PRODUCTION_PENDING_QTY2 | NUMBER | Total qty of product pending from production, expressed in the secondary UOM of an item. | ||
COMMITTED_SALES_QTY | NUMBER | Total qty committed to sales orders and shipments, expressed in the primary UOM of an item. | ||
COMMITTED_SALES_QTY2 | NUMBER | Total qty committed to sales orders and shipments, expressed in the secondary UOM of an item if dual UOM controlled. | ||
COMMITTED_PRODUCTION_QTY | NUMBER | Total qty of ingredient committed to batches, expressed in the primary UOM of an item. | ||
COMMITTED_PRODUCTION_QTY2 | NUMBER | Total qty of ingredient committed to batches, expressed in the secondary UOM of an item if dual UOM controlled. | ||
INTRANSIT_QTY | NUMBER | Not currently used. | ||
NTRANSIT_QTY2 | NUMBER | Not currently used. | ||
ITEM_ID | NUMBER | (10) | Y | Surrogate key for the item. |
WHSE_CODE | VARCHAR2 | (4) | Warehouse in which the inventory is located. | |
QC_GRADE | VARCHAR2 | (4) | Grade of the inventory. NULL value denotes that QC Grade does not apply to item. | |
ITEM_NO | VARCHAR2 | (32) | Y | Name of the item. |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
ALTERNATE_ITEMA | VARCHAR2 | (32) | Alternate name for the item. | |
ALTERNATE_ITEMB | VARCHAR2 | (32) | Second alternate name for the item. | |
ITEM_UOM | VARCHAR2 | (4) | Y | Uom of the item by which the inventory balances are maintained. |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
PLANNING_CLASS | VARCHAR2 | (8) | Planning class for an item. Used for MPS and MRP reporting. | |
CREATED_BY | NUMBER | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | Standard who column |
APPS.PMIBV_INV_SUMMARY_V is not referenced by any database object
A Business Intelligence System view
Costing info for an item. Costing info is retrieved from the GL equivalent of the item_cost view which retrieves data from OPM tables.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPONENT_COST_AMT | NUMBER | Y | Component Cost | |
ITEMCOST_ID | NUMBER | (10) | Y | Unique item cost identifier. Foreign key from GL_ITEM_CST table. |
COST_CMPNTCLS_ID | NUMBER | (10) | Y | Unique item cost component class identifier. |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Y | Cost analysis code of cost component. |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization of item cost. | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse for the cost. ( Plant whse or default costing whse.) | |
ITEM_ID | NUMBER | (10) | Item for which cost is stored | |
COST_MTHD_CODE | VARCHAR2 | (4) | Cost method for accounting cost. | |
CALENDAR_CODE | VARCHAR2 | (4) | Costing calendar code. | |
PERIOD_CODE | VARCHAR2 | (4) | Costing period code. | |
FORMULA_EFF_ID | NUMBER | (10) | Formula effectivity used in the calculation of accounting cost. | |
GL_ITEMCOST_ID | NUMBER | (10) | Y | Surrogate key to the row. Foreign Key to GL_ITEM_DTL table. |
FINAL_FLAG | NUMBER | (5) | Y | Indicates if Cost is frozen: 0 - not frozen, can be updated from CDA by running Cost Update process; 1 - Frozen, cannot be modified. |
END_DATE | DATE | Y | End effective date for the accounting cost. | |
START_DATE | DATE | Y | Start Effective date for accounting cost. | |
COST_TYPE | NUMBER | (5) | Y | Type of cost. 0=other; 1=std; 2=avg actual; 3=current. Not currently used. |
ACCTG_COST | NUMBER | Y | Item cost as seen by OPM programs, especially Susidiary Ledger Update process. | |
CREATED_BY | VARCHAR2 | (32) | Y | Standard who column |
CREATION_DATE | VARCHAR2 | (240) | Y | Standard who column |
LAST_UPDATE_DATE | NUMBER | (10) | Y | Standard who column |
LAST_UPDATED_BY | NUMBER | (5) | Y | Standard who column |
COST_CMPNTCLS_CODE | NUMBER | (10) | Y | Cost component class |
COST_CMPNTCLS_DESC | NUMBER | (5) | Y | Cost component class description |
SORT_SEQUENCE | NUMBER | (5) | Y | Sequence the component costs are sorted by on Cost details screen |
USAGE_IND | VARCHAR2 | (32) | Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment | |
PRIMARY_CMPNTCLS_ID | NUMBER | (5) | Y | Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. |
PRODUCT_COST_IND | NUMBER | (15) | Y | This field indicates whether the component class will affect the cost of a product or not . Valid values are: 0 = Not a product cost, 1= Product Cost |
UPDATE_COST_IND | DATE | Y | This field indicates whether the component cost will be updated to the GL area. Valid values are 0= Do not update to GL Area, 1=Update to GL Area. | |
CMPNT_GROUP | DATE | Y | Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group | |
PPV_IND | NUMBER | (15) | Y | Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations. |
APPS.PMIBV_ITEM_COST_FROM_GL_V is not referenced by any database object
A Business Intelligence System view
Costing info for an item. Costing info is retrieved from CM tables, OPM equivalent of the item_cost_from_GL view which retrieves data from the GL tables.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COST_LEVEL | NUMBER | (5) | Y | Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Actual Cost Process, 1= Costs via Ingredient calculated by Cost Rollup Process. |
COMPONENT_COST | NUMBER | Y | Component cost | |
BURDEN_INDICATOR | NUMBER | (5) | Y | Indicates if costs came from burdens 0=No 1=Yes |
ROLLOVER_INDICATOR | NUMBER | (5) | Y | Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated. |
TOTAL_QTY | NUMBER | Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs. | ||
COSTCALC_ORIG | NUMBER | (5) | Cost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development Process | |
RMCALC_TYPE | NUMBER | (5) | Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI | |
ROLLUP_REF_NO | NUMBER | (10) | Reference number of the Cost Rollup process that calculated this cost | |
FORMULA_EFF_ID | NUMBER | (10) | Effectivity used in determining Product(hence formula, routing - if any) during Cost Rollup Process | |
COMPONENT_COST_ID | NUMBER | (10) | Y | Surrogate ID for the Cost Component |
ITEM_ID | NUMBER | (10) | Surrogate for item for which the cost is specified | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse for which the cost is specified | |
CALENDAR_CODE | VARCHAR2 | (4) | Cost Calendar for which the cost is specified | |
PERIOD_CODE | VARCHAR2 | (4) | Costing Period for which the cost is specified | |
COST_MTHD_CODE | VARCHAR2 | (4) | Cost Method for which the cost is specified | |
COST_CMPNTCLS_ID | NUMBER | (10) | Y | Surrogate for component class |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Y | Analysis code |
CREATED_BY | VARCHAR2 | (32) | Y | Standard who column |
CREATION_DATE | VARCHAR2 | (240) | Y | Standard who column |
LAST_UPDATE_DATE | NUMBER | (10) | Y | Standard who column |
LAST_UPDATED_BY | NUMBER | (5) | Y | Standard who column |
COST_CMPNTCLS_CODE | NUMBER | (10) | Y | Cost component class |
COST_CMPNTCLS_DESC | NUMBER | (5) | Y | Cost component class description |
SORT_SEQUENCE | NUMBER | (5) | Y | Sequence the component costs are sorted by on Cost details screen |
USAGE_IND | VARCHAR2 | (32) | Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment | |
PRIMARY_COMPONENT_CLASS_ID | NUMBER | (5) | Y | Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. Default is Primary Class. |
PRODUCT_COST_IND | NUMBER | (15) | Y | This field indicates whether the component class will affect the cost of a product or not. Valid values are: 0 = Not a product cost , 1 = Product Cost. |
UPDATE_COST_IND | DATE | Y | This field indicates whether the component cost will be updated to the GL area. Valid Values are 0 = Do not update to GL area, 1 = Update to GL Area. | |
CMPNT_GROUP | DATE | Y | Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group | |
PPV_IND | NUMBER | (15) | Y | Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations. |
APPS.PMIBV_ITEM_COST_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Item
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | Y | Item ID |
ITEM_NO | VARCHAR2 | (32) | Y | Item Number |
ITEM_DESC1 | VARCHAR2 | (70) | Y | Item Description |
APPS.PMIBV_ITEM_LOV_V is not referenced by any database object
A Business Intelligence System view
Pricing information for an item broken down by quantity, warehouse, grade, customer, pricelist.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QC_GRADE | VARCHAR2 | (4) | QC grade to which these prices apply. Contains a NULL value to denote an "ALL" condition. Only applicable for grade-controlled items. | |
PRICE_UOM | VARCHAR2 | (4) | Y | Pricing uom |
BASE_PRICE | NUMBER | Y | Base price for the item/item class/whse/qc grade/frtbill_mthd/uom combination. May be zero. | |
FRIEGHT_BILL_MTHD | VARCHAR2 | (4) | Freight bill method to which these prices apply. Contains a NULL value to denote an "ALL" condition. | |
PRICEITEM_LINE_NO | NUMBER | (5) | Y | For use with future or custom pricing when fields, such as attribute columns, are used as part of the key, but are not part of the defined key. Default is zero. |
PRICE_TYPE | NUMBER | (5) | Y | Type of prices established as price breaks. Valid values are: 0 ,1,2 & 3 |
BREAK_TYPE | NUMBER | (5) | Y | Indicates the type of price breaks defined for this record. Valid values are: 0 = no price breaks defined, 1 = qty breakpoints defined, 2 = value breakpoints defined. |
PRICELIST_ID | NUMBER | (10) | Y | Pricelist to which these item prices belong. |
PRICE_CLASS | VARCHAR2 | (8) | Item price class. May be NULL when ITEM_ID has a valid value. | |
PRICE_ID | NUMBER | (10) | Y | Surrogate id to uniquely identify each row. |
ITEM_ID | NUMBER | (10) | Item to which these prices apply. Contains NULL value when PRICE_CLASS has a valid value. | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse code for which these prices apply. Contains a NULL value to denote an "ALL" condition. | |
PRICEBREAK_LINE_NO | NUMBER | (5) | Y | Part of primary key to distinguish between unique quantity and value breaks. |
QTY_BREAKPOINT | NUMBER | Quantity break for price. | ||
VALUE_BREAKPOINT | NUMBER | Value break for price (item qty * base price). | ||
BREAKPOINT_FACTOR | NUMBER | Percent which is applied to base price for this price detail to compute the unit price for the break value or qty. | ||
BREAKPOINT_PRICE | NUMBER | Unit price which applies for this break value/qty. | ||
BREAKTYPE_ID | NUMBER | (10) | Y | Surrogate id which uniquely identifies this row. |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIBV_ITEM_PRICE_V is not referenced by any database object
A Business Intelligence System view
This view provides the relationship between a lot and the shipments that its destination lots have been involved in.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | Product Item ID | ||
PRODUCT_LOT_ID | NUMBER | Product Lot ID | ||
INGREDIENT_ITEM_ID | NUMBER | Ingredient Item ID | ||
INGREDIENT_LOT_ID | NUMBER | Ingredient Lot ID | ||
PRODUCT_WAREHOUSE | VARCHAR2 | (4) | Product Warehouse | |
PRODUCT_LOCATION | VARCHAR2 | (16) | Product Location | |
TRANSACTION_DATE | DATE | Transaction Date | ||
TRANSACTION_QUANTITY | NUMBER | Transacted Quantity in Primary UOM | ||
TRANSACTION_QUANTITY_UOM2 | NUMBER | Transacted Quantity in Secondary UOM | ||
ORGANIZATION_CODE | VARCHAR2 | (240) | Organization Code | |
ORDER_NO | VARCHAR2 | (40) | Sales Order Number | |
CUSTOMER_NO | VARCHAR2 | (4000) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Ingredient Item Number | |
INGREDIENT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Ingredient Item Description | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Ingredient Primary UOM | |
INGREDIENT_ITEM_UOM2 | VARCHAR2 | (4) | Ingredient Secondary UOM | |
INGREDIENT_LOT_NO | VARCHAR2 | (32) | Ingredient Lot Number | |
INGREDIENT_SUBLOT_NO | VARCHAR2 | (32) | Ingredient Sublot Number | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Product Item Number | |
PRODUCT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Product Item Description | |
PRODUCT_ITEM_UOM | VARCHAR2 | (4) | Product Primary UOM | |
PRODUCT_ITEM_UOM2 | VARCHAR2 | (4) | Product Secondary UOM | |
PRODUCT_ITEM_INV_CLASS | VARCHAR2 | (8) | Product Inventory Class | |
PRODUCT_ITEM_PLAN_CLASS | VARCHAR2 | (8) | Product Planing Class | |
PRODUCT_ITEM_SALES_CLASS | VARCHAR2 | (8) | Product Sales Class | |
PRODUCT_LOT_NO | VARCHAR2 | (32) | Product Lot Number | |
PRODUCT_SUBLOT_NO | VARCHAR2 | (32) | Product Sublot Number | |
TRANSACTION_COMPLETE_INDICATOR | NUMBER | (5) |
APPS.PMIBV_LOT_DEST_SHIP_V is not referenced by any database object
A Business Intelligence System view
Lot List View used by Lot Genealogy workbook
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NO | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
ITEM_ID | NUMBER | (10) | Item ID | |
INVENTORY_CLASS | VARCHAR2 | (8) | Inventory Class | |
INVENTORY_TYPE | VARCHAR2 | (4) | Inventory Type | |
LOT_ID | NUMBER | (10) | Lot ID | |
LOT_NO | VARCHAR2 | (32) | Lot Number | |
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
LOT_CREATION_DATE | DATE | Lot Creation Date | ||
QC_GRADE | VARCHAR2 | (4) | Quality Control Grade | |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization Code | |
ORGANIZATION_NAME | VARCHAR2 | (40) | Organization Name | |
VENDOR_NO | VARCHAR2 | (154) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
VENDOR_ID | NUMBER | Vendor ID | ||
BATCH_NO | VARCHAR2 | (32) | Batch Number | |
FORMULA_NO | CHAR | (1) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
ROUTING_NO | CHAR | (1) | Routing Number | |
ROUTING_VERSION | NUMBER | Routing Version | ||
RECIEPT_NO | VARCHAR2 | (32) | PO Rceipt Number |
APPS.PMIBV_LOT_LIST_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Lot
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOT_NO | VARCHAR2 | (32) | Y | Lot Number |
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
LOT_DESC | VARCHAR2 | (40) | Lot Description | |
VENDOR_LOT_NO | VARCHAR2 | (32) | Vendor Lot Number |
APPS.PMIBV_LOT_LOV_V is not referenced by any database object
A Business Intelligence System view
Provides the relationship between a lot and the shipments that its destination lots have been involved in. A Shared Lot here refers to the lots that shared the same source lots.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
START_ITEM_ID | NUMBER | Start Item ID to find Shared Lots | ||
START_LOT_ID | NUMBER | Start Lot ID to find Shared Lots | ||
SHARED_ITEM_ID | NUMBER | Shared Item ID which uses same Item,lots as start Item, Lots | ||
SHARED_LOT_ID | NUMBER | Shared Lot ID which uses same Item,lots as start Item, Lots | ||
START_ITEM_NO | VARCHAR2 | (32) | Start Item Number to find Shared Lots | |
START_ITEM_DESCRIPTION | VARCHAR2 | (70) | Start Item Description to find Shared Lots | |
START_LOT_NO | VARCHAR2 | (32) | Start Lot Number to find Shared Lots | |
START_SUBLOT_NO | VARCHAR2 | (32) | Start Sublot Number to find Shared Lots | |
SHARED_ITEM_NO | VARCHAR2 | (32) | Shared Item Number which uses same Item,lots as start Item, Lots | |
SHARED_ITEM_DESCRIPTION | VARCHAR2 | (70) | Shared Item Description which uses same Item,lots as start Item, Lots | |
SHARED_ITEM_UOM | VARCHAR2 | (4) | Shared Item Primary UOM | |
SHARED_ITEM_UOM2 | VARCHAR2 | (4) | Shared Item Secondary UOM | |
SHARED_INVENTORY_CLASS | VARCHAR2 | (8) | Shared Item Inventory Class | |
SHARED_PLANNING_CLASS | VARCHAR2 | (8) | Shared Item Planning Class | |
SHARED_SALES_CLASS | VARCHAR2 | (8) | Shared Item Sales Class | |
SHARED_LOT_NO | VARCHAR2 | (32) | Shared Lot Number | |
SHARED_SUBLOT_NO | VARCHAR2 | (32) | Shared sublot Number | |
ORGANIZATION_CODE | VARCHAR2 | (240) | Organization Code for OM it is Operating Unit name | |
WAREHOUSE | VARCHAR2 | (4) | Warehouse | |
LOCATION | VARCHAR2 | (16) | Location | |
ORDER_NO | VARCHAR2 | (40) | Sales Order Number | |
CUSTOMER_NO | VARCHAR2 | (4000) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
SHIP_DATE | DATE | Ship date | ||
SHIPPED_QUANTITY | NUMBER | Shipped Quantity in Primary UOM | ||
SHIPPED_QUANTITY_UOM2 | NUMBER | Shipped Quantity in Secondary UOM | ||
TRANSACTION_COMPLETE_INDICATOR | NUMBER | (5) | Completed Indicator |
APPS.PMIBV_LOT_SHARED_SHIP_V is not referenced by any database object
A Business Intelligence System view
This view lists the raw material lots that went into a product lot.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | Product Item ID | ||
PRODUCT_LOT_ID | NUMBER | Product Lot ID | ||
INGREDIENT_ITEM_ID | NUMBER | Ingredient Item ID | ||
INGREDIENT_LOT_ID | NUMBER | Ingredient Lot ID | ||
PRODUCT_WAREHOUSE | VARCHAR2 | (4) | Product Warehouse | |
PRODUCT_LOCATION | VARCHAR2 | (16) | Product Location | |
TRANSACTION_DATE | DATE | Transaction Date | ||
TRANSACTION_QUANTITY | NUMBER | Transacted Quantity in Primary UOM | ||
TRANSACTION_QUANTITY_UOM2 | NUMBER | Transacted Quantity in Secondary UOM | ||
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization Code | |
RECEIPT_NO | VARCHAR2 | (32) | PO Receipt Number | |
PURCHASE_ORDER_NO | VARCHAR2 | (32) | Purchase Order Number | |
VENDOR_NO | VARCHAR2 | (154) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Ingredient Number | |
INGREDIENT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Ingredient Item Description | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Ingredient Primary UOM | |
INGREDIENT_ITEM_UOM2 | VARCHAR2 | (4) | Ingredient Secondary UOM | |
INGREDIENT_ITEM_INV_CLASS | VARCHAR2 | (8) | Ingredient Inventory Class | |
INGREDIENT_ITEM_PLAN_CLASS | VARCHAR2 | (8) | Ingredient Planing Class | |
INGREDIENT_ITEM_SALES_CLASS | VARCHAR2 | (8) | Ingredient Sales Class | |
INGREDIENT_LOT_NO | VARCHAR2 | (32) | Ingredient Lot Number | |
INGREDIENT_SUBLOT_NO | VARCHAR2 | (32) | Ingredient Sublot Number | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Product Item Number | |
PRODUCT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Product Item Description | |
PRODUCT_ITEM_UOM | VARCHAR2 | (4) | Product Primary UOM | |
PRODUCT_ITEM_UOM2 | VARCHAR2 | (4) | Product Secondary UOM | |
PRODUCT_LOT_NO | VARCHAR2 | (32) | Product Lot Number | |
PRODUCT_SUBLOT_NO | VARCHAR2 | (32) | Product Sublot Number |
APPS.PMIBV_LOT_SOURCE_PURCH_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Organization
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
ORGN_NAME | VARCHAR2 | (40) | Y | Organization Name |
APPS.PMIBV_ORGANIZATION_LOV_V is not referenced by any database object
A Business Intelligence System view
Process Manufacturing Organizations
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization code. |
ORGN_NAME | VARCHAR2 | (40) | Y | Organization name. |
PLANT_IND | NUMBER | (5) | Y | 0=no the organization is not a plant; 1=yes the organization is a plant. |
TAXLOC_CODE | VARCHAR2 | (10) | Tax Location Code for this organization (FK to TX_TLOC_CDS) | |
POC_IND | NUMBER | (5) | 0=Do not generate POC transactions for organization; 1=Generate POC transactions for organization | |
PARENT_ORGN_CODE | VARCHAR2 | (4) | Y | Orgn to which orgn_code reports. Must already exist in the table. |
CO_CODE | VARCHAR2 | (4) | Y | Company code of the organization. |
ADDR_ID | NUMBER | (10) | Surrogate of the organization address. | |
ORGANIZATION_ID | NUMBER | (15) | Foreign reference to HR_ORGANIZATION_UNITS | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIBV_ORGANIZATION_V is not referenced by any database object
A Business Intelligence System view
Qty and usage info for Items in Inv. for closed periods by whse, location, lot and item, unioned with Current inv. in the open period.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QTY_ONHAND | NUMBER | Y | Period ending balance of lot/item in secondary UOM of an item, for dual UOM items. | |
QTY_ONHAND_IN_UM2 | NUMBER | Period ending balance of lot/item in primary UOM of an item. | ||
QTY_USED | NUMBER | Y | Consumption of the item in production during the period, in the primary inventory UOM of an item. | |
QTY_USED_IN_UM2 | NUMBER | Consumption of the item in production during the period, in the secondary inventory UOM of an item, for dual UOM items. | ||
YIELD | NUMBER | Y | Yield of the item from production during the period, in the primary inventory UOM of an item. | |
YIELD_IN_UM2 | NUMBER | Yield of the item from production during the period, in the secondary inventory UOM of an item, for dual UOM items. | ||
VALUE | NUMBER | Y | Value of loct_usage. Equals loct_usage*accounting cost. | |
LAST_PERIOD_CLOSE_DATE | DATE | Y | Last time Inventory Close was run. | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Y | Warehouse which contains the item balances. |
LOT_ID | NUMBER | (10) | Y | Surrogate key for the lot/sublot. 0 identifies the default lot. LOT_ID is set to '0' for items without lot control. |
LOCATION | VARCHAR2 | (16) | Y | Location in the warehouse, if any, which contains the balance. |
ITEM_ID | NUMBER | (10) | Y | Surrogate key for the item. |
LOT_STATUS | VARCHAR2 | (4) | Status of the lot. | |
QC_HOLD_REASON_CODE | VARCHAR2 | (4) | Reason code associated with the lot status. | |
PERIOD_ID | NUMBER | (10) | Y | Surrogate key of the period. |
FISCAL_YEAR | VARCHAR2 | (4) | Y | Name of the inventory calendar. |
PERIOD | NUMBER | (5) | Y | Inventory period for which the balance is stored. |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column |
APPS.PMIBV_PERIODINVENTORY_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Plant
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
ORGN_NAME | VARCHAR2 | (40) | Y | Organization Name |
APPS.PMIBV_PLANT_LOV_V is not referenced by any database object
A Business Intelligence System view
Formula Detail with Onhand Quantity of the Ingredients
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_NO | VARCHAR2 | (32) | Y | Alphanumeric formula name or number. |
FORMULA_VERSION | NUMBER | Y | Formula version. | |
FORMULA_TYPE | NUMBER | (5) | Y | 0=std formula; 1=packaged item formula (these are not currently used). |
SCALE_TYPE | NUMBER | (5) | Y | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
FORMULA_ID | NUMBER | (10) | Y | Surrogate for formula_no + formula_vers. |
PRODUCT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
INGREDIENT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
INGREDIENT_FORMULALINE_ID | NUMBER | (10) | Y | Surrogate key for the formula line. |
INGREDIENT_LINE_NO | NUMBER | (5) | Y | List order on screen within a line_type. |
INGREDIENT_QTY | NUMBER | Y | Item qty produced or consumed. | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Uom of qty. | |
INGREDIENT_RELEASE_TYPE | NUMBER | (5) | Y | 0=automatic release; 1=partial release. |
INGREDIENT_SCRAP_FACTOR | NUMBER | Y | Scrap factor decimal used to calculate required qty. | |
INGREDIENT_SCALE_TYPE | NUMBER | (5) | Y | 0=fixed, no scaling; 1=proportional scaling. |
COST_ALLOCATION | NUMBER | If product, fractional cost absorption. | ||
PHANTOM_TYPE | NUMBER | (5) | Y | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. |
REWORK_TYPE | NUMBER | (5) | Y | Not currently used. |
PRODUCT_QTY | NUMBER | Y | Item qty produced or consumed. | |
PRODUCT_UOM | VARCHAR2 | (4) | Uom of qty. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIBV_PRODUCTFORMULA_INV_V is not referenced by any database object
A Business Intelligence System view
The prod and ingredient info for a formula. This does not contain infor on effectivity, routing or coproducts.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_NO | VARCHAR2 | (32) | Y | Alphanumeric formula name or number. |
FORMULA_VERSION | NUMBER | Y | Formula version. | |
FORMULA_TYPE | NUMBER | (5) | Y | 0=std formula; 1=packaged item formula (these are not currently used). |
SCALE_TYPE | NUMBER | (5) | Y | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
FORMULA_ID | NUMBER | (10) | Y | Surrogate for formula_no + formula_vers. |
PRODUCT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
INGREDIENT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
INGREDIENT_FORMULALINE_ID | NUMBER | (10) | Y | Surrogate key for the formula line. |
INGREDIENT_LINE_NO | NUMBER | (5) | Y | List order on screen within a line_type. |
INGREDIENT_QTY | NUMBER | Y | Item qty produced or consumed. | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Uom of qty. | |
INGREDIENT_RELEASE_TYPE | NUMBER | (5) | Y | 0=automatic release; 1=partial release. |
INGREDIENT_SCRAP_FACTOR | NUMBER | Y | Scrap factor decimal used to calculate required qty. | |
INGREDIENT_SCALE_TYPE | NUMBER | (5) | Y | 0=fixed, no scaling; 1=proportional scaling. |
COST_ALLOCATION | NUMBER | If product, fractional cost absorption. | ||
PHANTOM_TYPE | NUMBER | (5) | Y | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. |
REWORK_TYPE | NUMBER | (5) | Y | Not currently used. |
PRODUCT_QTY | NUMBER | Y | Item qty produced or consumed. | |
PRODUCT_UOM | VARCHAR2 | (4) | Uom of qty. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIBV_PRODUCTFORMULA_V is not referenced by any database object
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESULT_DATE | DATE | |||
RESULT | VARCHAR2 | (40) | ||
RESULTS_QCUNIT_CODE | VARCHAR2 | (4) | Y | |
ACCEPT | NUMBER | (5) | Y | |
CERTI_OF_ANALYSIS | NUMBER | (5) | Y | |
TEST_PROVIDER_CODE | VARCHAR2 | (8) | ||
ASSAY_TESTER | VARCHAR2 | (30) | ||
WF_RESPONSE | VARCHAR2 | (240) | ||
ASSAY_RETEST_FLAG | NUMBER | (5) | ||
QCASSY_TYP_ID | NUMBER | (15) | Y | |
QC_RESULT_ID | NUMBER | (10) | Y | |
QC_SPEC_ID | NUMBER | (10) | ||
ORGN_CODE | VARCHAR2 | (4) | Y | |
SAMPLE_ID | NUMBER | (10) | Y | |
SAMPLE_NO | VARCHAR2 | (32) | Y | |
SAMPLE_DESC | VARCHAR2 | (70) | ||
SAMPLE_STATUS | VARCHAR2 | (80) | Y | |
SAMPLE_STATUS_MEANING | VARCHAR2 | (80) | ||
ASSAY_CODE | VARCHAR2 | (16) | Y | |
ASSAY_DESC | VARCHAR2 | (40) | Y | |
ITEM_ID | NUMBER | (10) | Y | |
LOT_ID | NUMBER | (10) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
FORMULA_ID | NUMBER | (10) | ||
FORMULALINE_ID | NUMBER | (10) | ||
ROUTING_ID | NUMBER | (10) | ||
ROUTINGSTEP_ID | NUMBER | (10) | ||
OPRN_ID | NUMBER | (10) | ||
CUST_ID | NUMBER | (15) | ||
SHIP_TO_SITE_ID | NUMBER | |||
VENDOR_ID | NUMBER | (10) | ||
BATCH_ID | NUMBER | (10) | ||
ROUTINGSTEP_NO | NUMBER | (5) | ||
ITEM_NUMBER | VARCHAR2 | (32) | Y | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | |
ITEM_UOM | VARCHAR2 | (4) | Y | |
ITEM_UOM2 | VARCHAR2 | (4) | ||
DOC_TYPE | VARCHAR2 | (4) | ||
DOC_ID | NUMBER | (10) | ||
DOCLINE_ID | NUMBER | (10) | ||
CUST_SPECIFICATION | NUMBER | (5) | ||
CUST_CERTIFICATION | NUMBER | (5) | ||
VENDOR_SPECIFICATION | NUMBER | (5) | ||
VENDOR_CERTIFICATION | NUMBER | (5) | ||
TEXT_SPEC | VARCHAR2 | (16) | ||
TARGET_SPEC | NUMBER | |||
MIN_SPEC | NUMBER | |||
MAX_SPEC | NUMBER | |||
SPEC_QCUNIT_CODE | VARCHAR2 | (4) | ||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
OUTACTION_CODE | VARCHAR2 | (4) | ||
OUTACTION_INTERVAL | NUMBER | |||
PREFERENCE | NUMBER | (5) | ||
PRINT_COA_SHIPPED | NUMBER | (5) | ||
PRINT_COA_INVOICED | NUMBER | (5) | ||
VENDOR_COA_REQUIRED | NUMBER | (5) | ||
TEST_OPRN_ID | NUMBER | (10) | ||
TEST_OPRN_LINE_ID | NUMBER | (10) | ||
CUSTOMER_NO | VARCHAR2 | (30) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
VENDOR_NO | VARCHAR2 | (32) | ||
VENDOR_NAME | VARCHAR2 | (40) | ||
ACCEPT_ANYWAY | NUMBER | (5) | Y | |
LOT_NO | VARCHAR2 | (32) | ||
SUBLOT_NO | VARCHAR2 | (32) | ||
CREATED_BY | NUMBER | (15) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (15) | Y |
APPS.PMIBV_QCRESULT_V is not referenced by any database object
A Business Intelligence System view
QC Assays Base View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_CODE | VARCHAR2 | (80) | OPM Organization Code | |
ASSAY_CODE | VARCHAR2 | (16) | Y | QC Assay Code |
ASSAY_DESCRIPTION | VARCHAR2 | (40) | Y | QC Assay Description |
ASSAY_TYPE | NUMBER | (5) | Y | Assay Type |
MIN_VALUE | NUMBER | MIN Value for numeric Assays | ||
MAX_VALUE | NUMBER | MAX Value for numeric Assays | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Y | Quality Control Unit Code |
DELETE_MARK | NUMBER | (5) | Y | Delete Mark |
LAST_UPDATED_DATE | DATE | Y | ROW WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | ROW WHO Column |
CREATION_DATE | DATE | Y | ROW WHO Column | |
CREATED_BY | NUMBER | (15) | Y | ROW WHO Column |
VALUE | VARCHAR2 | (40) | Assay Character Value |
APPS.PMIBV_QC_ASSAYS_V is not referenced by any database object
A Business Intelligence System view
QC Specification and results matching Base view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSAY_CODE | VARCHAR2 | (16) | Y | QC Assay Code |
NUM_RESULT | NUMBER | Numeric Result | ||
TEXT_RESULT | VARCHAR2 | (16) | Text Result | |
FINAL_MARK | NUMBER | (5) | Y | Final Mark |
ACCEPT_ANYWAY | NUMBER | (5) | Y | Accept Anyway |
MIN_SPEC | NUMBER | MIN Value for numeric Assays | ||
MAX_SPEC | NUMBER | MAX Value for numeric Assays | ||
TEXT_SPEC | VARCHAR2 | (16) | Text Specification | |
TARGET_SPEC | NUMBER | Target Specification | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Y | Quality Control Unit Code |
SAMPLE_ID | NUMBER | (10) | Y | Sample ID |
APPS.PMIBV_QC_MATCH_DTL_V is not referenced by any database object
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_NUMBER | VARCHAR2 | (30) | Y | |
CUSTOMER_NAME | VARCHAR2 | (360) | Y | |
ITEM_NUMBER | VARCHAR2 | (32) | Y | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Y | |
LOCATION | VARCHAR2 | (16) | Y | |
LOT_NUMBER | VARCHAR2 | (32) | Y | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | ||
LOCATION_ONHAND | NUMBER | Y | ||
ITEM_UOM | VARCHAR2 | (4) | Y | |
LOT_STATUS | VARCHAR2 | (4) | ||
EXPIRE_DATE | DATE | |||
SAMPLE_ID | NUMBER | (10) | Y | |
USE | VARCHAR2 | (80) | Y |
APPS.PMIBV_QC_MATCH_HDR_V is not referenced by any database object
A Business Intelligence System view
QC Production Specification Full View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUALITY_CONTROL_SPEC_ID | NUMBER | (10) | Quality Control Spec ID | |
ASSAY_TYPE_ID | NUMBER | (15) | Assay Type ID | |
ORGANIZATION_CODE | VARCHAR2 | (4) | OPM Organization Code | |
WAREHOUSE_CODE | VARCHAR2 | (4) | OPM Warehouse Code | |
LOCATION | VARCHAR2 | (16) | Location | |
DOCUMENT_TYPE | VARCHAR2 | (4) | Document Type | |
VENDOR_SPECIFICATION | NUMBER | (5) | Vendor Specification | |
VENDOR_CERTIFICATION | NUMBER | (5) | Vendor Certification | |
CUSTOMER_SPECIFICATION | NUMBER | (5) | Customer Specification | |
CUSTOMER_CERTIFICATION | NUMBER | (5) | Customer Certification | |
ASSAY_CODE | VARCHAR2 | (16) | Assay Code | |
TEXT_SPEC | VARCHAR2 | (16) | Text Spec | |
MIN_SPEC | NUMBER | MIN Spec | ||
MAX_SPEC | NUMBER | MAX Spec | ||
TARGET_SPEC | NUMBER | Target Spec | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Quality Control Unit Code | |
FROM_DATE | DATE | From Date | ||
TO_DATE | DATE | To Date | ||
OUT_OF_ACTION_CODE | VARCHAR2 | (4) | Out Of Action Code | |
OUT_OF_ACTION_INTERVAL | NUMBER | Out Of Action Interval | ||
PREFERENCE | NUMBER | (5) | Preference | |
PRINT_COA_SHIPPED | NUMBER | (5) | Print COA Shipped | |
PRINT_COA_INVOICED | NUMBER | (5) | Print COA Invoiced | |
VENDOR_COA_REQUIRED | NUMBER | (5) | Vendor COA Required | |
DELETE_MARK | NUMBER | (5) | Delete Mark is used mark record for logical deletion | |
ROUTING_STEP_NUMBER | NUMBER | (5) | Routing Step Number | |
CUSTOMER_NUMBER | CHAR | (1) | Customer Number | |
CUSTOMER_NAME | CHAR | (1) | Customer Name | |
ITEM_NUMBER | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
VENDOR_ID | NUMBER | Vendor ID | ||
VENDOR_NUMBER | CHAR | (1) | Vendor Number | |
VENDOR_NAME | CHAR | (1) | Vendor Name | |
FORMULA_ID | NUMBER | (10) | Formula Id | |
FORMULA_NUMBER | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | Sub Lot Number | |
BATCH_NUMBER | VARCHAR2 | (32) | Batch Number | |
ROUTING_ID | NUMBER | (10) | Routing Id | |
ROUTING_NUMBER | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERSION | NUMBER | (5) | Routing Version | |
OPERATION_ID | NUMBER | (10) | Operation Id | |
OPERATION_NUMBER | VARCHAR2 | (16) | Operation Number | |
OPERATION_VERSION | NUMBER | (5) | Operation Version | |
EFFECTIVE | VARCHAR2 | (80) | Effective |
APPS.PMIBV_QC_PRODUCTION_SPEC_V is not referenced by any database object
A Business Intelligence System view
QC Results Full View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_CODE | VARCHAR2 | (4) | OPM Organization Code | |
WAREHOUSE_CODE | VARCHAR2 | (4) | OPM Warehouse Code | |
DOCUMENT_TYPE | VARCHAR2 | (4) | Document Type | |
RESULT_DATE | DATE | Result Date | ||
TEXT_RESULT | VARCHAR2 | (16) | Text Result | |
NUM_RESULT | NUMBER | Numeric Result | ||
ACCEPT_ANYWAY | VARCHAR2 | (80) | Accept Anyway | |
FINAL_MARK | VARCHAR2 | (80) | Final Mark | |
TEST_PROVIDER_CODE | VARCHAR2 | (8) | Test Provider | |
LOCATION | VARCHAR2 | (16) | Location | |
DELETE_MARK | NUMBER | (5) | Delete mark used for logical deletion in OPM | |
LAST_UPDATE_DATE | DATE | ROW WHO Column | ||
VENDOR_SPECIFICATION | NUMBER | Vendor Specification | ||
CUSTOMER_SPECIFICATION | NUMBER | Customer Specification | ||
ASSAY_CODE | VARCHAR2 | (16) | Assay Code | |
TEXT_SPEC | VARCHAR2 | (16) | Text Spec | |
MIN_SPEC | NUMBER | MIN value allowed for Spec | ||
MAX_SPEC | NUMBER | MAX value allowed for Spec | ||
TARGET_SPEC | NUMBER | Target Sepc | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Quality Control Unit Code | |
FROM_DATE | DATE | From Date | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
VENDOR_NO | VARCHAR2 | (32) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (40) | Vendor Name | |
QUALITY_CONTROL_SPEC_ID | NUMBER | Quality Control Specification ID | ||
ITEM_NUMBER | VARCHAR2 | (32) | Item number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | Sub Lot Number | |
SAMPLE_NUMBER | VARCHAR2 | (32) | Sample Number | |
BATCH_NUMBER | VARCHAR2 | (32) | Production Batch Number | |
FORMULA_NUMBER | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
ROUTING_NUMBER | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERSION | NUMBER | (5) | Routing Version | |
OPERATION_NUMBER | VARCHAR2 | (16) | Operation Number | |
OPERATION_VERSION | NUMBER | (5) | Operation Version | |
ROUTING_STEP_NUMBER | NUMBER | (5) | Routing Step Number | |
CUSTOMER_ID | NUMBER | (15) | Customer ID | |
SHIP_TO_SITE_ID | NUMBER | Ship to Site ID |
APPS.PMIBV_QC_RESULTS_V is not referenced by any database object
A Business Intelligence System view
QC Samples Full View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SAMPLE_ID | NUMBER | (10) | Y | Surrogate ID to QC Samples |
ORGANIZATION_CODE | VARCHAR2 | (4) | Y | OPM Organization Code |
SAMPLE_NO | VARCHAR2 | (32) | Y | Sample Number |
SAMPLE_DESCRIPTION | VARCHAR2 | (70) | Sample Description | |
WAREHOUSE_CODE | VARCHAR2 | (4) | OPM Warehouse Code | |
LOCATION | VARCHAR2 | (16) | Location | |
SAMPLE_DATE | DATE | Y | Sample Date | |
SAMPLED_BY | VARCHAR2 | (100) | Y | Sampled By |
SAMPLE_QTY | NUMBER | Y | Quantity taken for Sample | |
SAMPLE_UOM | VARCHAR2 | (4) | Y | UOM |
DELETE_MARK | NUMBER | (5) | Y | Delete mark used for logical deletion in OPM |
EXTERNAL_ID | VARCHAR2 | (32) | External ID | |
ITEM_NUMBER | VARCHAR2 | (32) | Y | Item number |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Item Description |
ITEM_UOM | VARCHAR2 | (4) | Y | Item Primary UOM |
INVENTORY_TYPE | VARCHAR2 | (4) | Inventory Type | |
FORMULA_ID | NUMBER | (10) | Formula Id | |
FORMULA_NUMBER | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | Sub Lot Number | |
BATCH_NUMBER | VARCHAR2 | (32) | Production Batch Number | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
VENDOR_NUMBER | VARCHAR2 | (32) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (40) | Vendor Name | |
OPERATION_ID | NUMBER | (10) | Operation Id | |
OPERATION_NUMBER | VARCHAR2 | (16) | Operation Number | |
OPERATION_VERSION | NUMBER | (5) | Operation Version | |
ROUTING_ID | NUMBER | (10) | Routing Id | |
ROUTING_NUMBER | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERSION | NUMBER | (5) | Routing Version | |
ROUTING_STEP_NUMBER | NUMBER | (5) | Routing Step Number | |
CUSTOMER_ID | NUMBER | (15) | Customer ID | |
SHIP_TO_SITE_ID | NUMBER | Ship to Site ID |
APPS.PMIBV_QC_SAMPLE_V is not referenced by any database object
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUALITY_CONTROL_SPEC_ID | NUMBER | (10) | ||
ASSAY_TYPE_ID | NUMBER | (15) | ||
ORGANIZATION_CODE | VARCHAR2 | (4) | ||
WAREHOUSE_CODE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
DOCUMENT_TYPE | VARCHAR2 | (4) | ||
VENDOR_SPECIFICATION | NUMBER | (5) | ||
VENDOR_CERTIFICATION | NUMBER | (5) | ||
CUSTOMER_SPECIFICATION | NUMBER | (5) | ||
CUSTOMER_CERTIFICATION | NUMBER | (5) | ||
ASSAY_CODE | VARCHAR2 | (16) | ||
TEXT_SPEC | VARCHAR2 | (16) | ||
MIN_SPEC | NUMBER | |||
MAX_SPEC | NUMBER | |||
TARGET_SPEC | NUMBER | |||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | ||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
OUT_OF_ACTION_CODE | VARCHAR2 | (4) | ||
OUT_OF_ACTION_INTERVAL | NUMBER | |||
PREFERENCE | NUMBER | (5) | ||
PRINT_COA_SHIPPED | NUMBER | (5) | ||
PRINT_COA_INVOICED | NUMBER | (5) | ||
VENDOR_COA_REQUIRED | VARCHAR2 | (80) | ||
DELETE_MARK | NUMBER | (5) | ||
ROUTING_STEP_NUMBER | NUMBER | (5) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
ITEM_NUMBER | VARCHAR2 | (32) | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | ||
VENDOR_ID | NUMBER | (10) | ||
VENDOR_NUMBER | VARCHAR2 | (32) | ||
VENDOR_NAME | VARCHAR2 | (40) | ||
FORMULA_NUMBER | CHAR | (1) | ||
FORMULA_VERSION | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (32) | ||
SUB_LOT_NUMBER | VARCHAR2 | (32) | ||
BATCH_NUMBER | CHAR | (1) | ||
ROUTING_NUMBER | CHAR | (1) | ||
ROUTING_VERSION | NUMBER | |||
OPERATION_NUMBER | CHAR | (1) | ||
OPERATION_VERSION | NUMBER | |||
EFFECTIVE | VARCHAR2 | (80) | ||
CUSTOMER_ID | NUMBER | (15) | ||
SHIP_TO_SITE_ID | NUMBER |
APPS.PMIBV_QC_SPECIFICATIONS_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Resource
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCES | VARCHAR2 | (16) | Y | Resource Name |
RESOURCE_DESC | VARCHAR2 | (240) | Y | Resource Description |
RESOURCE_CLASS | VARCHAR2 | (8) | Resource Class |
APPS.PMIBV_RESOURCE_LOV_V is not referenced by any database object
A Business Intelligence System view
Availability and planned usage of Process Manufacturing resources
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCES | VARCHAR2 | (16) | Y | Code for the resource. |
RESOURCE_DESC | VARCHAR2 | (240) | Y | Description of the resource. |
STD_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which resource usage is expressed. | |
RESOURCE_CLASS | VARCHAR2 | (8) | Resource class to which the resource belongs. | |
RESOURCE_COST_COMP_CLASS_ID | NUMBER | (10) | Y | Surrogate key of the cost component class which is used for tracking costs. |
ORGANIZATION | VARCHAR2 | (4) | Plant code | |
GROUP_RESOURCE | VARCHAR2 | (16) | Resource group - resources can be grouped by this type | |
ASSIGNED_QTY | NUMBER | How many of this resource are in this plant. | ||
DAILY_AVAIL_USE | NUMBER | Number of hours the resource is available in the plant each day. | ||
RESOURCE_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which daily_avail_use is expressed. | |
NOMINAL_COST | NUMBER | Cost of the resource in the plant. | ||
INACTIVE_IND | NUMBER | Inactive indicator. 0=Active, 1=Inactive. | ||
IDEAL_CAPACITY | NUMBER | Optimum throughput capacity. | ||
MIN_CAPACITY | NUMBER | Minimum throughput capacity. | ||
MAX_CAPACITY | NUMBER | Maximum throughput capacity. | ||
CAPACITY_UOM | VARCHAR2 | (4) | Unit of measure in which capacity is expressed. | |
BATCH_ID | NUMBER | (10) | Surrogate key to the batch. | |
BATCHSTEP_NO | NUMBER | (10) | The number of the batch step performing the operation. | |
ACTIVITY | VARCHAR2 | (16) | The activity performed in the operation. | |
BATCHSTEPLINE_ID | NUMBER | (10) | Surrogate key to the batch step line. | |
OPRN_LINE_ID | NUMBER | (10) | Surrogate key to the operation line, 0 if a resource/activity was inserted for the batch. | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Cost analysis code, defaults from fm_oprn_dtl. | |
OPERATION_COST_COMP_CLASS_ID | NUMBER | (10) | Surrogate key for a cost component class , defaults from fm_oprn_dtl. | |
PRIMARY_RESOURCE_INDICATOR | NUMBER | (5) | Primary resource indicator. 0=Not primary resource, 1=Primary resource. | |
SCALE_TYPE | NUMBER | (5) | Scale type. 0=Non-scaleable, 1=Linear scaling. | |
PLAN_RESOURCE_COUNT | NUMBER | Planned resource count, defaults from fm_oprn_dtl. | ||
ACTUAL_RESOURCE_COUNT | NUMBER | Actual resource count, recorded during WIP or certification. | ||
PLAN_RESOURCE_QTY | NUMBER | Planned quantity processed by the resource. | ||
ACTUAL_RESOURCE_QTY | NUMBER | Actual quantity processed by the resource. | ||
PLAN_RESOURCE_USAGE | NUMBER | Planned resource usage, defaults from fm_oprn_dtl. | ||
ACTUAL_RESOURCE_USAGE | NUMBER | Actual resource usage, recorded during WIP or certification. | ||
OPERATION_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which the usage is expressed. | |
DEPENDENT_OPRN_LINE_ID | VARCHAR2 | (0) | Surrogate key to the operation line that this step depends on. | |
OFFSET_INTERVAL | NUMBER | Time offset in hours from operation start to this resource/activity. | ||
PLAN_START_DATE | DATE | Planned start date/time for this step. | ||
ACTUAL_START_DATE | DATE | Actual start date/time for this step. | ||
PLAN_COMPLETE_DATE | DATE | Planned completion date/time for this step. | ||
ACTUAL_COMPLETE_DATE | DATE | Actual completion date/time for this step. | ||
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIBV_RESOURCE_PLAN_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Routing
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTING_NO | VARCHAR2 | (32) | Y | Routing Number |
ROUTING_DESC | VARCHAR2 | (240) | Y | Routing Description |
ROUTING_CLASS | VARCHAR2 | (4) | Routing Class |
APPS.PMIBV_ROUTING_LOV_V is not referenced by any database object
A Business Intelligence System view
Ledger of OPM Costing detail information produced during Cost Rollup processing.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STD_QTY | NUMBER | Y | Effectivity standard quantity converted to an item inventory uom. | |
FORM_PROD_UOM | VARCHAR2 | (4) | UOM of the product within the formula | |
ROUTING_QTY | NUMBER | Y | Routing quantity converted to product inventory uom | |
PRODUCT_QTY | NUMBER | Y | Product qty converted to product inventory uom | |
COST_ALLOC | NUMBER | (10) | Y | Cost allocation percentage - The percentage of the ingredient costs that contribute towards the Product cost |
LINE_TYPE | NUMBER | (10) | Y | Type of line 1=ingredient, -1=byproduct |
ITEM_QTY | NUMBER | Y | Ingredient/byproduct quantity converted to inventory uom | |
ITEM_FMQTY | NUMBER | Y | Ingredient/byproduct quantity at formula uom | |
ITEM_FMQTY_UM | VARCHAR2 | (4) | Ingredient/byproduct formula uom | |
COMPONENT_COST | NUMBER | Y | Ingredient/byproduct Component cost | |
RESOURCE_COUNT | NUMBER | Resource count from the operation details | ||
RESOURCE_USAGE | NUMBER | Resource usage from the operation details | ||
NOMINAL_COST | NUMBER | Nominal cost for the resource at usage uom | ||
USAGE_UOM | VARCHAR2 | (4) | Standard resource uom | |
RUDTL_ID | NUMBER | (10) | Y | Surrogate for this row |
ITEM_ID | NUMBER | (10) | Surrogate for the ingedient/byproduct | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse code | |
RESOURCES | VARCHAR2 | (16) | Resource | |
CMPNTCOST_ID | NUMBER | (10) | Y | Surrogate from cost component details |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIBV_STANDARD_COST_LEDGER_V is not referenced by any database object
A Business Intelligence System view
Process Manufacturing Units of Measure and their associated conversion factors.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UOM_CODE | VARCHAR2 | (25) | Unit of Measure code for which the conversion is defined. | |
UOM_DESC | VARCHAR2 | (40) | UOM Description | |
STANDARD_FACTOR | NUMBER | Conversion factor to the reference UOM of the same Type. | ||
ROUNDING_FACTOR | NUMBER | Unused, defaulted to 0. | ||
REFERENCE_UOM | VARCHAR2 | (0) | Reference Unit of Measure for the same Unit of Measure Type. | |
UOM_TYPE | VARCHAR2 | (10) | Y | The Unit of Measure Type associated with each Unit of Measure |
CREATED_BY | NUMBER | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column |
APPS.PMIBV_UOM_V is not referenced by any database object
A Business Intelligence System view
PMI LOV View for Vendor
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VENDOR_NO | VARCHAR2 | (32) | Y | Vendor Number |
VENDOR_NAME | VARCHAR2 | (40) | Y | Vendor Name |
VENDOR_TYPE | NUMBER | (5) | Y | Vendor Type |
APPS.PMIBV_VENDOR_LOV_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WHSE_CODE | VARCHAR2 | (4) | Y | Warehouse Code |
WHSE_NAME | VARCHAR2 | (40) | Y | Warehouse Name |
MTL_ORGANIZATION_ID | NUMBER | Inventory Organization ID |
APPS.PMIBV_WAREHOUSE_LOV_V is not referenced by any database object
A Business Intelligence System view
Batch Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANT_CODE | VARCHAR2 | (4) | ||
COMPANY_CODE | VARCHAR2 | (4) | Y | |
WHSE_CODE | VARCHAR2 | (4) | ||
BATCH_ID | NUMBER | (10) | Y | |
BATCH_NO | VARCHAR2 | (32) | Y | |
FORMULA_ID | NUMBER | (10) | ||
FORMULA_NO | VARCHAR2 | (32) | Y | |
FORMULA_VERS | NUMBER | Y | ||
ROUTING_ID | NUMBER | (10) | ||
ROUTING_NO | VARCHAR2 | (32) | ||
ROUTING_VERS | NUMBER | (5) | ||
PLAN_START_DATE | DATE | Y | ||
ACTUAL_START_DATE | DATE | |||
EXPCT_CMPLT_DATE | DATE | Y | ||
ACTUAL_CMPLT_DATE | DATE | |||
BATCH_STATUS | NUMBER | (5) | Y | |
ITEM_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | Y | |
ITEM_DESC | VARCHAR2 | (70) | Y | |
PLANNING_CLASS | VARCHAR2 | (8) | ||
INVENTORY_CLASS | VARCHAR2 | (8) | ||
SALES_CLASS | VARCHAR2 | (8) | ||
ITEM_UM | VARCHAR2 | (4) | Y | |
BTCH_ITEM_UM | VARCHAR2 | (4) | ||
LINE_TYPE | NUMBER | (5) | Y | |
PLAN_QTY | NUMBER | Y | ||
PLAN_VALUE | NUMBER | |||
ACTUAL_QTY | NUMBER | Y | ||
ACTUAL_VALUE | NUMBER | |||
FISCAL_YEAR | NUMBER | (15) | Y | |
PERIOD_CODE | NUMBER | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
BASE_CURRENCY | VARCHAR2 | (4) | Y | |
COST_METHOD | VARCHAR2 | (4) | Y |
APPS.PMIFV_BATCH_DETAILS_V is not referenced by any database object
A Business Intelligence System view
Batch Input Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (10) | Y | |
PLAN_INGREDIENT_VALUE | NUMBER | |||
ACTUAL_INGREDIENT_VALUE | NUMBER |
APPS.PMIFV_BATCH_INPUT_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NUMBER | VARCHAR2 | (32) | Y | Item Number |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Item Description |
ITEM_ID | NUMBER | (10) | Y | Item ID |
LOT_ID | NUMBER | (10) | Y | Lot ID |
LOT_NUMBER | VARCHAR2 | (32) | Y | Lot Number |
SUBLOT_NUMBER | VARCHAR2 | (32) | Sublot Number | |
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
ORGN_NAME | VARCHAR2 | (40) | Organization Name | |
BATCH_NUMBER | VARCHAR2 | (32) | Y | Batch Number |
BATCH_ID | NUMBER | (10) | Y | Batch ID |
BATCH_CLOSE_DATE | DATE | Batch Close Date | ||
TRANS_QTY | NUMBER | Y | Transaction Quantity | |
TRANS_UM | VARCHAR2 | (4) | Y | Transaction Unit of Measure |
COMPLETED_IND | NUMBER | (5) | Y | Completed Indicator |
LINE_TYPE | NUMBER | (5) | Y |
APPS.PMIFV_BATCH_LOTS_V is not referenced by any database object
A Business Intelligence System view
Information on a batch and the ingredients, products, and byproducts of that batch.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (10) | Y | Surrogate key to FPO or batch. |
PLANT_CODE | VARCHAR2 | (4) | Production organization in which the batch or FPO is/was/will be run. | |
BATCH_NUMBER | VARCHAR2 | (32) | Y | Batch or FPO number. |
BATCH_TYPE | NUMBER | (5) | Y | Differentiates between Firm Planned Order(10) and batches (0). |
PRODUCTION_ID | NUMBER | (10) | Reserved for future use. Used for tying multiple batches to a campaign/prod ord. When used, validate against PM_PROD_MST. | |
PRODUCTION_SEQUENCE | NUMBER | (5) | Y | Reserved for future use. Batch sequence in campaign/prod order. |
FORMULA_ID | NUMBER | (10) | Surrogate key to formula on which batch or FPO is based. | |
ROUTING_ID | NUMBER | (10) | Surrogate key to routing used. | |
PLAN_START_DATE | DATE | Y | Planned release date/time for batch. | |
ACTUAL_START_DATE | DATE | Actual start date/time for batch. | ||
DUE_DATE | DATE | Y | Required batch completion date/time, notational. | |
EXPECT_COMPLETION_DATE | DATE | Y | Planned batch completion date/time. | |
ACTUAL_COMPLETION_DATE | DATE | Actual completion date. | ||
BATCH_STATUS | NUMBER | (5) | Y | Batch or FPO status. -3=Converted FPO, -1=Cancelled,1=Pending; 2=WIP; 3=Certified; 4=Closed. |
BATCH_STATUS_MEANING | VARCHAR2 | (80) | Batch or FPO status. -3=Converted FPO, -1=Cancelled,1=Pending; 2=WIP; 3=Certified; 4=Closed. | |
PRIORITY_VALUE | NUMBER | Y | Not currently used. | |
PRIORITY_CODE | VARCHAR2 | (4) | Y | Not currently used. |
PRINT_COUNT | NUMBER | (5) | Y | Number of times batch ticket was printed. |
FORMULA_EFFECTIVITY_ID | NUMBER | (10) | Surrogate key to the formula effectivity the batch or FPO was based on. | |
FMCONTROL_CLASS | VARCHAR2 | (8) | Not currently used. | |
WIP_WAREHOUSEE_CODE | VARCHAR2 | (4) | Warehouse used to cost production activity. | |
BATCH_CLOSE_DATE | DATE | Date/time the batch was closed. | ||
PARENTLINE_ID | NUMBER | (10) | For phantom batches. Surrogate key to the batch ingredient line for which this phantom batch produces product. | |
LINE_ID | NUMBER | (10) | Y | Key that uniquely identifies a batch or FPO line. |
FORMULALINE_ID | NUMBER | (10) | Surrogate key to the formula line on which the batch line was based, if any. | |
LINE_NO | NUMBER | (5) | Y | Sequential line number for each line type in a batch or FPO. |
ITEM_ID | NUMBER | (10) | Surrogate key to the item that is a product, ingredient, or byproduct. | |
LINE_TYPE | NUMBER | (5) | Y | -1=Ingredient; 1=Product; 2=Byproduct. |
LINE_TYPE_MEANING | VARCHAR2 | (80) | -1=Ingredient; 1=Product; 2=Byproduct. | |
PLAN_QTY | NUMBER | Y | The quantity that this line was planned to produce or consume, in the batch UOM (item_um column). | |
PLAN_QTY2 | VARCHAR2 | (0) | The quantity that this line was planned to produce or consume, in the secondary UOM of an item(for dual UOM items). | |
ITEM_UOM | VARCHAR2 | (4) | UOM in which planned and actual qty is entered on the batch. | |
ITEM_UOM2 | VARCHAR2 | (0) | Secondary UOM of item. | |
ITEM_NUMBER | VARCHAR2 | (32) | Y | Name of the item. |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
ACTUAL_QTY | NUMBER | Y | Sum (trans_qty) of completed transactions for line, in the batch UOM. | |
ACTUAL_QTY2 | VARCHAR2 | (0) | Sum (trans_qty) of completed transactions for line, in the secondary UOM of an item(for dual UOM items). | |
RELEASE_TYPE | NUMBER | (5) | Y | Release (or certification) type. 0=Automatic release (certification), 1=Manual release (certification). |
SCRAP_FACTOR | NUMBER | Y | Scrap factor decimal used to a trans_qty that allows for scrap. | |
SCALE_TYPE | NUMBER | (5) | Y | 0=Fixed qty (non-scalable), 1=Linear scaling. |
PHANTOM_TYPE | NUMBER | (5) | Y | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. |
COST_ALLOC | NUMBER | For products, fraction of cost allocated to this product. | ||
ALLOC_IND | NUMBER | (5) | Allocation indicator. 0=Not fully allocated, 1=Fully allocated. | |
COST | NUMBER | Not currently used. | ||
PHANTOM_ID | NUMBER | (10) | For phantoms. Surrogate key of the phantom batch which produces the ingredient. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column |
APPS.PMIFV_BATCH_MATERIAL_V is not referenced by any database object
A Business Intelligence System view
Batch Operation Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANT_CODE | VARCHAR2 | (4) | ||
COMPANY_CODE | VARCHAR2 | (4) | Y | |
WHSE_CODE | VARCHAR2 | (4) | ||
BATCH_ID | NUMBER | (10) | Y | |
BATCH_NO | VARCHAR2 | (32) | Y | |
BATCH_PLAN_START_DATE | DATE | Y | ||
BATCH_ACTUAL_START_DATE | DATE | |||
BATCH_EXPCT_CMPLT_DATE | DATE | Y | ||
BATCH_ACTUAL_CMPLT_DATE | DATE | |||
BATCH_STATUS | NUMBER | (5) | Y | |
ITEM_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | Y | |
ITEM_DESC | VARCHAR2 | (70) | Y | |
PLANNING_CLASS | VARCHAR2 | (8) | ||
BATCHSTEP_NO | NUMBER | (10) | ||
RESOURCES | VARCHAR2 | (16) | ||
RESOURCE_DESCRIPTION | VARCHAR2 | (240) | ||
RESOURCE_CLASS | VARCHAR2 | (8) | ||
ACTIVITY | VARCHAR2 | (16) | ||
PRIM_RSRC_IND | NUMBER | (5) | ||
SCALE_TYPE | NUMBER | (5) | ||
PLAN_RSRC_COUNT | NUMBER | |||
ACTUAL_RSRC_COUNT | NUMBER | |||
PLAN_RSRC_QTY | NUMBER | |||
ACTUAL_RSRC_QTY | NUMBER | |||
PLAN_RSRC_USAGE | NUMBER | |||
ACTUAL_RSRC_USAGE | NUMBER | |||
USAGE_UM | VARCHAR2 | (4) | ||
PLAN_START_DATE | DATE | |||
ACTUAL_START_DATE | DATE | |||
PLAN_CMPLT_DATE | DATE | |||
ACTUAL_CMPLT_DATE | DATE | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
PERIOD_NUM | NUMBER | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y |
APPS.PMIFV_BATCH_OPRN_DETAIL_V is not referenced by any database object
A Business Intelligence System view
Batch QC Details Consolidated
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANT_CODE | VARCHAR2 | (4) | ||
COMPANY_CODE | VARCHAR2 | (4) | Y | |
WHSE_CODE | VARCHAR2 | (4) | ||
BATCH_ID | NUMBER | (10) | Y | |
BATCH_NO | VARCHAR2 | (32) | Y | |
ACTUAL_CMPLT_DATE | DATE | |||
ITEM_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | Y | |
ITEM_DESC | VARCHAR2 | (70) | Y | |
PLANNING_CLASS | VARCHAR2 | (8) | ||
NO_OF_SAMPLES_TAKEN | NUMBER | |||
NO_OF_SAMPLES_COMPLET | NUMBER | |||
NO_OF_SAMPLES_PASSED | NUMBER | |||
NO_OF_TIMES_ADJUSTED | NUMBER | |||
FISCAL_YEAR | NUMBER | (15) | Y | |
PERIOD_CODE | NUMBER | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y |
APPS.PMIFV_BATCH_QC_V is not referenced by any database object
A Business Intelligence System view
Batch Status
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | ||
PLANT_CODE | VARCHAR2 | (4) | Y | |
WHSE_CODE | VARCHAR2 | (4) | Y | |
FISCAL_YEAR | NUMBER | (15) | Y | |
PERIOD_NUM | NUMBER | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | ||
ITEM_ID | NUMBER | (10) | Y | |
ITEM_NO | VARCHAR2 | (32) | Y | |
ITEM_DESC | VARCHAR2 | (70) | Y | |
PLANNING_CLASS | VARCHAR2 | (8) | ||
BATCH_STATUS_CODE | VARCHAR2 | (30) | Y | |
BATCH_STATUS | VARCHAR2 | (80) | Y | |
BATCH_COUNT | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE |
APPS.PMIFV_BATCH_STATUS_V is not referenced by any database object
A Business Intelligence System view
Batch Transaction Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANT_CODE | VARCHAR2 | (4) | ||
COMPANY_CODE | VARCHAR2 | (4) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
BATCH_ID | NUMBER | (10) | ||
ITEM_ID | NUMBER | (10) | ||
LOT_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | Y | |
ITEM_DESC | VARCHAR2 | (70) | Y | |
PLANNING_CLASS | VARCHAR2 | (8) | ||
ITEM_UM | VARCHAR2 | (4) | Y | |
QC_GRADE | VARCHAR2 | (4) | ||
TRANS_QTY | NUMBER | |||
TRANS_VALUE | NUMBER | |||
FISCAL_YEAR | NUMBER | (15) | Y | |
PERIOD_CODE | NUMBER | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
BASE_CURRENCY | VARCHAR2 | (4) | Y |
APPS.PMIFV_BATCH_TRANS_V is not referenced by any database object
A Business Intelligence System view
Batch QC Results
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | ||
ORGN_CODE | VARCHAR2 | (4) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
ACTUAL_CMPLT_DATE | DATE | |||
SAMPLE_ID | NUMBER | |||
SAMPLE_NO | VARCHAR2 | (80) | ||
SAMPLE_DESC | VARCHAR2 | (80) | ||
SAMPLE_STATUS | VARCHAR2 | (3) | ||
SAMPLE_STATUS_MEANING | VARCHAR2 | (80) | Sample Status Meaning | |
ASSAY_CODE | VARCHAR2 | (80) | ||
RESULT_DATE | DATE | |||
RESULT | VARCHAR2 | (80) | ||
TEXT_SPEC | VARCHAR2 | (16) | ||
TARGET_SPEC | VARCHAR2 | (40) | ||
MIN_SPEC | VARCHAR2 | (40) | ||
MAX_SPEC | VARCHAR2 | (40) | ||
RESULTS_QCUNIT_CODE | VARCHAR2 | (25) | ||
ACCEPT | VARCHAR2 | (1) | ||
ITEM_ID | NUMBER | |||
ITEM_NUMBER | VARCHAR2 | (32) | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | ||
BATCH_ID | NUMBER | |||
BATCH_NO | VARCHAR2 | (32) | ||
BATCH_ADJUSTED | NUMBER | |||
ROUTING_ID | NUMBER | |||
ROUTING_NO | VARCHAR2 | (32) | ||
ROUTING_VERS | NUMBER | (5) | ||
ROUTINGSTEP_ID | NUMBER | |||
ROUTINGSTEP_NO | NUMBER | |||
OPRN_ID | NUMBER | |||
OPERATION_NO | VARCHAR2 | (16) | ||
FISCAL_YEAR | NUMBER | (15) | ||
PERIOD_CODE | NUMBER | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) |
APPS.PMIFV_BTCH_QCRSLT_V is not referenced by any database object
A Business Intelligence System view
Costing information for Burden (Overhead) details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BURDEN_QTY | NUMBER | Y | Quantity of Burden used in calculating the burden cost | |
BURDEN_USAGE | NUMBER | Y | Burden Usage - used in calculating the burden cost | |
BURDEN_UM | VARCHAR2 | (4) | Burden uom used in calculating the burden cost | |
BURDEN_FACTOR | NUMBER | Y | Burden factor used in calculating the burden cost | |
ROLLOVER_IND | NUMBER | (5) | Indicates if the burden cost has been frozen or not - 0 = not frozen | |
ITEM_QTY | NUMBER | Y | Quantity of item used in calculating the burden cost | |
ITEM_UM | VARCHAR2 | (4) | Item uom used in calculating the burden cost | |
BURDENLINE_ID | NUMBER | (10) | Y | Surrogate for this burden line. (also posted to cm_acst_led.transline_id by Actual Cost Process) |
ORGN_CODE | VARCHAR2 | (4) | Organization for the burden | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse | |
ITEM_ID | NUMBER | (10) | Surrogate for item | |
RESOURCES | VARCHAR2 | (16) | Y | Resource used for the burden cost |
CALENDAR_CODE | VARCHAR2 | (4) | Cost Calendar | |
CALENDAR_DESCRIPTION | VARCHAR2 | (40) | Costing Calendar description | |
PERIOD_CODE | VARCHAR2 | (4) | Cost Period - specifies the start and end dates for the burden cost | |
PERIOD_DESCRIPTION | VARCHAR2 | (40) | Costing Period Description | |
COST_MTHD_CODE | VARCHAR2 | (4) | Specific costing method that the burden cost will be applied under | |
COST_CMPNTCLS_ID | NUMBER | (10) | Y | Surrogate for component class |
CMPNTCOST_ID | NUMBER | (10) | Surrogate to cost component details | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Y | Analysis code |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column |
APPS.PMIFV_BURDEN_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QTY_ONHAND | NUMBER | Current onhand quantity of the item/lot/sublot in the warehouse/location, expressed in the primary unit of measure for the item. | ||
QTY_ONHAND_IN_UOM2 | NUMBER | Current onhand quantity of the item/lot/sublot in the warehouse/location, expressed in the secondary unit of measure for the item, for dual UOM items. | ||
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse in which the item is located. | |
LOT_ID | NUMBER | (10) | Y | Surrogate key for the lot/sublot. 0 identifies the default lot. LOT_ID is set to '0' for items without lot control. |
LOCATION | VARCHAR2 | (16) | Location in which the item is located. | |
ITEM_ID | NUMBER | (10) | Y | Surrogate key for the item. |
LOT_STATUS | VARCHAR2 | (4) | Status of the lot in the warehouse/location. | |
QC_HOLD_REASON_CODE | VARCHAR2 | (4) | QC hold reason code. | |
ITEM_NUMBER | VARCHAR2 | (32) | Y | Name of the item. |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
ITEM_UOM | VARCHAR2 | (4) | Y | Uom of the item by which the inventory balances are maintained. |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
LOT_NUMBER | VARCHAR2 | (32) | Y | Code for the lot. |
SUBLOT_NUMBER | VARCHAR2 | (32) | Code for the sublot. | |
QC_GRADE | VARCHAR2 | (4) | QC grade of the lot. | |
LOT_EXPIRE_DATE | DATE | Lot expiration date. | ||
LOT_CREATION_DATE | DATE | Y | Standard who column | |
VENDOR_LOT_NUMBER | VARCHAR2 | (32) | Vendor lot number. | |
WAREHOUSE_NAME | VARCHAR2 | (40) | Name of the warehouse. | |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization that owns the warehouse. | |
CO_CODE | VARCHAR2 | (4) | Y | Company code of the organization. |
LOCATION_DESCRIPTION | VARCHAR2 | (40) | Description of the location. | |
LOCATION_CAPACITY | NUMBER | Capacity of the location. | ||
CAPACITY_UOM | VARCHAR2 | (4) | Unit of measure in which the capacity is expressed. | |
LOT_STATUS_DESC | VARCHAR2 | (40) | Description of status. | |
QCHOLD_REASON_DESC | VARCHAR2 | (80) | Description of the QC hold reason. | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
CREATION_DATE | DATE | Standard who column |
APPS.PMIFV_CURRENTINVENTORY_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_NO | VARCHAR2 | (32) | Y | Alphanumeric formula name or number. |
FORMULA_VERSION | NUMBER | Y | Formula version. | |
FORMULA_TYPE | NUMBER | (5) | Y | 0=std formula; 1=packaged item formula (these are not currently used). |
FORMULE_TYPE_MEANING | VARCHAR2 | (80) | 0=std formula; 1=packaged item formula (these are not currently used). | |
SCALE_TYPE | NUMBER | (5) | Y | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
FORMULA_ID | NUMBER | (10) | Y | Surrogate for formula_no + formula_vers. |
FORMULA_EFECTIVITY_ID | NUMBER | (15) | Surrogate key for this effectivity row. | |
ORGANIZATION_CODE | VARCHAR2 | (4) | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | |
EFFECTIVITY_ITEM_ID | NUMBER | (15) | Surrogate key for the item which is produced by the formula. | |
EFECTIVITY_ROUTING_ID | NUMBER | (15) | Surrogate key for the routing/routing version to be used, if any. | |
EFFECTIVITY_FORMULA_ID | NUMBER | (10) | Surrogate key for the formula /formula version to be used. | |
EFFECTIVITY_CUST_ID | NUMBER | Surrogate key for the customer for which this effectivity is used, if any. | ||
EFFECTIVITY_FORMULA_USE | VARCHAR2 | (30) | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. | |
EFF_FORMULA_USE_MEANING | VARCHAR2 | (80) | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. | |
EFFECTIVITY_END_DATE | DATE | The end date of the effectivity. | ||
EFFECTIVITY_START_DATE | DATE | The start date of the effectivity. | ||
MIN_OUTPUT_QTY_PRIMARY_UOM | NUMBER | The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item. | ||
MAX_OUTPUT_QTY_PRIMARY_UOM | NUMBER | The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item. | ||
MIN_OUTPUT_QTY_EFF_UOM | NUMBER | The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | ||
MAX_OUTPUT_QTY_EFF_UOM | NUMBER | The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | ||
PRODUCT_QTY | NUMBER | Standard batch size for this rec. | ||
PRODUCT_UOM | VARCHAR2 | (4) | UOM for min_qty and max_qty. | |
EFFECTIVITY_PREFERENCE | NUMBER | (15) | Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column. | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Name of the item. | |
PRODUCT_DESC1 | VARCHAR2 | (70) | Short description of the item that is displayed during the item look up. | |
PRODUCT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
PRODUCT_PRIMARY_UOM | VARCHAR2 | (4) | Uom of the item by which the inventory balances are maintained. | |
PRODUCT_SECONDARY_UOM | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
CUSTOMER_NO | VARCHAR2 | (4000) | Unique identifier of a customer. | |
CUSTOMER_NAME | VARCHAR2 | (40) | Customer name | |
ROUTING_ID | NUMBER | (10) | Routing Id. | |
ROUTING_NO | VARCHAR2 | (32) | Routing name. | |
ROUTING_VERSION | NUMBER | (5) | Routing version. | |
ROUTING_DESCRIPTION | VARCHAR2 | (240) | Routing description. | |
ROUTING_CLASS | VARCHAR2 | (4) | User defined class for routings. | |
ROUTING_QTY | NUMBER | Used in ratio with formula and batch qty to scale individual step requirements. | ||
ROUTING_ITEM_UOM | VARCHAR2 | (4) | Uom of routing qty. | |
COST_LEVEL | NUMBER | (5) | Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Actual Cost Process, 1= Costs via Ingredient calculated by Cost Rollup Process. | |
COMPONENT_COST | NUMBER | Component cost | ||
BURDEN_INDICATOR | NUMBER | (5) | Indicates if costs came from burdens 0=No 1=Yes | |
ROLLOVER_INDICATOR | NUMBER | (5) | Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated. | |
COSTING_TOTAL_QTY | NUMBER | Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs. | ||
COSTCALC_ORIG | NUMBER | (5) | Cost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development Process | |
RMCALC_TYPE | NUMBER | (5) | Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI | |
ROLLUP_REF_NO | NUMBER | (10) | Reference number of the Cost Rollup process that calculated this cost | |
COMPONENT_COST_ID | NUMBER | (10) | Surrogate ID for the Cost Component | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse for which the cost is specified | |
WHSE_NAME | VARCHAR2 | (40) | Name of the warehouse. | |
CALENDAR_CODE | VARCHAR2 | (4) | Cost Calendar for which the cost is specified | |
CALENDAR_DESCRIPTION | VARCHAR2 | (40) | Costing Calendar description | |
PERIOD_CODE | VARCHAR2 | (4) | Costing Period for which the cost is specified | |
PERIOD_DESCRIPTION | VARCHAR2 | (40) | Costing Period Description | |
COST_MTHD_CODE | VARCHAR2 | (4) | Cost Method for which the cost is specified | |
COST_CMPNTCLS_ID | NUMBER | (10) | Surrogate for component class | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Analysis code | |
COST_CMPNTCLS_CODE | VARCHAR2 | (32) | Y | Cost component class |
COST_CMPNTCLS_DESC | VARCHAR2 | (240) | Y | Cost component class description |
SORT_SEQUENCE | NUMBER | (10) | Y | Sequence the component costs are sorted by on Cost details screen |
USAGE_IND | NUMBER | (5) | Y | Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment |
PRIMARY_COMPONENT_CLASS_ID | NUMBER | (10) | Y | Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. Default is Primary Class. |
PRODUCT_COST_IND | NUMBER | (5) | Y | This field indicates whether the component class will affect the cost of a product or not. Valid values are: 0 = Not a product cost , 1 = Product Cost. |
UPDATE_COST_IND | NUMBER | (5) | Y | This field indicates whether the component cost will be updated to the GL area. Valid Values are 0 = Do not update to GL area, 1 = Update to GL Area. |
CMPNT_GROUP | VARCHAR2 | (32) | Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group | |
PPV_IND | NUMBER | (5) | Y | Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations. |
LEDGER_STD_QTY | NUMBER | Effectivity standard quantity converted to an item inventory uom. | ||
LEDGER_FORM_PROD_UOM | VARCHAR2 | (4) | UOM of the product within the formula | |
LEDGER_ROUTING_QTY | NUMBER | Routing quantity converted to product inventory uom | ||
LEDGER_PRODUCT_QTY | NUMBER | Product qty converted to product inventory uom | ||
LEDGER_COST_ALLOC | NUMBER | (10) | Cost allocation percentage - The percentage of the ingredient costs that contribute towards the Product cost | |
LEDGER_LINE_TYPE | NUMBER | (10) | Type of line 1=ingredient, -1=byproduct | |
LEDGER_LINE_TYPE_MEANING | VARCHAR2 | (80) | Type of line 1=ingredient, -1=byproduct | |
LEDGER_ITEM_QTY | NUMBER | Ingredient/byproduct quantity converted to inventory uom | ||
LEDGER_ITEM_FMQTY | NUMBER | Ingredient/byproduct quantity at formula uom | ||
LEDGER_ITEM_FMQTY_UM | VARCHAR2 | (4) | Ingredient/byproduct formula uom | |
LEDGER_COMPONENT_COST | NUMBER | Ingredient/byproduct Component cost | ||
LEDGER_RESOURCE_COUNT | NUMBER | Resource count from the operation details | ||
LEDGER_RESOURCE_USAGE | NUMBER | Resource usage from the operation details | ||
LEDGER_NOMINAL_COST | NUMBER | Nominal cost for the resource at usage uom | ||
LEDGER_USAGE_UOM | VARCHAR2 | (4) | Standard resource uom | |
LEDGER_RUDTL_ID | NUMBER | (10) | Surrogate for this row | |
LEDGER_ITEM_ID | NUMBER | (10) | Surrogate for the ingedient/byproduct | |
LEDGER_WHSE_CODE | VARCHAR2 | (4) | Warehouse code | |
LEDGER_RESOURCES | VARCHAR2 | (16) | Resource | |
LEDGER_ITEM_NUMBER | VARCHAR2 | (32) | Y | Name of the item. |
LEDGER_ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
LEDGER_ITEM_UOM | VARCHAR2 | (4) | Y | Uom of the item by which the inventory balances are maintained. |
LEDGER_ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_FORMULA_COST_V is not referenced by any database object
A Business Intelligence System view
The product and effectivity information for a formula including routing information. This does not contain ingredient information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_NO | VARCHAR2 | (32) | Y | Alphanumeric formula name or number. |
FORMULA_VERSION | NUMBER | Y | Formula version. | |
FORMULA_TYPE | NUMBER | (5) | Y | 0=std formula; 1=packaged item formula (these are not currently used). |
FORMULA_TYPE_MEANING | VARCHAR2 | (80) | 0=std formula; 1=packaged item formula (these are not currently used). | |
SCALE_TYPE | NUMBER | (5) | Y | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
FORMULA_ID | NUMBER | (10) | Y | Surrogate for formula_no + formula_vers. |
FORMULA_EFECTIVITY_ID | NUMBER | (15) | Surrogate key for this effectivity row. | |
ORGNIZATION_CODE | VARCHAR2 | (4) | The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing. | |
EFFECTIVITY_ITEM_ID | NUMBER | (15) | Surrogate key for the item which is produced by the formula. | |
EFECTIVITY_ROUTING_ID | NUMBER | (15) | Surrogate key for the routing/routing version to be used, if any. | |
EFFECTIVITY_FORMULA_ID | NUMBER | (10) | Surrogate key for the formula /formula version to be used. | |
EFFECTIVITY_CUST_ID | NUMBER | Surrogate key for the customer for which this effectivity is used, if any. | ||
EFFECTIVITY_FORMULA_USE | VARCHAR2 | (30) | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. | |
EFF_FORMULA_USE_MEANING | VARCHAR2 | (80) | The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS. | |
EFFECTIVITY_END_DATE | DATE | The end date of the effectivity. | ||
EFFECTIVITY_START_DATE | DATE | The start date of the effectivity. | ||
MIN_OUTPUT_QTY_PRIMARY_UOM | NUMBER | The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item. | ||
MAX_OUTPUT_QTY_PRIMARY_UOM | NUMBER | The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item. | ||
MIN_OUTPUT_QTY_EFF_UOM | NUMBER | The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | ||
MAX_OUTPUT_QTY_EFF_UOM | NUMBER | The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column. | ||
PRODUCT_QTY | NUMBER | Standard batch size for this rec. | ||
PRODUCT_UOM | VARCHAR2 | (4) | UOM for min_qty and max_qty. | |
EFFECTIVITY_PREFERENCE | NUMBER | (15) | Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column. | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Name of the item. | |
PRODUCT_DESC1 | VARCHAR2 | (70) | Short description of the item that is displayed during the item look up. | |
PRODUCT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
CUSTOMER_NO | VARCHAR2 | (4000) | Unique identifier of a customer. | |
CUSTOMER_NAME | VARCHAR2 | (40) | Customer name | |
ROUTING_NO | VARCHAR2 | (32) | Routing name. | |
ROUTING_VERSION | NUMBER | (5) | Routing version. | |
ROUTING_DESCRIPTION | VARCHAR2 | (240) | Routing description. | |
ROUTING_CLASS | VARCHAR2 | (4) | User defined class for routings. | |
ROUTING_QTY | NUMBER | Used in ratio with formula and batch qty to scale individual step requirements. | ||
ROUTING_ITEM_UOM | VARCHAR2 | (4) | Uom of routing qty. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_FORMULA_SUMMARY_V is not referenced by any database object
A Business Intelligence System view
Costing information from both the GL and Process Manufacturing costing tables.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NUMBER | VARCHAR2 | (32) | Name of the item. | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse | |
CALENDAR_CODE | VARCHAR2 | (4) | Calendar specified by start date and end date | |
CALENDAR_DESCRIPTION | VARCHAR2 | (40) | Costing Calendar description | |
PERIOD_CODE | VARCHAR2 | (4) | Period specified by start date and end date | |
PERIOD_DESCRIPTION | VARCHAR2 | (40) | Costing Period Description | |
CDA_COST_MTHD_CODE | VARCHAR2 | (4) | Not currently used. | |
GL_COST_MTHD_CODE | VARCHAR2 | (4) | Cost method for accounting cost. | |
COST_COMPONENT_CLASS_CODE | VARCHAR2 | (32) | Cost component class | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Analysis Code | |
COST | NUMBER | Cost | ||
GL_COST | NUMBER | Component Cost |
APPS.PMIFV_GL_CM_COST_COMPARISON_V is not referenced by any database object
A Business Intelligence System view
This view contains detail information about all completed and pending Inventory transaction .
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE | CHAR | (1) | C=from completed transactions, P=from pending transactions | |
TRANS_ID | NUMBER | (10) | Surrogate key for the item. | |
ITEM_ID | NUMBER | (10) | Unique key for the transaction. | |
LINE_ID | NUMBER | (10) | Surrogate key for the document line that produced the transaction. | |
CO_CODE | VARCHAR2 | (4) | Company affected by the transaction (company which owns the organization which created the transaction). | |
ORGN_CODE | VARCHAR2 | (4) | Organization which created the transaction. | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse affected by the transaction. | |
LOT_ID | NUMBER | (10) | Surrogate key of the lot. | |
LOCATION | VARCHAR2 | (16) | Location affected by the transaction. | |
DOC_ID | NUMBER | (10) | Surrogate key of the document that created the transaction. | |
DOC_TYPE | VARCHAR2 | (4) | Type of document which created the transaction. | |
DOC_LINE | NUMBER | (10) | Not currently used. | |
LINE_TYPE | NUMBER | (5) | Line type. | |
LINE_TYPE_MEANING | VARCHAR2 | (80) | Line type. | |
REASON_CODE | VARCHAR2 | (4) | Reason code associated with the transaction. | |
TRANS_DATE | DATE | Transaction date. | ||
TRANS_QTY | NUMBER | Quantity of the transaction in the primary UOM of an item. | ||
TRANS_QTY2 | NUMBER | Quantity of the transaction in the secodary UOM of an item, if dual UOM controlled. | ||
QC_GRADE | VARCHAR2 | (4) | Grade associated with the transaction. | |
LOT_STATUS | VARCHAR2 | (4) | Lot status associated with the transaction. | |
TRANS_STAT | VARCHAR2 | (4) | Not currently used. | |
TRANS_UM | VARCHAR2 | (4) | UOM in which trans_qty is expressed. | |
TRANS_UM2 | VARCHAR2 | (4) | UOM in which trans_qty2 is expressed. | |
OP_CODE | NUMBER | (15) | Operator who created the transaction. | |
GL_POSTED_IND | NUMBER | (10) | GL posted indicator. 0=Not posted to GL, 1=Posted to GL. | |
EVENT_ID | NUMBER | (10) | Event ID. | |
ITEM_NO | VARCHAR2 | (32) | Name of the item. | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Short description of the item that is displayed during the item look up. | |
ITEM_UOM | VARCHAR2 | (4) | Uom of the item by which the inventory balances are maintained. | |
CURRENT_FISCAL_YEAR | VARCHAR2 | (4) | Fiscal year defined in Inventory calendar | |
CURRENT_PERIOD | NUMBER | (5) | Current Period | |
PERIOD_DESC | VARCHAR2 | (40) | Period Description | |
PERIOD_START_DATE | DATE | Period start date | ||
PERIOD_END_DATE | DATE | Period end date | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
APPS.PMIFV_INVENTORY_TRANSACTIONS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ONHAND_QTY | NUMBER | Total nettable qty of this item/grade in this warehouse, expressed in the primary unit of measure of an item. | ||
ONHAND_QTY2 | NUMBER | Total nettable qty of this item/grade in this warehouse, expressed in the secondary unit of measure of an item, if dual UOM controlled. | ||
ONHAND_PRODUCTION_QTY | NUMBER | Total qty available for use as a production ingredient, expressed in the primary UOM of an item. | ||
ONHAND_PRODUCTION_QTY2 | NUMBER | Total qty available for use as a production ingredient, expressed in the secondary UOM of an itemif dual UOM controlled. | ||
ONHAND_ORDER_QTY | NUMBER | Total qty available for ordering, expressed in the primary UOM of an item. | ||
ONHAND_ORDER_QTY2 | NUMBER | Total qty available for ordering, expressed in the secondary UOM of an item, if dual UOM controlled. | ||
ONHAND_SHIP_QTY | NUMBER | Total qty available for shipping, expressed in the primary UOM of an item. | ||
ONHAND_SHIP_QTY2 | NUMBER | Total qty available for shipping, expressed in the secondary UOM of an item, if dual UOM controlled. | ||
ONPURCH_QTY | NUMBER | Total qty pending from purchase orders, expressed in the primary UOM of an item. | ||
ONPURCH_QTY2 | NUMBER | Total qty pending from purchase orders, expressed in the secondary UOM of an item if dual UOM controlled. | ||
PRODUCTION_PENDING_QTY | NUMBER | Total qty of product pending from production, expressed in the primary UOM of an item. | ||
PRODUCTION_PENDING_QTY2 | NUMBER | Total qty of product pending from production, expressed in the secondary UOM of an item. | ||
COMMITTED_SALES_QTY | NUMBER | Total qty committed to sales orders and shipments, expressed in the primary UOM of an item. | ||
COMMITTED_SALES_QTY2 | NUMBER | Total qty committed to sales orders and shipments, expressed in the secondary UOM of an item if dual UOM controlled. | ||
COMMITTED_PRODUCTION_QTY | NUMBER | Total qty of ingredient committed to batches, expressed in the primary UOM of an item. | ||
COMMITTED_PRODUCTION_QTY2 | NUMBER | Total qty of ingredient committed to batches, expressed in the secondary UOM of an item if dual UOM controlled. | ||
INTRANSIT_QTY | NUMBER | Not currently used. | ||
NTRANSIT_QTY2 | NUMBER | Not currently used. | ||
ITEM_ID | NUMBER | (10) | Y | Surrogate key for the item. |
WHSE_CODE | VARCHAR2 | (4) | Warehouse in which the inventory is located. | |
ORGN_CODE | VARCHAR2 | (4) | Organization code. | |
CO_CODE | VARCHAR2 | (4) | Company code of the organization. | |
QC_GRADE | VARCHAR2 | (4) | Grade of the inventory. NULL value denotes that QC Grade does not apply to item. | |
ITEM_NO | VARCHAR2 | (32) | Y | Name of the item. |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
ALTERNATE_ITEMA | VARCHAR2 | (32) | Alternate name for the item. | |
ALTERNATE_ITEMB | VARCHAR2 | (32) | Second alternate name for the item. | |
ITEM_UOM | VARCHAR2 | (4) | Y | Uom of the item by which the inventory balances are maintained. |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
PLANNING_CLASS | VARCHAR2 | (8) | Planning class for an item. Used for MPS and MRP reporting. | |
WAREHOUSE_NAME | VARCHAR2 | (40) | Name of the warehouse. | |
QC_GRADE_DESC | VARCHAR2 | (40) | Description of the QC grade. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_INV_SUMMARY_V is not referenced by any database object
A Business Intelligence System view
Costing information for an item retrieved from Oracle Financial GL tables. This is the GL equivalent of the item_cost view which retrieves data from the OPM costing tables.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPONENT_COST_AMT | NUMBER | Y | Component Cost | |
ITEMCOST_ID | NUMBER | (10) | Y | Unique item cost identifier. Foreign key from GL_ITEM_CST table. |
COST_CMPNTCLS_ID | NUMBER | (10) | Y | Unique item cost component class identifier. |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Y | Cost analysis code of cost component. |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization of item cost. | |
ORGANIZATION_NAME | VARCHAR2 | (40) | Y | Organization name. |
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse for the cost. ( Plant whse or default costing whse.) | |
WAREHOUSE_NAME | VARCHAR2 | (40) | Y | Name of the warehouse. |
ITEM_ID | NUMBER | (10) | Item for which cost is stored | |
COST_MTHD_CODE | VARCHAR2 | (4) | Cost method for accounting cost. | |
CALENDAR_CODE | VARCHAR2 | (4) | Costing calendar code. | |
CALENDAR_DESCRIPTION | VARCHAR2 | (40) | Costing Calendar description | |
PERIOD_CODE | VARCHAR2 | (4) | Costing period code. | |
PERIOD_DESCRIPTION | VARCHAR2 | (40) | Costing Period Description | |
PERIOD_START_DATE | DATE | Starting date of the costing period | ||
PERIOD_END_DATE | DATE | Ending date of the costing period | ||
FORMULA_EFF_ID | NUMBER | (10) | Formula effectivity used in the calculation of accounting cost. | |
GL_ITEMCOST_ID | NUMBER | (10) | Y | Surrogate key to the row. Foreign Key to GL_ITEM_DTL table. |
ITEM_NUMBER | VARCHAR2 | (32) | Y | Name of the item. |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Short description of the item that is displayed during the item look up. | |
ITEM_UOM | VARCHAR2 | (4) | Y | Uom of the item by which the inventory balances are maintained. |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
COST_CMPNTCLS_CODE | VARCHAR2 | (32) | Y | Cost component class |
COST_CMPNTCLS_DESC | VARCHAR2 | (240) | Y | Cost component class description |
SORT_SEQUENCE | NUMBER | (10) | Y | Sequence the component costs are sorted by on Cost details screen |
USAGE_IND | NUMBER | (5) | Y | Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment |
PRIMARY_CMPNTCLS_ID | NUMBER | (10) | Y | Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. |
PRODUCT_COST_IND | NUMBER | (5) | Y | This field indicates whether the component class will affect the cost of a product or not . Valid values are: 0 = Not a product cost, 1= Product Cost |
UPDATE_COST_IND | NUMBER | (5) | Y | This field indicates whether the component cost will be updated to the GL area. Valid values are 0= Do not update to GL Area, 1=Update to GL Area. |
CMPNT_GROUP | VARCHAR2 | (32) | Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group | |
PPV_IND | NUMBER | (5) | Y | Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations. |
FINAL_FLAG | NUMBER | (5) | Y | Indicates if Cost is frozen: 0 - not frozen, can be updated from CDA by running Cost Update process; 1 - Frozen, cannot be modified. |
END_DATE | DATE | Y | End effective date for the accounting cost. | |
START_DATE | DATE | Y | Start Effective date for accounting cost. | |
COST_TYPE | NUMBER | (5) | Y | Type of cost. 0=other; 1=std; 2=avg actual; 3=current. Not currently used. |
ACCTG_COST | NUMBER | Y | Item cost as seen by OPM programs, especially Susidiary Ledger Update process. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_ITEM_COST_FROM_GL_V is not referenced by any database object
A Business Intelligence System view
Costing information for an item rretrieved from costing tables. This is the OPM costing tables equivalent of the item_cost_from_GL view which retrieves data from the GL tables.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COST_LEVEL | NUMBER | (5) | Y | Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Actual Cost Process, 1= Costs via Ingredient calculated by Cost Rollup Process. |
COMPONENT_COST | NUMBER | Y | Component cost | |
BURDEN_INDICATOR | NUMBER | (5) | Y | Indicates if costs came from burdens 0=No 1=Yes |
ROLLOVER_INDICATOR | NUMBER | (5) | Y | Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated. |
TOTAL_QTY | NUMBER | Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs. | ||
COSTCALC_ORIG | NUMBER | (5) | Cost calculation origin for actual costs only; 0 = Actual Cost Calculation, 1 = Cost Development Process | |
RMCALC_TYPE | NUMBER | (5) | Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI | |
ROLLUP_REF_NO | NUMBER | (10) | Reference number of the Cost Rollup process that calculated this cost | |
FORMULA_EFF_ID | NUMBER | (10) | Effectivity used in determining Product(hence formula, routing - if any) during Cost Rollup Process | |
COMPONENT_COST_ID | NUMBER | (10) | Y | Surrogate ID for the Cost Component |
ITEM_ID | NUMBER | (10) | Surrogate for item for which the cost is specified | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse for which the cost is specified | |
WHSE_NAME | VARCHAR2 | (40) | Name of the warehouse. | |
CALENDAR_CODE | VARCHAR2 | (4) | Cost Calendar for which the cost is specified | |
CALENDAR_DESCRIPTION | VARCHAR2 | (40) | Costing Calendar description | |
PERIOD_CODE | VARCHAR2 | (4) | Costing Period for which the cost is specified | |
PERIOD_DESCRIPTION | VARCHAR2 | (40) | Cost Period Description | |
PERIOD_START_DATE | DATE | Cost Period Start Date | ||
PERIOD_END_DATE | DATE | Cost Period End Date | ||
COST_MTHD_CODE | VARCHAR2 | (4) | Cost Method for which the cost is specified | |
COST_CMPNTCLS_ID | NUMBER | (10) | Y | Surrogate for component class |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Y | Analysis code |
ITEM_NUMBER | VARCHAR2 | (32) | Y | Name of the item. |
ITEM_TYPE | NUMBER | Surrogate for item for which the cost is specified | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
ITEM_UOM | VARCHAR2 | (4) | Y | Uom of the item by which the inventory balances are maintained. |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
COST_CMPNTCLS_CODE | VARCHAR2 | (32) | Y | Cost component class |
COST_CMPNTCLS_DESC | VARCHAR2 | (240) | Y | Cost component class description |
SORT_SEQUENCE | NUMBER | (10) | Y | Sequence the component costs are sorted by on Cost details screen |
USAGE_IND | NUMBER | (5) | Y | Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment |
PRIMARY_COMPONENT_CLASS_ID | NUMBER | (10) | Y | Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with. Default is Primary Class. |
PRODUCT_COST_IND | NUMBER | (5) | Y | This field indicates whether the component class will affect the cost of a product or not. Valid values are: 0 = Not a product cost , 1 = Product Cost. |
UPDATE_COST_IND | NUMBER | (5) | Y | This field indicates whether the component cost will be updated to the GL area. Valid Values are 0 = Do not update to GL area, 1 = Update to GL Area. |
CMPNT_GROUP | VARCHAR2 | (32) | Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group | |
PPV_IND | NUMBER | (5) | Y | Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations. |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_ITEM_COST_V is not referenced by any database object
A Business Intelligence System view
Pricing information for an item broken down by quantity, warehouse, grade, customer, pricelist.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QC_GRADE | VARCHAR2 | (4) | QC grade to which these prices apply. Contains a NULL value to denote an "ALL" condition. Only applicable for grade-controlled items. | |
PRICE_UOM | VARCHAR2 | (4) | Y | Pricing uom |
BASE_PRICE | NUMBER | Y | Base price for the item/item class/whse/qc grade/frtbill_mthd/uom combination. May be zero. | |
FRIEGHT_BILL_MTHD | VARCHAR2 | (4) | Freight bill method to which these prices apply. Contains a NULL value to denote an "ALL" condition. | |
PRICEITEM_LINE_NO | NUMBER | (5) | Y | For use with future or custom pricing when fields, such as attribute columns, are used as part of the key, but are not part of the defined key. Default is zero. |
PRICE_TYPE | NUMBER | (5) | Y | Type of prices established as price breaks. Valid values are: 0 ,1,2 & 3 |
BREAK_TYPE | NUMBER | (5) | Y | Indicates the type of price breaks defined for this record. Valid values are: 0 = no price breaks defined, 1 = qty breakpoints defined, 2 = value breakpoints defined. |
PRICELIST_ID | NUMBER | (10) | Y | Pricelist to which these item prices belong. |
PRICE_CLASS | VARCHAR2 | (8) | Item price class. May be NULL when ITEM_ID has a valid value. | |
PRICE_ID | NUMBER | (10) | Y | Surrogate id to uniquely identify each row. |
ITEM_ID | NUMBER | (10) | Item to which these prices apply. Contains NULL value when PRICE_CLASS has a valid value. | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse code for which these prices apply. Contains a NULL value to denote an "ALL" condition. | |
WAREHOUSE_DESC | VARCHAR2 | (40) | Name of the warehouse. | |
ITEM_NUMBER | VARCHAR2 | (32) | Y | Name of the item. |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
ITEM_UOM | VARCHAR2 | (4) | Y | Uom of the item by which the inventory balances are maintained. |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
PRICELIST_CODE | VARCHAR2 | (32) | Y | Unique identifier for a pricelist. Name or code entered by user. |
PRICELIST_DESC1 | VARCHAR2 | (40) | Y | Description of price list. |
PRICESORT_NAME | VARCHAR2 | (20) | Y | Pricelist sort name. |
COMMENTS | VARCHAR2 | (80) | Freeform text/comments. | |
CURRENCY_CODE | VARCHAR2 | (4) | Y | Currency code for pricelist; FK to gl_curr_mst. |
PRICEBREAK_LINE_NO | NUMBER | (5) | Y | Part of primary key to distinguish between unique quantity and value breaks. |
QTY_BREAKPOINT | NUMBER | Quantity break for price. | ||
VALUE_BREAKPOINT | NUMBER | Value break for price (item qty * base price). | ||
BREAKPOINT_FACTOR | NUMBER | Percent which is applied to base price for this price detail to compute the unit price for the break value or qty. | ||
BREAKPOINT_PRICE | NUMBER | Unit price which applies for this break value/qty. | ||
BREAKTYPE_ID | NUMBER | (10) | Y | Surrogate id which uniquely identifies this row. |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_ITEM_PRICE_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | Product Item ID | ||
PRODUCT_LOT_ID | NUMBER | Y | Product Lot ID | |
INGREDIENT_ITEM_ID | NUMBER | Ingredient Item ID | ||
INGREDIENT_LOT_ID | NUMBER | Y | Ingredient Lot ID | |
PRODUCT_WAREHOUSE | VARCHAR2 | (4) | Y | Product Warehouse |
PRODUCT_LOCATION | VARCHAR2 | (16) | Y | Product Location |
PRODUCT_LOCATION_ONHAND | NUMBER | Y | Product Location Onhand | |
PRODUCT_LOCATION_ONHAND_UOM2 | NUMBER | Product Location Onhand UOM2 | ||
PRODUCT_LOT_STATUS | VARCHAR2 | (4) | Product Lot Status | |
INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Y | Ingredient Item Number |
INGREDIENT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Ingredient Item Description |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Y | Ingredient Item UOM |
INGREDIENT_ITEM_UOM2 | VARCHAR2 | (4) | Ingredient Item UOM2 | |
INGREDIENT_LOT_NO | VARCHAR2 | (32) | Y | Ingredient Lot Number |
INGREDIENT_SUBLOT_NO | VARCHAR2 | (32) | Ingredient Sublot Number | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Y | Product Item Number |
PRODUCT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Product Item Description |
PRODUCT_ITEM_UOM | VARCHAR2 | (4) | Y | Product Item UOM |
PRODUCT_ITEM_UOM2 | VARCHAR2 | (4) | Product Item UOM2 | |
PRODUCT_ITEM_INV_CLASS | VARCHAR2 | (8) | Product Item Inventory Class | |
PRODUCT_ITEM_PLAN_CLASS | VARCHAR2 | (8) | Product Item Planning Class | |
PRODUCT_ITEM_SALES_CLASS | VARCHAR2 | (8) | Product Item Sales Class | |
PRODUCT_LOT_NO | VARCHAR2 | (32) | Y | Product Lot Number |
PRODUCT_SUBLOT_NO | VARCHAR2 | (32) | Product Sublot Number |
APPS.PMIFV_LOT_DEST_ONHAND_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | Product Item ID | ||
PRODUCT_LOT_ID | NUMBER | Product Lot ID | ||
INGREDIENT_ITEM_ID | NUMBER | Ingredient Item ID | ||
INGREDIENT_LOT_ID | NUMBER | Ingredient Lot ID | ||
PRODUCT_WAREHOUSE | VARCHAR2 | (4) | Product Warehouse | |
PRODUCT_LOCATION | VARCHAR2 | (16) | Product Location | |
TRANSACTION_DATE | DATE | Transaction Date | ||
TRANSACTION_QUANTITY | NUMBER | Transacted Quantity in Primary UOM | ||
TRANSACTION_QUANTITY_UOM2 | NUMBER | Transacted Quantity in Secondary UOM | ||
ORGANIZATION_CODE | VARCHAR2 | (240) | Organization Code | |
ORDER_NO | VARCHAR2 | (40) | Sales Order Number | |
CUSTOMER_NO | VARCHAR2 | (4000) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Ingredient Item Number | |
INGREDIENT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Ingredient Item Description | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Ingredient Primary UOM | |
INGREDIENT_ITEM_UOM2 | VARCHAR2 | (4) | Ingredient Secondary UOM | |
INGREDIENT_LOT_NO | VARCHAR2 | (32) | Ingredient Lot Number | |
INGREDIENT_SUBLOT_NO | VARCHAR2 | (32) | Ingredient Sublot Number | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Product Item Number | |
PRODUCT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Product Item Description | |
PRODUCT_ITEM_UOM | VARCHAR2 | (4) | Product Primary UOM | |
PRODUCT_ITEM_UOM2 | VARCHAR2 | (4) | Product Secondary UOM | |
PRODUCT_ITEM_INV_CLASS | VARCHAR2 | (8) | Product Inventory Class | |
PRODUCT_ITEM_PLAN_CLASS | VARCHAR2 | (8) | Product Planing Class | |
PRODUCT_ITEM_SALES_CLASS | VARCHAR2 | (8) | Product Sales Class | |
PRODUCT_LOT_NO | VARCHAR2 | (32) | Product Lot Number | |
PRODUCT_SUBLOT_NO | VARCHAR2 | (32) | Product Sublot Number | |
TRANSACTION_COMPLETE_INDICATOR | NUMBER | (5) |
APPS.PMIFV_LOT_DEST_SHIP_V is not referenced by any database object
A Business Intelligence System view
This view is used to access inventory events involving each lot, covering pending
and completed transactions from IC_TRAN_PND and IC_TRAN_CMP. Transaction quantities
are summed at a logical transaction level.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | ||
LOT_ID | NUMBER | (10) | ||
TRANSACTION_DATE | DATE | |||
ORGANIZATION_CODE | VARCHAR2 | (4) | ||
DOCUMENT_TYPE | VARCHAR2 | (4) | ||
DOCUMENT_ID | NUMBER | (10) | ||
LINE_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | ||
ITEM_UOM | VARCHAR2 | (4) | ||
ITEM_UOM2 | VARCHAR2 | (4) | ||
LOT_NO | VARCHAR2 | (32) | ||
SUBLOT_NO | VARCHAR2 | (32) | ||
TRANSACTION_QUANTITY | NUMBER | |||
TRANSACTION_QUANTITY_UOM2 | NUMBER | |||
WAREHOUSE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
QC_GRADE | VARCHAR2 | (4) | ||
LOT_STATUS | VARCHAR2 | (4) | ||
REASON_CODE | VARCHAR2 | (4) | ||
TRANSACTION_COMPLETE_INDICATOR | NUMBER |
APPS.PMIFV_LOT_EVENT_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NO | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
ITEM_ID | NUMBER | (10) | Item ID | |
INVENTORY_CLASS | VARCHAR2 | (8) | Inventory Class | |
INVENTORY_TYPE | VARCHAR2 | (4) | Inventory Type | |
LOT_ID | NUMBER | (10) | Lot ID | |
LOT_NO | VARCHAR2 | (32) | Lot Number | |
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
LOT_CREATION_DATE | DATE | Lot Creation Date | ||
QC_GRADE | VARCHAR2 | (4) | Quality Control Grade | |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization Code | |
ORGANIZATION_NAME | VARCHAR2 | (40) | Organization Name | |
VENDOR_NO | VARCHAR2 | (154) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
VENDOR_ID | NUMBER | Vendor ID | ||
BATCH_NO | VARCHAR2 | (32) | Batch Number | |
FORMULA_NO | CHAR | (1) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
ROUTING_NO | CHAR | (1) | Routing Number | |
ROUTING_VERSION | NUMBER | Routing Version | ||
RECIEPT_NO | VARCHAR2 | (32) | PO Rceipt Number |
APPS.PMIFV_LOT_LIST_V is not referenced by any database object
A Business Intelligence System view
This view lists lots that shared a particular set of parameters, most importantly
the resources used in the lots' manufacture. This is used to identify defective lots
caused by defective resources.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NO | VARCHAR2 | (32) | Y | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | |
ITEM_ID | NUMBER | (10) | Y | |
INVENTORY_CLASS | VARCHAR2 | (8) | ||
INVENTORY_TYPE | VARCHAR2 | (4) | ||
LOT_ID | NUMBER | (10) | Y | |
LOT_NO | VARCHAR2 | (32) | Y | |
SUBLOT_NO | VARCHAR2 | (32) | ||
LOT_CREATION_DATE | DATE | Y | ||
QC_GRADE | VARCHAR2 | (4) | ||
ORGANIZATION_CODE | VARCHAR2 | (4) | Y | |
ORGANIZATION_NAME | VARCHAR2 | (40) | Y | |
VENDOR_NO | VARCHAR2 | (32) | ||
VENDOR_NAME | VARCHAR2 | (40) | ||
VENDOR_ID | NUMBER | (10) | ||
RESOURCES | VARCHAR2 | (16) | Y |
APPS.PMIFV_LOT_RESOURCE_LIST_V is not referenced by any database object
A Business Intelligence System view
This view lists the onhand balances of all product lots which share ingredient lots
with another product lot. This ingredient lots may be any number of levels removed
from the start-lot or on-hand lot.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
START_ITEM_ID | NUMBER | |||
START_LOT_ID | NUMBER | Y | ||
SHARED_ITEM_ID | NUMBER | |||
SHARED_LOT_ID | NUMBER | Y | ||
START_ITEM_NO | VARCHAR2 | (32) | Y | |
START_ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | |
START_LOT_NO | VARCHAR2 | (32) | Y | |
START_SUBLOT_NO | VARCHAR2 | (32) | ||
SHARED_ITEM_NO | VARCHAR2 | (32) | Y | |
SHARED_ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | |
SHARED_ITEM_UOM | VARCHAR2 | (4) | Y | |
SHARED_ITEM_UOM2 | VARCHAR2 | (4) | ||
SHARED_INVENTORY_CLASS | VARCHAR2 | (8) | ||
SHARED_PLANNING_CLASS | VARCHAR2 | (8) | ||
SHARED_SALES_CLASS | VARCHAR2 | (8) | ||
SHARED_LOT_NO | VARCHAR2 | (32) | Y | |
SHARED_SUBLOT_NO | VARCHAR2 | (32) | ||
SHARED_ONHAND | NUMBER | Y | ||
SHARED_ONHAND_UOM2 | NUMBER | |||
SHARED_WAREHOUSE | VARCHAR2 | (4) | Y | |
SHARED_LOCATION | VARCHAR2 | (16) | Y |
APPS.PMIFV_LOT_SHARED_ONHAND_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
START_ITEM_ID | NUMBER | Start Item ID to find Shared Lots | ||
START_LOT_ID | NUMBER | Start Lot ID to find Shared Lots | ||
SHARED_ITEM_ID | NUMBER | Shared Item ID which uses same Item,lots as start Item, Lots | ||
SHARED_LOT_ID | NUMBER | Shared Lot ID which uses same Item,lots as start Item, Lots | ||
START_ITEM_NO | VARCHAR2 | (32) | Start Item Number to find Shared Lots | |
START_ITEM_DESCRIPTION | VARCHAR2 | (70) | Start Item Description to find Shared Lots | |
START_LOT_NO | VARCHAR2 | (32) | Start Lot Number to find Shared Lots | |
START_SUBLOT_NO | VARCHAR2 | (32) | Start Sublot Number to find Shared Lots | |
SHARED_ITEM_NO | VARCHAR2 | (32) | Shared Item Number which uses same Item,lots as start Item, Lots | |
SHARED_ITEM_DESCRIPTION | VARCHAR2 | (70) | Shared Item Description which uses same Item,lots as start Item, Lots | |
SHARED_ITEM_UOM | VARCHAR2 | (4) | Shared Item Primary UOM | |
SHARED_ITEM_UOM2 | VARCHAR2 | (4) | Shared Item Secondary UOM | |
SHARED_INVENTORY_CLASS | VARCHAR2 | (8) | Shared Item Inventory Class | |
SHARED_PLANNING_CLASS | VARCHAR2 | (8) | Shared Item Planning Class | |
SHARED_SALES_CLASS | VARCHAR2 | (8) | Shared Item Sales Class | |
SHARED_LOT_NO | VARCHAR2 | (32) | Shared Lot Number | |
SHARED_SUBLOT_NO | VARCHAR2 | (32) | Shared sublot Number | |
ORGANIZATION_CODE | VARCHAR2 | (240) | Organization Code for OM it is Operating Unit name | |
WAREHOUSE | VARCHAR2 | (4) | Warehouse | |
LOCATION | VARCHAR2 | (16) | Location | |
ORDER_NO | VARCHAR2 | (40) | Sales Order Number | |
CUSTOMER_NO | VARCHAR2 | (4000) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
SHIP_DATE | DATE | Ship date | ||
SHIPPED_QUANTITY | NUMBER | Shipped Quantity in Primary UOM | ||
SHIPPED_QUANTITY_UOM2 | NUMBER | Shipped Quantity in Secondary UOM | ||
TRANSACTION_COMPLETE_INDICATOR | NUMBER | (5) | Completed Indicator |
APPS.PMIFV_LOT_SHARED_SHIP_V is not referenced by any database object
A Business Intelligence System view
This view lists the onhand balances of all lot sources (ingredient lots) of a
product lot. The product lots on-hand balances are included, allowing for ALL
source quantities to be evaluated.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | |||
PRODUCT_LOT_ID | NUMBER | Y | ||
INGREDIENT_ITEM_ID | NUMBER | |||
INGREDIENT_LOT_ID | NUMBER | Y | ||
INGREDIENT_WAREHOUSE | VARCHAR2 | (4) | Y | |
INGREDIENT_LOCATION | VARCHAR2 | (16) | Y | |
INGREDIENT_LOCATION_ONHAND | NUMBER | Y | ||
INGREDIENT_LOC_ONHAND_UOM2 | NUMBER | |||
INGREDIENT_LOT_STATUS | VARCHAR2 | (4) | ||
INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Y | |
INGREDIENT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Y | |
INGREDIENT_ITEM_UOM2 | VARCHAR2 | (4) | ||
INGREDIENT_ITEM_INV_CLASS | VARCHAR2 | (8) | ||
INGREDIENT_ITEM_PLAN_CLASS | VARCHAR2 | (8) | ||
INGREDIENT_ITEM_SALES_CLASS | VARCHAR2 | (8) | ||
INGREDIENT_LOT_NO | VARCHAR2 | (32) | Y | |
INGREDIENT_SUBLOT_NO | VARCHAR2 | (32) | ||
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Y | |
PRODUCT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | |
PRODUCT_ITEM_UOM | VARCHAR2 | (4) | Y | |
PRODUCT_ITEM_UOM2 | VARCHAR2 | (4) | ||
PRODUCT_LOT_NO | VARCHAR2 | (32) | Y | |
PRODUCT_SUBLOT_NO | VARCHAR2 | (32) |
APPS.PMIFV_LOT_SOURCE_ONHAND_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | Product Item ID | ||
PRODUCT_LOT_ID | NUMBER | Product Lot ID | ||
INGREDIENT_ITEM_ID | NUMBER | Ingredient Item ID | ||
INGREDIENT_LOT_ID | NUMBER | Ingredient Lot ID | ||
PRODUCT_WAREHOUSE | VARCHAR2 | (4) | Product Warehouse | |
PRODUCT_LOCATION | VARCHAR2 | (16) | Product Location | |
TRANSACTION_DATE | DATE | Transaction Date | ||
TRANSACTION_QUANTITY | NUMBER | Transaction Quantity | ||
TRANSACTION_QUANTITY_UOM2 | NUMBER | Transaction Quantity UOM2 | ||
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization Code | |
RECEIPT_NO | VARCHAR2 | (32) | Receipt Number | |
PURCHASE_ORDER_NO | VARCHAR2 | (32) | Purchase Order Number | |
VENDOR_NO | VARCHAR2 | (154) | Vender Number | |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Ingredient Item Number | |
INGREDIENT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Ingredient Item Description | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Ingredient Item UOM | |
INGREDIENT_ITEM_UOM2 | VARCHAR2 | (4) | Ingredient Item UOM2 | |
INGREDIENT_ITEM_INV_CLASS | VARCHAR2 | (8) | Ingredient Item Inventory Class | |
INGREDIENT_ITEM_PLAN_CLASS | VARCHAR2 | (8) | Ingredient Item Planning Class | |
INGREDIENT_ITEM_SALES_CLASS | VARCHAR2 | (8) | Ingredient Item Sales Class | |
INGREDIENT_LOT_NO | VARCHAR2 | (32) | Ingredient Lot Number | |
INGREDIENT_SUBLOT_NO | VARCHAR2 | (32) | Ingredient Sublot Number | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Product Item Number | |
PRODUCT_ITEM_DESCRIPTION | VARCHAR2 | (70) | Product Item Description | |
PRODUCT_ITEM_UOM | VARCHAR2 | (4) | Product Item UOM | |
PRODUCT_ITEM_UOM2 | VARCHAR2 | (4) | Product Item UOM2 | |
PRODUCT_LOT_NO | VARCHAR2 | (32) | Product Lot Number | |
PRODUCT_SUBLOT_NO | VARCHAR2 | (32) | Product Sublot Number |
APPS.PMIFV_LOT_SOURCE_PURCH_V is not referenced by any database object
A Business Intelligence System view
Process Manufacturing Organizations
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization code. |
ORGN_NAME | VARCHAR2 | (40) | Y | Organization name. |
PLANT_IND | NUMBER | (5) | Y | 0=no the organization is not a plant; 1=yes the organization is a plant. |
TAXLOC_CODE | VARCHAR2 | (10) | Tax Location Code for this organization (FK to TX_TLOC_CDS) | |
POC_IND | NUMBER | (5) | 0=Do not generate POC transactions for organization; 1=Generate POC transactions for organization | |
PARENT_ORGN_CODE | VARCHAR2 | (4) | Y | Orgn to which orgn_code reports. Must already exist in the table. |
CO_CODE | VARCHAR2 | (4) | Y | Company code of the organization. |
ADDR_ID | NUMBER | (10) | Surrogate of the organization address. | |
ORGANIZATION_ID | NUMBER | (15) | Foreign reference to HR_ORGANIZATION_UNITS | |
PARENT_ORGN_NAME | VARCHAR2 | (40) | Y | Organization name. |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_ORGANIZATION_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QTY_ONHAND | NUMBER | Period ending balance of lot/item in secondary UOM of an item, for dual UOM items. | ||
QTY_ONHAND_IN_UM2 | NUMBER | Period ending balance of lot/item in primary UOM of an item. | ||
QTY_USED | NUMBER | Consumption of the item in production during the period, in the primary inventory UOM of an item. | ||
QTY_USED_IN_UM2 | NUMBER | Consumption of the item in production during the period, in the secondary inventory UOM of an item, for dual UOM items. | ||
YIELD | NUMBER | Yield of the item from production during the period, in the primary inventory UOM of an item. | ||
YIELD_IN_UM2 | NUMBER | Yield of the item from production during the period, in the secondary inventory UOM of an item, for dual UOM items. | ||
VALUE | NUMBER | Value of loct_usage. Equals loct_usage*accounting cost. | ||
LAST_PERIOD_CLOSE_DATE | DATE | Last time Inventory Close was run. | ||
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse which contains the item balances. | |
LOT_ID | NUMBER | (10) | Surrogate key for the lot/sublot. 0 identifies the default lot. LOT_ID is set to '0' for items without lot control. | |
LOCATION | VARCHAR2 | (16) | Location in the warehouse, if any, which contains the balance. | |
ITEM_ID | NUMBER | (10) | Surrogate key for the item. | |
LOT_STATUS | VARCHAR2 | (4) | Status of the lot. | |
QC_HOLD_REASON_CODE | VARCHAR2 | (4) | Reason code associated with the lot status. | |
PERIOD_ID | NUMBER | (10) | Surrogate key of the period. | |
FISCAL_YEAR | VARCHAR2 | (4) | Name of the inventory calendar. | |
CALENDER_DESCRIPTION | VARCHAR2 | (40) | Cost Calendar Description | |
PERIOD_DESCRIPTION | VARCHAR2 | (40) | Cost Period Description | |
PERIOD | NUMBER | (5) | Inventory period for which the balance is stored. | |
ITEM_NUMBER | VARCHAR2 | (32) | Name of the item. | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Short description of the item that is displayed during the item look up. | |
ITEM_UOM | VARCHAR2 | (4) | Uom of the item by which the inventory balances are maintained. | |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
LOT_NUMBER | VARCHAR2 | (32) | Code for the lot. | |
SUBLOT_NUMBER | VARCHAR2 | (32) | Code for the sublot. | |
QC_GRADE | VARCHAR2 | (4) | QC grade of the lot. | |
LOT_EXPIRE_DATE | DATE | Lot expiration date. | ||
LOT_CREATION_DATE | DATE | Standard who column | ||
VENDOR_LOT_NUMBER | VARCHAR2 | (32) | Vendor lot number. | |
WAREHOUSE_NAME | VARCHAR2 | (40) | Name of the warehouse. | |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization that owns the warehouse. | |
CO_CODE | VARCHAR2 | (4) | Company code of the organization. | |
LOCATION_DESCRIPTION | VARCHAR2 | (40) | Description of the location. | |
LOCATION_CAPACITY | NUMBER | Capacity of the location. | ||
CAPACITY_UM | VARCHAR2 | (4) | Unit of measure in which the capacity is expressed. | |
STATUS_DESCRIPTION | VARCHAR2 | (40) | Description of status. | |
QCHOLD_REASON_DESCRIPTION | VARCHAR2 | (80) | Description of the QC hold reason. | |
PERIOD_START_DATE | DATE | Cost Period Start Date | ||
PERIOD_END_DATE | DATE | Cost Period End Date | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
PERIOD_STATUS | NUMBER | '0=frozen', 1= open' | ||
PERIOD_STATUS_MEANING | VARCHAR2 | (10) | meaning of period status column |
APPS.PMIFV_PERIODINVENTORY_V is not referenced by any database object
A Business Intelligence System view
Formula detail with Onhanad inventory of the Ingredients
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_NO | VARCHAR2 | (32) | Y | Alphanumeric formula name or number. |
FORMULA_VERSION | NUMBER | Y | Formula version. | |
FORMULA_TYPE | NUMBER | (5) | Y | 0=std formula; 1=packaged item formula (these are not currently used). |
FORMULA_TYPE_MEANING | VARCHAR2 | (80) | 0=std formula; 1=packaged item formula (these are not currently used). | |
SCALE_TYPE | NUMBER | (5) | Y | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
FORMULA_ID | NUMBER | (10) | Y | Surrogate for formula_no + formula_vers. |
PRODUCT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
INGREDIENT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
INGREDIENT_FORMULALINE_ID | NUMBER | (10) | Y | Surrogate key for the formula line. |
INGREDIENT_LINE_NO | NUMBER | (5) | Y | List order on screen within a line_type. |
INGREDIENT_QTY | NUMBER | Y | Item qty produced or consumed. | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Uom of qty. | |
INGREDIENT_RELEASE_TYPE | NUMBER | (5) | Y | 0=automatic release; 1=partial release. |
INGREDIENT_SCRAP_FACTOR | NUMBER | Y | Scrap factor decimal used to calculate required qty. | |
INGREDIENT_SCALE_TYPE | NUMBER | (5) | Y | 0=fixed, no scaling; 1=proportional scaling. |
COST_ALLOCATION | NUMBER | If product, fractional cost absorption. | ||
PHANTOM_TYPE | NUMBER | (5) | Y | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. |
REWORK_TYPE | NUMBER | (5) | Y | Not currently used. |
PRODUCT_QTY | NUMBER | Item qty produced or consumed. | ||
PRODUCT_UOM | VARCHAR2 | (4) | Uom of qty. | |
INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Y | Name of the item. |
INGREDIENT_DESC1 | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
INGREDIENT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Y | Name of the item. |
PRODUCT_DESC1 | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
PRODUCT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
INGREDIENT_WHSE_CODE | VARCHAR2 | (4) | Warehouse in which the inventory is located. | |
INGREDIENT_ONHAND_QTY | NUMBER | Total qty available for use as a production ingredient, expressed in the primary UOM of an item. | ||
PRODUCT_PRIMARY_UOM | VARCHAR2 | (4) | Y | Product Primary UM |
INGREDIENT_PRIMARY_UOM | VARCHAR2 | (4) | Y | Ingredient Primary UM |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_PRODUCTFORMULA_INV_V is not referenced by any database object
A Business Intelligence System view
The product and ingredient info for a formula. This does not contain info on effectivity,routing or coproducts.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_NO | VARCHAR2 | (32) | Y | Alphanumeric formula name or number. |
FORMULA_VERSION | NUMBER | Y | Formula version. | |
FORMULA_TYPE | NUMBER | (5) | Y | 0=std formula; 1=packaged item formula (these are not currently used). |
FORMULA_TYPE_MEANING | VARCHAR2 | (80) | 0=std formula; 1=packaged item formula (these are not currently used). | |
SCALE_TYPE | NUMBER | (5) | Y | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (240) | Y | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
FORMULA_ID | NUMBER | (10) | Y | Surrogate for formula_no + formula_vers. |
PRODUCT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
INGREDIENT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
INGREDIENT_FORMULALINE_ID | NUMBER | (10) | Y | Surrogate key for the formula line. |
INGREDIENT_LINE_NO | NUMBER | (5) | Y | List order on screen within a line_type. |
INGREDIENT_QTY | NUMBER | Y | Item qty produced or consumed. | |
INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Uom of qty. | |
INGREDIENT_RELEASE_TYPE | NUMBER | (5) | Y | 0=automatic release; 1=partial release. |
INGREDIENT_SCRAP_FACTOR | NUMBER | Y | Scrap factor decimal used to calculate required qty. | |
INGREDIENT_SCALE_TYPE | NUMBER | (5) | Y | 0=fixed, no scaling; 1=proportional scaling. |
COST_ALLOCATION | NUMBER | If product, fractional cost absorption. | ||
PHANTOM_TYPE | NUMBER | (5) | Y | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. |
REWORK_TYPE | NUMBER | (5) | Y | Not currently used. |
PRODUCT_QTY | NUMBER | Item qty produced or consumed. | ||
PRODUCT_UOM | VARCHAR2 | (4) | Uom of qty. | |
INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Y | Name of the item. |
INGREDIENT_DESC1 | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
INGREDIENT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
PRODUCT_ITEM_NO | VARCHAR2 | (32) | Y | Name of the item. |
PRODUCT_DESC1 | VARCHAR2 | (70) | Y | Short description of the item that is displayed during the item look up. |
PRODUCT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_PRODUCTFORMULA_V is not referenced by any database object
A Business Intelligence System view
Batch Efficiency
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANT_CODE | VARCHAR2 | (4) | ||
COMPANY_CODE | VARCHAR2 | (4) | Y | |
WHSE_CODE | VARCHAR2 | (4) | ||
BATCH_ID | NUMBER | (10) | Y | |
BATCH_NO | VARCHAR2 | (32) | Y | |
ITEM_ID | NUMBER | (10) | ||
ITEM_NO | VARCHAR2 | (32) | Y | |
ITEM_DESC | VARCHAR2 | (70) | Y | |
PLANNING_CLASS | VARCHAR2 | (8) | ||
INVENTORY_CLASS | VARCHAR2 | (8) | ||
SALES_CLASS | VARCHAR2 | (8) | ||
FISCAL_YEAR | NUMBER | (15) | Y | |
PERIOD_CODE | NUMBER | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
ACTUAL_YIELD_QTY | NUMBER | |||
STD_QTY | NUMBER | Y | ||
STD_TIME | NUMBER | |||
PLAN_YIELD_VALUE | NUMBER | |||
ACTUAL_YIELD_VALUE | NUMBER |
APPS.PMIFV_PROD_EFFI_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESULT_DATE | DATE | Result posted date | ||
RESULT | VARCHAR2 | (80) | Result | |
RESULTS_QCUNIT_CODE | VARCHAR2 | (25) | Result Quality Control Unit Code | |
ACCEPT | VARCHAR2 | (1) | Accept | |
FINAL_MARK | VARCHAR2 | (1) | Final Mark | |
TEST_PROVIDER_CODE | VARCHAR2 | (8) | Test Provider Code | |
ASSAY_TESTER | VARCHAR2 | (30) | Assay Tester | |
WF_RESPONSE | VARCHAR2 | (1) | Workflow Response | |
ASSAY_RETEST_FLAG | NUMBER | (8) | Retest Flag | |
QCASSY_TYP_ID | NUMBER | Assay Type ID | ||
QC_RESULT_ID | NUMBER | Result ID | ||
QC_SPEC_ID | NUMBER | Spec ID | ||
ORGN_CODE | VARCHAR2 | (4) | Organization Code | |
SAMPLE_ID | NUMBER | Sample ID | ||
SAMPLE_NO | VARCHAR2 | (80) | Sample Number | |
SAMPLE_DESC | VARCHAR2 | (80) | Sample Description | |
SAMPLE_STATUS | VARCHAR2 | (30) | Sample Status | |
SAMPLE_STATUS_MEANING | VARCHAR2 | (80) | Sample Status meaning | |
ASSAY_CODE | VARCHAR2 | (80) | Assay Code | |
ASSAY_DESC | VARCHAR2 | (240) | Assay Description | |
ITEM_ID | NUMBER | Item ID | ||
LOT_ID | NUMBER | Lot ID | ||
WHSE_CODE | VARCHAR2 | (4) | Warehouse | |
LOCATION | VARCHAR2 | (16) | Location | |
FORMULA_ID | NUMBER | Formula ID | ||
FORMULALINE_ID | NUMBER | Formula Line ID | ||
ROUTING_ID | NUMBER | Routing ID | ||
ROUTINGSTEP_ID | NUMBER | Routing Step ID | ||
OPRN_ID | NUMBER | Operation ID | ||
CUST_ID | NUMBER | Customer ID | ||
SHIP_TO_SITE_ID | NUMBER | |||
VENDOR_ID | NUMBER | Vendor ID | ||
BATCH_ID | NUMBER | Batch ID | ||
ROUTINGSTEP_NO | NUMBER | Routing Step Number | ||
ITEM_NUMBER | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
ITEM_UOM | VARCHAR2 | (4) | Primary UOM | |
ITEM_UOM2 | VARCHAR2 | (4) | Secondary UOM | |
DOC_TYPE | VARCHAR2 | (0) | Document Type | |
DOC_ID | VARCHAR2 | (0) | Document ID | |
DOCLINE_ID | VARCHAR2 | (0) | Document Line ID | |
CUST_SPECIFICATION | VARCHAR2 | (0) | Customer Specification | |
CUST_CERTIFICATION | VARCHAR2 | (0) | Customer Certification | |
VENDOR_SPECIFICATION | VARCHAR2 | (0) | Vendor Specification | |
VENDOR_CERTIFICATION | VARCHAR2 | (0) | Vendor Certification | |
TEXT_SPEC | VARCHAR2 | (16) | Text Spec | |
TARGET_SPEC | VARCHAR2 | (40) | Target Spec | |
MIN_SPEC | VARCHAR2 | (40) | Min Spec | |
MAX_SPEC | VARCHAR2 | (40) | Max Spec | |
SPEC_QCUNIT_CODE | VARCHAR2 | (25) | Spec Quality Control Unit Code | |
FROM_DATE | DATE | From Date | ||
TO_DATE | DATE | To Date | ||
OUTACTION_CODE | VARCHAR2 | (32) | Out Of Action Code | |
OUTACTION_INTERVAL | NUMBER | Out Of Action Interval | ||
PREFERENCE | VARCHAR2 | (0) | Preference | |
PRINT_COA_SHIPPED | VARCHAR2 | (1) | To Indentify whether Certificate of Analysis need to be sent with shipment Flag | |
PRINT_COA_INVOICED | VARCHAR2 | (1) | Print Certificate of Analysis Flag | |
VENDOR_COA_REQUIRED | VARCHAR2 | (1) | Vendor Certificate of Analysis Required Flag | |
TEST_OPRN_ID | NUMBER | Test Operation ID | ||
TEST_OPRN_LINE_ID | NUMBER | Test Operation Line ID | ||
CUSTOMER_NO | VARCHAR2 | (30) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
VENDOR_NO | VARCHAR2 | (32) | VEndor Number | |
VENDOR_NAME | VARCHAR2 | (40) | Vendor Name | |
ACCEPT_ANYWAY | VARCHAR2 | (1) | Accept Anyway | |
LOT_NO | VARCHAR2 | (32) | Lot Number | |
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
CREATED_BY | NUMBER | (15) | ROW WHO Column | |
CREATION_DATE | DATE | ROW WHO Column | ||
LAST_UPDATE_DATE | DATE | ROW WHO Column | ||
LAST_UPDATED_BY | NUMBER | (15) | ROW WHO Column |
APPS.PMIFV_QCRESULT_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_CODE | VARCHAR2 | (80) | OPM Organization Code | |
ASSAY_CODE | VARCHAR2 | (16) | Y | QC Assay Code |
ASSAY_DESCRIPTION | VARCHAR2 | (40) | Y | QC Assay Description |
ASSAY_TYPE | NUMBER | (5) | Y | Assay Type |
MIN_VALUE | NUMBER | MIN Value for numeric Assays | ||
MAX_VALUE | NUMBER | MAX Value for numeric Assays | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Y | Quality Control Unit Code |
DELETE_MARK | NUMBER | (5) | Y | Delete Mark |
LAST_UPDATED_DATE | DATE | Y | ROW WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | ROW WHO Column |
CREATION_DATE | DATE | Y | ROW WHO Column | |
CREATED_BY | NUMBER | (15) | Y | ROW WHO Column |
VALUE | VARCHAR2 | (40) | Assay Character Value |
APPS.PMIFV_QC_ASSAYS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSAY_CODE | VARCHAR2 | (16) | Y | QC Assay Code |
NUM_RESULT | NUMBER | Numeric Result | ||
TEXT_RESULT | VARCHAR2 | (16) | Text Result | |
FINAL_MARK | NUMBER | (5) | Y | Final Mark |
ACCEPT_ANYWAY | NUMBER | (5) | Y | Accept Anyway |
MIN_SPEC | NUMBER | MIN Value for numeric Assays | ||
MAX_SPEC | NUMBER | MAX Value for numeric Assays | ||
TEXT_SPEC | VARCHAR2 | (16) | Text Specification | |
TARGET_SPEC | NUMBER | Target Specification | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Y | Quality Control Unit Code |
SAMPLE_ID | NUMBER | (10) | Y | Sample ID |
APPS.PMIFV_QC_MATCH_DTL_V is not referenced by any database object
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_NUMBER | VARCHAR2 | (30) | Y | |
CUSTOMER_NAME | VARCHAR2 | (360) | Y | |
ITEM_NUMBER | VARCHAR2 | (32) | Y | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Y | |
LOCATION | VARCHAR2 | (16) | Y | |
LOT_NUMBER | VARCHAR2 | (32) | Y | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | ||
LOCATION_ONHAND | NUMBER | Y | ||
ITEM_UOM | VARCHAR2 | (4) | Y | |
LOT_STATUS | VARCHAR2 | (4) | ||
EXPIRE_DATE | DATE | |||
SAMPLE_ID | NUMBER | (10) | Y | |
USE | VARCHAR2 | (80) | Y |
APPS.PMIFV_QC_MATCH_HDR_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUALITY_CONTROL_SPEC_ID | NUMBER | (10) | Quality Control Spec ID | |
ASSAY_TYPE_ID | NUMBER | (15) | Assay Type ID | |
ORGANIZATION_CODE | VARCHAR2 | (4) | OPM Organization Code | |
WAREHOUSE_CODE | VARCHAR2 | (4) | OPM Warehouse Code | |
LOCATION | VARCHAR2 | (16) | Location | |
DOCUMENT_TYPE | VARCHAR2 | (4) | Document Type | |
VENDOR_SPECIFICATION | NUMBER | (5) | Vendor Specification | |
VENDOR_CERTIFICATION | NUMBER | (5) | Vendor Certification | |
CUSTOMER_SPECIFICATION | NUMBER | (5) | Customer Specification | |
CUSTOMER_CERTIFICATION | NUMBER | (5) | Customer Certification | |
ASSAY_CODE | VARCHAR2 | (16) | Assay Code | |
TEXT_SPEC | VARCHAR2 | (16) | Text Spec | |
MIN_SPEC | NUMBER | MIN Spec | ||
MAX_SPEC | NUMBER | MAX Spec | ||
TARGET_SPEC | NUMBER | Target Spec | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Quality Control Unit Code | |
FROM_DATE | DATE | From Date | ||
TO_DATE | DATE | To Date | ||
OUT_OF_ACTION_CODE | VARCHAR2 | (4) | Out Of Action Code | |
OUT_OF_ACTION_INTERVAL | NUMBER | Out Of Action Interval | ||
PREFERENCE | NUMBER | (5) | Preference | |
PRINT_COA_SHIPPED | NUMBER | (5) | Print COA Shipped | |
PRINT_COA_INVOICED | NUMBER | (5) | Print COA Invoiced | |
VENDOR_COA_REQUIRED | NUMBER | (5) | Vendor COA Required | |
DELETE_MARK | NUMBER | (5) | Delete Mark is used mark record for logical deletion | |
ROUTING_STEP_NUMBER | NUMBER | (5) | Routing Step Number | |
CUSTOMER_NUMBER | CHAR | (1) | Customer Number | |
CUSTOMER_NAME | CHAR | (1) | Customer Name | |
ITEM_NUMBER | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
VENDOR_ID | NUMBER | Vendor ID | ||
VENDOR_NUMBER | CHAR | (1) | Vendor Number | |
VENDOR_NAME | CHAR | (1) | Vendor Name | |
FORMULA_ID | NUMBER | (10) | Formula Id | |
FORMULA_NUMBER | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | Sub Lot Number | |
BATCH_NUMBER | VARCHAR2 | (32) | Batch Number | |
ROUTING_ID | NUMBER | (10) | Routing Id | |
ROUTING_NUMBER | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERSION | NUMBER | (5) | Routing Version | |
OPERATION_ID | NUMBER | (10) | Operation Id | |
OPERATION_NUMBER | VARCHAR2 | (16) | Operation Number | |
OPERATION_VERSION | NUMBER | (5) | Operation Version | |
EFFECTIVE | VARCHAR2 | (80) | Effective |
APPS.PMIFV_QC_PRODUCTION_SPEC_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_CODE | VARCHAR2 | (4) | OPM Organization Code | |
WAREHOUSE_CODE | VARCHAR2 | (4) | OPM Warehouse Code | |
DOCUMENT_TYPE | VARCHAR2 | (4) | Document Type | |
RESULT_DATE | DATE | Result Date | ||
TEXT_RESULT | VARCHAR2 | (16) | Text Result | |
NUM_RESULT | NUMBER | Numeric Result | ||
ACCEPT_ANYWAY | VARCHAR2 | (80) | Accept Anyway | |
FINAL_MARK | VARCHAR2 | (80) | Final Mark | |
TEST_PROVIDER_CODE | VARCHAR2 | (8) | Test Provider | |
LOCATION | VARCHAR2 | (16) | Location | |
DELETE_MARK | NUMBER | (5) | Delete mark used for logical deletion in OPM | |
LAST_UPDATE_DATE | DATE | ROW WHO Column | ||
VENDOR_SPECIFICATION | NUMBER | Vendor Specification | ||
CUSTOMER_SPECIFICATION | NUMBER | Customer Specification | ||
ASSAY_CODE | VARCHAR2 | (16) | Assay Code | |
TEXT_SPEC | VARCHAR2 | (16) | Text Spec | |
MIN_SPEC | NUMBER | MIN value allowed for Spec | ||
MAX_SPEC | NUMBER | MAX value allowed for Spec | ||
TARGET_SPEC | NUMBER | Target Sepc | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Quality Control Unit Code | |
FROM_DATE | DATE | From Date | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
VENDOR_NO | VARCHAR2 | (32) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (40) | Vendor Name | |
QUALITY_CONTROL_SPEC_ID | NUMBER | Quality Control Specification ID | ||
ITEM_NUMBER | VARCHAR2 | (32) | Item number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | Sub Lot Number | |
SAMPLE_NUMBER | VARCHAR2 | (32) | Sample Number | |
BATCH_NUMBER | VARCHAR2 | (32) | Production Batch Number | |
FORMULA_NUMBER | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
ROUTING_NUMBER | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERSION | NUMBER | (5) | Routing Version | |
OPERATION_NUMBER | VARCHAR2 | (16) | Operation Number | |
OPERATION_VERSION | NUMBER | (5) | Operation Version | |
ROUTING_STEP_NUMBER | NUMBER | (5) | Routing Step Number | |
CUSTOMER_ID | NUMBER | (15) | Customer ID | |
SHIP_TO_SITE_ID | NUMBER | Ship to Site ID |
APPS.PMIFV_QC_RESULTS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SAMPLE_ID | NUMBER | (10) | Y | Surrogate ID to QC Samples |
ORGANIZATION_CODE | VARCHAR2 | (4) | Y | OPM Organization Code |
SAMPLE_NO | VARCHAR2 | (32) | Y | Sample Number |
SAMPLE_DESCRIPTION | VARCHAR2 | (70) | Sample Description | |
WAREHOUSE_CODE | VARCHAR2 | (4) | OPM Warehouse Code | |
LOCATION | VARCHAR2 | (16) | Location | |
SAMPLE_DATE | DATE | Y | Sample Date | |
SAMPLED_BY | VARCHAR2 | (100) | Y | Sampled By |
SAMPLE_QTY | NUMBER | Y | Quantity taken for Sample | |
SAMPLE_UOM | VARCHAR2 | (4) | Y | UOM |
DELETE_MARK | NUMBER | (5) | Y | Delete mark used for logical deletion in OPM |
EXTERNAL_ID | VARCHAR2 | (32) | External ID | |
ITEM_NUMBER | VARCHAR2 | (32) | Y | Item number |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Y | Item Description |
ITEM_UOM | VARCHAR2 | (4) | Y | Item Primary UOM |
INVENTORY_TYPE | VARCHAR2 | (4) | Inventory Type | |
FORMULA_ID | NUMBER | (10) | Formula Id | |
FORMULA_NUMBER | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | Sub Lot Number | |
BATCH_NUMBER | VARCHAR2 | (32) | Production Batch Number | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
VENDOR_NUMBER | VARCHAR2 | (32) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (40) | Vendor Name | |
OPERATION_ID | NUMBER | (10) | Operation Id | |
OPERATION_NUMBER | VARCHAR2 | (16) | Operation Number | |
OPERATION_VERSION | NUMBER | (5) | Operation Version | |
ROUTING_ID | NUMBER | (10) | Routing Id | |
ROUTING_NUMBER | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERSION | NUMBER | (5) | Routing Version | |
ROUTING_STEP_NUMBER | NUMBER | (5) | Routing Step Number | |
CUSTOMER_ID | NUMBER | (15) | Customer ID | |
SHIP_TO_SITE_ID | NUMBER | Ship to Site ID |
APPS.PMIFV_QC_SAMPLE_V is not referenced by any database object
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUALITY_CONTROL_SPEC_ID | NUMBER | (10) | ||
ASSAY_TYPE_ID | NUMBER | (15) | ||
ORGANIZATION_CODE | VARCHAR2 | (4) | ||
WAREHOUSE_CODE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
DOCUMENT_TYPE | VARCHAR2 | (4) | ||
VENDOR_SPECIFICATION | NUMBER | (5) | ||
VENDOR_CERTIFICATION | NUMBER | (5) | ||
CUSTOMER_SPECIFICATION | NUMBER | (5) | ||
CUSTOMER_CERTIFICATION | NUMBER | (5) | ||
ASSAY_CODE | VARCHAR2 | (16) | ||
TEXT_SPEC | VARCHAR2 | (16) | ||
MIN_SPEC | NUMBER | |||
MAX_SPEC | NUMBER | |||
TARGET_SPEC | NUMBER | |||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | ||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
OUT_OF_ACTION_CODE | VARCHAR2 | (4) | ||
OUT_OF_ACTION_INTERVAL | NUMBER | |||
PREFERENCE | NUMBER | (5) | ||
PRINT_COA_SHIPPED | NUMBER | (5) | ||
PRINT_COA_INVOICED | NUMBER | (5) | ||
VENDOR_COA_REQUIRED | VARCHAR2 | (80) | ||
DELETE_MARK | NUMBER | (5) | ||
ROUTING_STEP_NUMBER | NUMBER | (5) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
ITEM_NUMBER | VARCHAR2 | (32) | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | ||
VENDOR_ID | NUMBER | (10) | ||
VENDOR_NUMBER | VARCHAR2 | (32) | ||
VENDOR_NAME | VARCHAR2 | (40) | ||
FORMULA_NUMBER | CHAR | (1) | ||
FORMULA_VERSION | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (32) | ||
SUB_LOT_NUMBER | VARCHAR2 | (32) | ||
BATCH_NUMBER | CHAR | (1) | ||
ROUTING_NUMBER | CHAR | (1) | ||
ROUTING_VERSION | NUMBER | |||
OPERATION_NUMBER | CHAR | (1) | ||
OPERATION_VERSION | NUMBER | |||
EFFECTIVE | VARCHAR2 | (80) | ||
CUSTOMER_ID | NUMBER | (15) | ||
SHIP_TO_SITE_ID | NUMBER |
APPS.PMIFV_QC_SPECIFICATIONS_V is not referenced by any database object
A Business Intelligence System view
Availability and planned usage of Process Manufacturing resources
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCES | VARCHAR2 | (16) | Y | Code for the resource. |
RESOURCE_DESC | VARCHAR2 | (240) | Y | Description of the resource. |
STD_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which resource usage is expressed. | |
RESOURCE_CLASS | VARCHAR2 | (8) | Resource class to which the resource belongs. | |
RESOURCE_COST_COMP_CLASS_ID | NUMBER | (10) | Y | Surrogate key of the cost component class which is used for tracking costs. |
RESOURCE_COST_COMP_CLASS_CODE | VARCHAR2 | (32) | Y | Cost component class |
RESOURCE_COST_COMP_CLASS_DESC | VARCHAR2 | (240) | Y | Cost component class description |
ORGANIZATION | VARCHAR2 | (4) | Plant code | |
GROUP_RESOURCE | VARCHAR2 | (16) | Resource group - resources can be grouped by this type | |
ASSIGNED_QTY | NUMBER | How many of this resource are in this plant. | ||
DAILY_AVAIL_USE | NUMBER | Number of hours the resource is available in the plant each day. | ||
RESOURCE_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which daily_avail_use is expressed. | |
NOMINAL_COST | NUMBER | Cost of the resource in the plant. | ||
INACTIVE_IND | NUMBER | Inactive indicator. 0=Active, 1=Inactive. | ||
IDEAL_CAPACITY | NUMBER | Optimum throughput capacity. | ||
MIN_CAPACITY | NUMBER | Minimum throughput capacity. | ||
MAX_CAPACITY | NUMBER | Maximum throughput capacity. | ||
CAPACITY_UOM | VARCHAR2 | (4) | Unit of measure in which capacity is expressed. | |
BATCH_ID | NUMBER | (10) | Surrogate key to the batch. | |
BATCHSTEP_NO | NUMBER | (10) | Y | The number of the batch step performing the operation. |
ACTIVITY | VARCHAR2 | (16) | Y | The activity performed in the operation. |
ACTIVITY_DESC | VARCHAR2 | (40) | Description of the activity. | |
BATCHSTEPLINE_ID | NUMBER | (10) | Surrogate key to the batch step line. | |
OPRN_LINE_ID | NUMBER | (10) | Surrogate key to the operation line, 0 if a resource/activity was inserted for the batch. | |
COST_ANALYSIS_CODE | VARCHAR2 | (32) | Cost analysis code, defaults from fm_oprn_dtl. | |
OPERATION_COST_COMP_CLASS_ID | NUMBER | (10) | Surrogate key for a cost component class , defaults from fm_oprn_dtl. | |
OPERATION_COST_COMP_CLASS_CODE | VARCHAR2 | (32) | Cost component class | |
OPERATION_COST_COMP_CLASS_DESC | VARCHAR2 | (240) | Cost component class description | |
PRIMARY_RESOURCE_INDICATOR | NUMBER | (5) | Primary resource indicator. 0=Not primary resource, 1=Primary resource. | |
SCALE_TYPE | NUMBER | (5) | Scale type. 0=Non-scaleable, 1=Linear scaling. | |
PLAN_RESOURCE_COUNT | NUMBER | Planned resource count, defaults from fm_oprn_dtl. | ||
ACTUAL_RESOURCE_COUNT | NUMBER | Actual resource count, recorded during WIP or certification. | ||
PLAN_RESOURCE_QTY | NUMBER | Planned quantity processed by the resource. | ||
ACTUAL_RESOURCE_QTY | NUMBER | Actual quantity processed by the resource. | ||
PLAN_RESOURCE_USAGE | NUMBER | Planned resource usage, defaults from fm_oprn_dtl. | ||
ACTUAL_RESOURCE_USAGE | NUMBER | Actual resource usage, recorded during WIP or certification. | ||
OPERATION_USAGE_UOM | VARCHAR2 | (4) | Unit of measure in which the usage is expressed. | |
DEPENDENT_OPRN_LINE_ID | VARCHAR2 | (0) | Surrogate key to the operation line that this step depends on. | |
OFFSET_INTERVAL | NUMBER | Time offset in hours from operation start to this resource/activity. | ||
PLAN_START_DATE | DATE | Planned start date/time for this step. | ||
ACTUAL_START_DATE | DATE | Actual start date/time for this step. | ||
PLAN_COMPLETE_DATE | DATE | Planned completion date/time for this step. | ||
ACTUAL_COMPLETE_DATE | DATE | Actual completion date/time for this step. | ||
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_RESOURCE_PLAN_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
Details of all shipped sales orders which are associated to corresponding GL periods.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORDER_SOURCE_SYSTEM | CHAR | (4) | This column is to Identify source of order is it OPM OP or OM | |
PRICE_ID | NUMBER | Price ID | ||
PRICE_SELECTED_IND | NUMBER | Price Selection Indicator | ||
ORDER_ID | NUMBER | Order ID | ||
ORDER_NO | VARCHAR2 | (40) | Order Number | |
ORDER_DATE | DATE | Order Date | ||
ORDER_STATUS | NUMBER | Order Status | ||
LINE_ID | NUMBER | Line ID | ||
LINE_NO | NUMBER | Line Number | ||
LINE_STATUS | NUMBER | Line Status | ||
ITEM_ID | NUMBER | (10) | Item ID | |
ITEM_NO | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
ITEM_UOM | VARCHAR2 | (4) | Item UOM | |
SALES_CLASS | VARCHAR2 | (8) | Sales Class | |
ORDER_QUANTITY | NUMBER | Order Quantity | ||
ORDER_QUANTITY_ITEM_UOM | NUMBER | Order Quantity in Item UOM | ||
ORDER_UOM | VARCHAR2 | (4) | Order UOM | |
BILLING_CUSTOMER_CLASS | VARCHAR2 | (0) | Billing Customer Class | |
BILLING_CUSTOMER_ID | NUMBER | (15) | Billing Customer ID | |
BILLING_CUSTOMER_NO | VARCHAR2 | (4000) | Billing Customer Number | |
BILLING_CUSTOMER_NAME | VARCHAR2 | (360) | Billing Customer Name | |
BILLING_CUSTOMER_ADDID | NUMBER | (15) | Billing Customer Address ID | |
BILLING_CUSTOMER_CITY | VARCHAR2 | (70) | Billing Customer City | |
BILLING_CUSTOMER_STATE | VARCHAR2 | (60) | Billing Customer State | |
BILLING_CUSTOMER_COUNTRY | VARCHAR2 | (60) | Billing Customer Address | |
SHIPPING_CUSTOMER_CLASS | VARCHAR2 | (0) | Shipping Customer Class | |
SHIPPING_CUSTOMER_ID | NUMBER | (15) | Shipping Customer ID | |
SHIPPING_CUSTOMER_NO | VARCHAR2 | (4000) | Shipping Customer Number | |
SHIPPING_CUSTOMER_NAME | VARCHAR2 | (360) | Shipping Customer Name | |
SHIPPING_CUSTOMER_ADDID | NUMBER | Shipping Customer Address ID | ||
SHIPPING_CUSTOMER_CITY | VARCHAR2 | (70) | Shipping Customer City | |
SHIPPING_CUSTOMER_STATE | VARCHAR2 | (60) | Shipping Customer State | |
SHIPPING_CUSTOMER_COUNTRY | VARCHAR2 | (60) | Shipping Customer Address | |
SHIPPER_CODE | VARCHAR2 | (30) | Shipper Code | |
SHIPPING_METHOD | VARCHAR2 | (30) | Shipping Method | |
WAREHOUSE_SHIPPED_TO | VARCHAR2 | (40) | Warehouse Shipped To | |
WAREHOUSE_SHIPPED_FROM | VARCHAR2 | (4) | Warehouse Shipped From | |
SHIPPING_ORGANIZATION | VARCHAR2 | (4) | Shipping Organization | |
SHIPPING_ORGANIZATION_NAME | VARCHAR2 | (40) | Shipping Organization Name | |
SHIPPING_COMPANY | VARCHAR2 | (4) | Shipping Company | |
SHIPPING_STATUS | NUMBER | Shipping Status | ||
BASE_PRICE | NUMBER | Base Price | ||
NET_PRICE | NUMBER | Net Price | ||
EXTENDED_PRICE | NUMBER | Extended Price | ||
EXTENDED_PRICE_BASE_CURRENCY | NUMBER | Extended Price Base Currency | ||
CHARGES_BASE_CURRENCY | NUMBER | Charges in Base Currency | ||
PRICING_UOM | VARCHAR2 | (4) | Pricing UOM | |
BILLING_CURRENCY | VARCHAR2 | (15) | Billing Currency | |
BASE_CURRENCY | VARCHAR2 | (15) | Base Currency | |
EXCHANGE_RATE | NUMBER | Exchange Rate | ||
REQUESTED_SHIPDATE | DATE | Requested Ship date of order | ||
PROMISED_SHIPDATE | DATE | Promised Ship date of order | ||
LIST_PRICE | NUMBER | List Price | ||
SCHEDULED_SHIPDATE | DATE | Scheduled Ship date of order | ||
ACTUAL_SHIPDATE | DATE | Actual ship date of order | ||
REQUIRED_DELIVERY_DATE | DATE | Required Delivery Date | ||
ACTUAL_DELIVERY_DATE | DATE | Actual Delivery Date | ||
QC_GRADE_WANTED | VARCHAR2 | (150) | QC grade Wanted from customer | |
SALES_REPRESENTATIVE | VARCHAR2 | (40) | Sales Representative Code | |
SALES_REP_NAME | VARCHAR2 | (240) | Sales Representative Name | |
COMMISSION_CODE | VARCHAR2 | (8) | Commission Code | |
NET_COMMISSION | NUMBER | Net commission on line | ||
NET_TAX | NUMBER | Net Tax on order line | ||
CUSTOMER_PO_NO | VARCHAR2 | (50) | Customer Purchase order Number | |
SALES_COMPANY | VARCHAR2 | (4) | Sales Company | |
SALES_ORGANIZATION | VARCHAR2 | (4) | Sales Organization | |
SALES_ORGANIZATION_NAME | VARCHAR2 | (240) | Sales Organization Name | |
FISCAL_YEAR | NUMBER | (15) | Fiscal Year in which order falls | |
PERIOD_CODE | NUMBER | (15) | Period Code in which order falls | |
PERIOD_NAME | VARCHAR2 | (15) | Period name | |
PERIOD_START_DATE | DATE | Period Start Date | ||
PERIOD_END_DATE | DATE | Period End date | ||
CREATION_DATE | DATE | Order Detail creation date | ||
LAST_UPDATE_DATE | DATE | Order Detail Last Update Date | ||
CREATED_BY | NUMBER | Order Details Created By | ||
LAST_UPDATED_BY | NUMBER | Order Detail Last update by | ||
OPERATING_UNIT_ID | NUMBER | (15) | ||
OPERATING_UNIT_NAME | VARCHAR2 | (240) | Operating Unit Name |
APPS.PMIFV_SALES_DETAILS_V is not referenced by any database object
A Business Intelligence System view
Ledger of Process Manufacturing Costing detail information produced during Cost Rollup process.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STD_QTY | NUMBER | Y | Effectivity standard quantity converted to an item inventory uom. | |
FORM_PROD_UOM | VARCHAR2 | (4) | UOM of the product within the formula | |
ROUTING_QTY | NUMBER | Y | Routing quantity converted to product inventory uom | |
PRODUCT_QTY | NUMBER | Y | Product qty converted to product inventory uom | |
COST_ALLOC | NUMBER | (10) | Y | Cost allocation percentage - The percentage of the ingredient costs that contribute towards the Product cost |
LINE_TYPE | NUMBER | (10) | Y | Type of line 1=ingredient, -1=byproduct |
LINE_TYPE_MEANING | VARCHAR2 | (80) | Type of line 1=ingredient, -1=byproduct | |
ITEM_QTY | NUMBER | Y | Ingredient/byproduct quantity converted to inventory uom | |
ITEM_FMQTY | NUMBER | Y | Ingredient/byproduct quantity at formula uom | |
ITEM_FMQTY_UM | VARCHAR2 | (4) | Ingredient/byproduct formula uom | |
COMPONENT_COST | NUMBER | Y | Ingredient/byproduct Component cost | |
RESOURCE_COUNT | NUMBER | Resource count from the operation details | ||
RESOURCE_USAGE | NUMBER | Resource usage from the operation details | ||
NOMINAL_COST | NUMBER | Nominal cost for the resource at usage uom | ||
USAGE_UOM | VARCHAR2 | (4) | Standard resource uom | |
RUDTL_ID | NUMBER | (10) | Y | Surrogate for this row |
ITEM_ID | NUMBER | (10) | Surrogate for the ingedient/byproduct | |
WHSE_CODE | VARCHAR2 | (4) | Warehouse code | |
RESOURCES | VARCHAR2 | (16) | Resource | |
CMPNTCOST_ID | NUMBER | (10) | Y | Surrogate from cost component details |
ITEM_NUMBER | VARCHAR2 | (32) | Name of the item. | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Short description of the item that is displayed during the item look up. | |
ITEM_UOM | VARCHAR2 | (4) | Uom of the item by which the inventory balances are maintained. | |
ITEM_UOM2 | VARCHAR2 | (4) | Second UOM for in which inventory balances are maintained, for dual UOM items. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
APPS.PMIFV_STANDARD_COST_LEDGER_V is not referenced by any database object
A Business Intelligence System view
Process Manufacturing Units of Measure and their associated conversion factors.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UOM_CODE | VARCHAR2 | (25) | Unit of Measure code for which the conversion is defined. | |
UOM_DESC | VARCHAR2 | (40) | Updated Description | |
STANDARD_FACTOR | NUMBER | Conversion factor to the reference UOM of the same Type. | ||
ROUNDING_FACTOR | NUMBER | Unused, defaulted to 0. | ||
REFERENCE_UOM | VARCHAR2 | (0) | Reference Unit of Measure for the same Unit of Measure Type. | |
UOM_TYPE | VARCHAR2 | (10) | Y | The Unit of Measure Type associated with each Unit of Measure |
TYPE_DESCRIPTION | VARCHAR2 | (40) | Unit of Measure Type description. | |
STANDARD_UOM | VARCHAR2 | (25) | The Standard, or reference, UOM for this UOM Type | |
CREATED_BY | NUMBER | Y | Standard who column | |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column |
APPS.PMIFV_UOM_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE | NUMBER | |||
SUBLEDGER_ID | NUMBER | (10) | Subsidiary ledger key. | |
CO_CODE | VARCHAR2 | (4) | Company of transaction. | |
FISCAL_YEAR | NUMBER | (5) | Fiscal year of gl posting. | |
PERIOD | NUMBER | (5) | Period of gl posting. | |
SUB_EVENT_CODE | VARCHAR2 | (4) | ||
VOUCHER_ID | NUMBER | (10) | GL journal voucher identifier. | |
DOC_TYPE | VARCHAR2 | (4) | Document type. | |
DOC_ID | NUMBER | (10) | Document identifier within doc type. | |
JOIN_DOC_ID | NUMBER | This will have actual Document id for XFER,TRNI,TRNR,MTRI | ||
LINE_ID | NUMBER | (10) | Detail line identifier. | |
ACCT_TTL_CODE | VARCHAR2 | (4) | ||
ACCTG_UNIT_NO | VARCHAR2 | (240) | OPM Accounting unit Description. | |
ACCT_NO | VARCHAR2 | (240) | OPM Account Description. | |
DEBIT_CREDIT_SIGN | NUMBER | (5) | Debit or Credit indicator for the Amounts: -1=credit; =1=debit. | |
ACCTG_UNIT_DESC | VARCHAR2 | (70) | ||
ACCT_DESC | VARCHAR2 | (70) | ||
AMOUNT_BASE | NUMBER | GL amount in Base currency. | ||
AMOUNT_TRANS | NUMBER | GL amount in Transaction currency. | ||
CURRENCY_BASE | VARCHAR2 | (4) | Base currency of transaction. | |
CURRENCY_TRANS | VARCHAR2 | (4) | Currency of transaction. | |
JV_QUANTITY | NUMBER | Quantity of GL Account. | ||
JV_QUANTITY_UM | VARCHAR2 | (4) | Unit of measure of quantity. | |
SUB_EVENT_DESC | VARCHAR2 | (70) | Sub Event Description. | |
TRANS_SOURCE_CODE | VARCHAR2 | (4) | Abbreviation assigned to subsystem | |
TRANS_SOURCE_DESC | VARCHAR2 | (70) | subsystem description | |
GL_TRANS_DATE | DATE | GL transaction date. | ||
ORGN_CODE | VARCHAR2 | (16) | Organization of transaction. | |
DOC_NO | VARCHAR2 | (40) | Document Number. | |
DOC_DATE | DATE | Document Transaction Date. | ||
LINE_NO | VARCHAR2 | (150) | Detail line Number. | |
RESOURCE_ITEM_NO | VARCHAR2 | (32) | Item Number. | |
RESOURCE_ITEM_NO_DESC | VARCHAR2 | (240) | Item Description. | |
TRANS_DATE | DATE | Transaction Date. | ||
WHSE_CODE | VARCHAR2 | (4) | Warehouse Code | |
TRANS_QTY_USAGE | NUMBER | Transaction Qty Usage | ||
TRANS_QTY_USAGE_UM | VARCHAR2 | (25) | Transaction Qty Usage UOM | |
REFERENCE_NO | NUMBER | (10) | The Subsidiary Ledger Run reference number. | |
TRANS_TYPE | VARCHAR2 | (11) | Transaction Type. This column is used to join subsidiary ledger data with inventory data |
APPS.PMITS_FINAL_SUBLEDGER_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_ID | NUMBER | Formula ID | ||
FORMULA_DESC1 | CHAR | (3) | Formula Description | |
FORMULA_DESC2 | CHAR | (3) | Formula Comment | |
FORMULA_NO | CHAR | (3) | Formula Number | |
FORMULA_VERS | NUMBER | Formula Version | ||
FORMULA_TYPE | CHAR | (3) | Formula Packaging Type | |
SCALE_TYPE | CHAR | (3) | Scale Allowed Type | |
FORMULA_CLASS | CHAR | (3) | Formula Class | |
FMCONTROL_CLASS | CHAR | (3) | Formula Control Class | |
INACTIVE_IND | CHAR | (3) | Inactive Indicator | |
ORGN_CODE | CHAR | (3) | Organization Code | |
TEXT_CODE | NUMBER | Text Code | ||
DELETE_MARK | NUMBER | Delete Mark | ||
PROJECT_ID | NUMBER | Project ID | ||
FORMULA_STATUS | CHAR | (3) | Formula Status | |
OWNER_ID | NUMBER | Owner ID | ||
TOTAL_INPUT_QTY | NUMBER | Total Input Quantity | ||
TOTAL_OUTPUT_QTY | NUMBER | Total Output Quantity | ||
FORMULA_UOM | CHAR | (3) | Formula UOM | |
OWNER | CHAR | (3) | Owner | |
OWNER_DESC | CHAR | (3) | Owner Description | |
STATUS | CHAR | (3) | Formula Status | |
FORMULA_CLASS_DESC | CHAR | (3) | Formula class Description | |
ORGN_DESC | CHAR | (3) | Organization Description |
APPS.PMITS_FORMULA_MASTER_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOC_ID | NUMBER | (10) | Document ID | |
JOIN_DOC_ID | NUMBER | This will have actual Document id for XFER,TRNI,TRNR,MTRI | ||
DOC_TYPE | VARCHAR2 | (4) | Documnet Type | |
LINE_ID | NUMBER | (10) | Detail Line Identifier | |
ITEM_ID | NUMBER | (10) | Item Identifier | |
COMPANY_CODE | VARCHAR2 | (4) | Company Code | |
ORGANIZATION_CODE | VARCHAR2 | (4) | Organization Code | |
WAREHOUSE_CODE | VARCHAR2 | (4) | Warehouse Code | |
LOCATION | VARCHAR2 | (16) | Location | |
TRANSACTION_DATE | VARCHAR2 | (4000) | Transaction Date | |
LOT_ID | VARCHAR2 | (40) | Lot Identifier | |
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUBLOT_NUMBER | VARCHAR2 | (32) | Sublot Number | |
LOT_STATUS | VARCHAR2 | (4) | Lot Status | |
QUALITY_CONTROL_GRADE | VARCHAR2 | (4) | Quality Control Grade | |
REASON_CODE | VARCHAR2 | (4) | Reason Code | |
TRANSACTION_UOM | VARCHAR2 | (4) | Transaction UOM | |
TRANSACTION_SECONDARY_UOM | VARCHAR2 | (4) | Transaction Secondary UOM | |
TRANSACTION_QTY | NUMBER | Transaction Quantity | ||
TRANSACTION_QTY2 | NUMBER | Transaction Quantity in Secondary UOM | ||
TRANS_TYPE | CHAR | (8) | Transaction Type. This column is used to join subsidiary ledger data with inventory data |
APPS.PMITS_INV_LINE_SUMM_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOT_ID | NUMBER | (10) | Y | Lot ID |
LOT_NO | VARCHAR2 | (32) | Y | Lot Number |
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
UM_TYPE | VARCHAR2 | (10) | Y | Conversion UOM Type |
FROM_UOM_TYPE | VARCHAR2 | (10) | Y | Conversion from UOM Type |
FROM_UOM_CODE | VARCHAR2 | (25) | Conversion from UOM Code | |
TO_UOM_CODE | VARCHAR2 | (25) | Conversion to UOM Code | |
ITEM_ID | NUMBER | (10) | Y | Item ID |
ITEM_NO | VARCHAR2 | (32) | Y | Item Number |
ITEM_UM | VARCHAR2 | (4) | Y | Primary UOM of Item |
TYPE_FACTOR | NUMBER | Y | Conversion Factor from UOM to To UOM | |
TYPE_FACTORREV | NUMBER | Y | Conversion Factor To UOM to From UOM | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module |
APPS.PMITS_ITEM_LOT_UOM_CONV_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | Y | Surrogate key for the item |
ITEM_NO | VARCHAR2 | (32) | Y | Item Number |
ALT_ITEMA | VARCHAR2 | (32) | Alternate name for the item | |
ALT_ITEMB | VARCHAR2 | (32) | Second alternate name for the item | |
ITEM_UM | VARCHAR2 | (4) | Y | Primary unit of measure of the item by which the inventory balances are maintained |
DUALUM_IND | NUMBER | (5) | Y | Dual unit of measure indicator. 0=Single UOM control, 1=Fixed relationship dual UOM control, 2=Variable relationship dual UOM control with default conversion displayed, 3= Variable relationship dual UOM control with default conversion not displayed |
DUALUM_IND_DISP | VARCHAR2 | (80) | Y | Dual unit of measure indicator resolved using Lookup |
ITEM_UM2 | VARCHAR2 | (4) | Secondary unit of measure of the item by which the inventory balances are maintained for dual UOM items | |
DEVIATION_LO | NUMBER | Y | Factor defining the allowable deviation below the standard conversion for dual UOM items with dualum_ind as 2 or 3 | |
DEVIATION_HI | NUMBER | Y | Factor defining the allowable deviation above the standard conversion for dual UOM items with dualum_ind as 2 or 3 | |
LOT_CTL | NUMBER | (5) | Y | Lot Control Indicator. 0=Not lot controlled, 1=Lot controlled |
LOT_CTL_DISP | VARCHAR2 | (80) | Lot Control Indicator resolved using Lookup | |
LOT_INDIVISIBLE | NUMBER | (5) | Y | Indivisible indicator. 0=Lots are not indivisible (can be split), 1=Lots are indivisible (cannot be split). |
LOT_INDIVISIBLE_DISP | VARCHAR2 | (80) | Indivisible indicator resolved using Lookup | |
SUBLOT_CTL | NUMBER | (5) | Y | Sublot control indicator. 0=Not sublot controlled, 1=Sublot controlled. Used only if lot_ctl =1 |
SUBLOT_CTL_DISP | VARCHAR2 | (80) | Sublot control indicator resolved using lookup | |
LOCT_CTL | NUMBER | (5) | Y | Location control indicator. 0=Not location controlled, 1=Location controlled |
LOCT_CTL_DISP | VARCHAR2 | (80) | Y | Location control indicator resolved using lookup |
NONINV_IND | NUMBER | (5) | Y | Noninventory indicator. 0=Not a noninventory item (inventory balances NONINV_IND = 0, Inventory Item. are maintained), 1=Noninventory item (inventory balances are not maintained). |
NONINV_IND_DISP | VARCHAR2 | (80) | Noninventory indicator resolved using lookup | |
MATCH_TYPE | NUMBER | (5) | Y | Type of invoice matching done. Blank=No matching, 2=Two way matching, 3=Three way matching |
MATCH_TYPE_DISP | VARCHAR2 | (80) | Y | Type of invoice matching code resolved using lookup |
INACTIVE_IND | NUMBER | (5) | Y | Inactive indicator. 0=Active, 1=Inactive |
INACTIVE_IND_DISP | VARCHAR2 | (80) | Inactive indicator code resolved using lookup | |
INV_TYPE | VARCHAR2 | (4) | Inventory type | |
SHELF_LIFE | NUMBER | Y | Shelf life. This number of days is added to lots of grade controlled items to calculate the expiration date | |
RETEST_INTERVAL | NUMBER | Y | Number of days specifying how often grade controlled items should be retested | |
GL_CLASS | VARCHAR2 | (8) | GL Class for an item | |
INV_CLASS | VARCHAR2 | (8) | Inventory Class for an item | |
SALES_CLASS | VARCHAR2 | (8) | Sales Class for an item | |
SHIP_CLASS | VARCHAR2 | (8) | Shipping Class for an item | |
FRT_CLASS | VARCHAR2 | (8) | Freight Class for an item | |
PRICE_CLASS | VARCHAR2 | (8) | Price Class for an item | |
STORAGE_CLASS | VARCHAR2 | (8) | Storage Class for an item | |
PURCH_CLASS | VARCHAR2 | (8) | Purchase Class for an item | |
TAX_CLASS | VARCHAR2 | (8) | Tax Class for an item | |
CUSTOMS_CLASS | VARCHAR2 | (8) | Customs class for an item | |
ALLOC_CLASS | VARCHAR2 | (8) | Allocation class for an item. Used for auto-allocation | |
PLANNING_CLASS | VARCHAR2 | (8) | Planning class for an item. Used for MPS and MRP reporting | |
ITEMCOST_CLASS | VARCHAR2 | (8) | Cost class for an item | |
UPC_CODE | VARCHAR2 | (16) | UPC Code | |
GRADE_CTL | NUMBER | (5) | Y | Grade control indicator. 0=Not grade controlled, 1=Grade controlled |
GRADE_CTL_DISP | VARCHAR2 | (80) | Grade control indicator code resolved using lookup | |
STATUS_CTL | NUMBER | (5) | Y | Status control indicator. 0=Not status controlled, 1=Status controlled |
STATUS_CTL_DISP | VARCHAR2 | (80) | Y | Status control indicator code resolved using lookup |
QC_GRADE | VARCHAR2 | (4) | Default grade, for lots of grade controlled items | |
LOT_STATUS | VARCHAR2 | (4) | Default status, for lots of status controlled items | |
QCITEM_ID | NUMBER | (10) | QC reference item | |
QCHOLD_RES_CODE | VARCHAR2 | (4) | QC hold reason code | |
EXPACTION_CODE | VARCHAR2 | (4) | Code for action to take when a lot expires | |
PLANNING_CATEGORY_ID | NUMBER | Category Id for Planning Class | ||
PRICE_CATEGORY_ID | NUMBER | Category Id for Price Class | ||
EXPACTION_INTERVAL | NUMBER | Y | Interval between time lot expires and time expaction_code action should be taken | |
WHSE_ITEM_ID | NUMBER | (10) | Y | For sharing a common ps_whse_eff row |
EXPERIMENTAL_IND | NUMBER | (5) | Y | Experimental indicator. 0=Unrestricted use item (not experimental); 1=Experimental item (cannot be used in FM or PM). |
EXPERIMENTAL_IND_DISP | VARCHAR2 | (80) | Y | Experimental indicator code resolved using lookup |
EXPORTED_DATE | DATE | Y | Date the item was exported to Oracle Financials. | |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
SEQ_DPND_CLASS | VARCHAR2 | (8) | Sequence dependent class | |
COMMODITY_CODE | VARCHAR2 | (9) | reference code associated with a product class. Used for export/ importing among European countries | |
ONT_PRICING_QTY_SOURCE | NUMBER | (5) | OM/OPM integration pricing by quantity 2 indicator - 0 indicates pricing by order quantity; 1 indicates pricing by secondary quantity | |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ITEM_ABCCODE | VARCHAR2 | (4) | ABC Code for the item | |
ALLOC_CATEGORY_ID | NUMBER | Category Id for Allocation Class | ||
CUSTOMS_CATEGORY_ID | NUMBER | Category Id for Customs Class | ||
FRT_CATEGORY_ID | NUMBER | Category Id for Freight Class | ||
GL_CATEGORY_ID | NUMBER | Category Id for GL Class | ||
INV_CATEGORY_ID | NUMBER | Category Id for Inventory Class | ||
COST_CATEGORY_ID | NUMBER | Category Id for Cost Class | ||
PURCH_CATEGORY_ID | NUMBER | Category Id for Purchase Class | ||
SALES_CATEGORY_ID | NUMBER | Category Id for Sales Class | ||
SEQ_CATEGORY_ID | NUMBER | Category Id for SEQ Class | ||
SHIP_CATEGORY_ID | NUMBER | Category Id for Shipping Class | ||
STORAGE_CATEGORY_ID | NUMBER | Category Id for Storage Class | ||
TAX_CATEGORY_ID | NUMBER | Category Id for Tax Class | ||
ITEM_DESC1 | VARCHAR2 | (70) | Y | MLS Description of the item |
ITEM_DESC2 | VARCHAR2 | (70) | MLS comments of the item |
APPS.PMITS_ITEM_MASTER_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPRN_LINE_ID | NUMBER | (15) | Y | Operation Line ID |
OPRN_ID | NUMBER | (15) | Y | Operation ID |
ACTIVITY | VARCHAR2 | (16) | Y | Activity |
OFFSET_INTERVAL | NUMBER | Y | Offset Interval | |
ACTIVITY_FACTOR | NUMBER | Y | Activity Factor | |
DELETE_MARK | NUMBER | (5) | Y | Delete Mark |
TEXT_CODE | NUMBER | (10) | Text Code | |
ACTIVITY_DESC | VARCHAR2 | (40) | Y | Activity Description |
APPS.PMITS_OPERATION_ACTIVITIES_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPRN_ID | NUMBER | Operation ID | ||
OPRN_NO | CHAR | (3) | Operation Number | |
OPRN_VERS | NUMBER | Operation Version | ||
PROCESS_QTY_UM | CHAR | (3) | Process Quantity UOM | |
OPRN_CLASS | CHAR | (3) | Operation Class | |
POC_CTL_CLASS | CHAR | (3) | Procedure Control Class | |
INACTIVE_IND | NUMBER | Inactive Indicator | ||
DELETE_MARK | NUMBER | Delete Mark | ||
TEXT_CODE | NUMBER | Text Code | ||
EFFECTIVE_START_DATE | DATE | Effective Start Date | ||
EFFECTIVE_END_DATE | DATE | Effective End Date | ||
OPERATION_STATUS | CHAR | (3) | Operation Status | |
OWNER_ORGN_CODE | CHAR | (3) | Owner Ognization Code | |
OPRN_DESC | CHAR | (3) | Operation Description | |
ORGN_NAME | CHAR | (3) | Organization Name | |
OPRN_CLASS_DESC | CHAR | (3) | Operation Class Description | |
STATUS | CHAR | (3) | Operation Status |
APPS.PMITS_OPERATION_MASTER_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCES | CHAR | (3) | Resource | |
RESOURCE_DESC | CHAR | (3) | Resource Description | |
RESOURCE_CLASS | CHAR | (3) | Resource Class | |
OPRN_LINE_ID | NUMBER | Operation Line ID | ||
RSRC_UOM | CHAR | (3) | Resource UOM | |
PROCESS_QTY | NUMBER | Process Quantity | ||
PROCESS_UOM | CHAR | (3) | UOM for Process Quantity | |
RESOURCE_USAGE | NUMBER | Resource Usage Amount | ||
USAGE_UM | CHAR | (3) | UOM for Resource Usage | |
RESOURCE_COUNT | NUMBER | Resource Count | ||
PRIM_RSRC_IND | NUMBER | Primary Resource Indicator | ||
PRIM_RSRC_IND_DISP | CHAR | (3) | ||
SCALE_TYPE | NUMBER | Scale Type | ||
SCALE_TYPE_DISP | CHAR | (3) | ||
COST_CMPNTCLS_ID | NUMBER | Cost Component Class ID | ||
COST_CMPNTCLS_CODE | CHAR | (3) | Cost Component Class Code | |
COST_CMPNTCLS_DESC | CHAR | (3) | Cost Component Class Description | |
COST_ANALYSIS_CODE | CHAR | (3) | Cost Analysis Code | |
COST_ANALYSIS_DESC | CHAR | (3) | Cost Analysis Description | |
OFFSET_INTERVAL | NUMBER | Offset Interval | ||
DELETE_MARK | NUMBER | Delete Mark | ||
TEXT_CODE | NUMBER | Text Code | ||
MIN_CAPACITY | NUMBER | Minimum Capacity | ||
MAX_CAPACITY | NUMBER | Maximum Capacity | ||
CAPACITY_UOM | CHAR | (3) | Capacity UOM | |
PROCESS_PARAMETER_1 | CHAR | (3) | Process Parameter 1 | |
PROCESS_PARAMETER_2 | CHAR | (3) | Process Parameter 2 | |
PROCESS_PARAMETER_3 | CHAR | (3) | Process Parameter 3 | |
PROCESS_PARAMETER_4 | CHAR | (3) | Process Parameter 4 | |
PROCESS_PARAMETER_5 | CHAR | (3) | Process Parameter 5 |
APPS.PMITS_OPERATION_RESOURCES_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPEC_VR_ID | NUMBER | Unique Identifier for Spec Validity Rule | ||
SPEC_ID | NUMBER | Unique Identifier for Spec | ||
ORGN_CODE | CHAR | (3) | Organization | |
SPEC_TYPE | CHAR | (1) | Spec Type Code W-WIP, C-Customer, S-Supplier and I-Inventory | |
SPEC_TYPE_DISP | CHAR | (3) | Spec Type Meaning Resolved using GEM_LOOKUPS | |
SPEC_NAME | CHAR | (3) | Spec Name | |
SPEC_VERS | NUMBER | Spec Version | ||
ITEM_ID | NUMBER | Unique Identifier Item | ||
ITEM_NO | CHAR | (3) | ItemNumber | |
GRADE | CHAR | (3) | Quality Control Grade | |
SPEC_STATUS | NUMBER | Spec Status Code | ||
SPEC_STATUS_DESC | CHAR | (3) | Spec Status Meaning Resolved using GEM_LOOKUPS | |
LOT_ID | NUMBER | Unique Identifier Lot | ||
LOT_NO | CHAR | (3) | Lot Number | |
SUBLOT_NO | CHAR | (3) | Sublot Number | |
WHSE_CODE | CHAR | (3) | Warehouse Code | |
LOCATION | CHAR | (3) | Location | |
SPEC_VR_STATUS | NUMBER | Spec Validity Rule Status Code | ||
SPEC_VR_STATUS_DESC | CHAR | (3) | Spec Validity Rule Status Meaning Resolved using GEM_LOOKUPS | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End date | ||
SAMPLING_PLAN_ID | NUMBER | Sampling Plan ID | ||
SAMPLE_INV_TRANS_IND | CHAR | (1) | Update Inventory Qty Indicator | |
SAMPLE_INV_TRANS_IND_DISP | CHAR | (3) | Update Inventory Qty Indicator Meaning Resolved using GEM_LOOKUPS | |
CONTROL_LOT_ATTRIB_IND | CHAR | (1) | Control Lot Status Code | |
CONTROL_LOT_ATTRIB_IND_DISP | CHAR | (3) | Control Lot Status Meaning Resolved using GEM_LOOKUPS | |
OUT_OF_SPEC_LOT_STATUS | CHAR | (3) | Out of Spec Lot Status | |
IN_SPEC_LOT_STATUS | CHAR | (3) | In Spec Lot Status | |
CONTROL_BATCH_STEP_IND | CHAR | (1) | Control Batch Step Status | |
CONTROL_BATCH_STEP_IND_DISP | CHAR | (3) | Control Batch Step Status Meaning Resolved using GEM_LOOKUPS | |
LOT_OPTIONAL_ON_SAMPLE | CHAR | (1) | Lot Optional on sample | |
COA_TYPE | CHAR | (1) | Certificate Type | |
COA_TYPE_DISP | CHAR | (3) | Certificate Type Meaning Resolved using GEM_LOOKUPS | |
COA_AT_SHIP_IND | CHAR | (1) | COA Required at Shippment Indicator | |
COA_AT_SHIP_IND_DISP | CHAR | (3) | COA Required at Shippment Indicator Meaning Resolved using GEM_LOOKUPS | |
COA_AT_INVOICE_IND | CHAR | (1) | COA Required at Invoice Indicator | |
COA_AT_INVOICE_IND_DISP | CHAR | (3) | COA Required at Invoice Indicator Meaning Resolved using GEM_LOOKUPS | |
COA_REQ_FROM_SUPL_IND | CHAR | (1) | COA Required from Supplier Indicator | |
COA_REQ_FROM_SUPL_IND_DISP | CHAR | (3) | COA Required from Supplier Indicator Meaning Resolved using GEM_LOOKUPS | |
BATCH_ID | NUMBER | Unique Identifier for Batch | ||
RECIPE_ID | NUMBER | Unique Identifier for Recipe | ||
RECIPE_NO | CHAR | (3) | Recipe Number | |
RECIPE_VERSION | NUMBER | Recipe Version | ||
FORMULA_ID | NUMBER | Unique Identifier for Formula | ||
FORMULALINE_ID | NUMBER | Unique Identifier for Formula Line | ||
FORMULA_NO | CHAR | (3) | Formula Number | |
FORMULA_VERS | NUMBER | Formula Version | ||
ROUTING_ID | NUMBER | Unique Identifier for Routing | ||
ROUTING_NO | CHAR | (3) | Routing Number | |
ROUTING_VERS | NUMBER | Routing Version | ||
STEP_ID | NUMBER | Unique Identifier for Routing Step | ||
STEP_NO | CHAR | (3) | Routing Step Number | |
OPRN_ID | NUMBER | Unique Identifier for Operation | ||
OPRN_NO | CHAR | (3) | Operation Number | |
OPRN_VERS | NUMBER | Operation Version | ||
CHARGE | NUMBER | Charge | ||
CUST_ID | NUMBER | Unique Identifier for Customer | ||
ORDER_ID | NUMBER | Unique Identifier for Order | ||
ORDER_LINE | NUMBER | Order Line | ||
ORDER_LINE_ID | NUMBER | Unique Identifier for Order Line | ||
SHIP_TO_SITE_ID | NUMBER | Unique Identifier for Ship to Site | ||
ORG_ID | NUMBER | Unique Identifier for Operating Unit | ||
SUPPLIER_ID | NUMBER | Unique Identifier for Supplier | ||
SUPPLIER_SITE_ID | NUMBER | Unique Identifier for Supplier Site | ||
PO_HEADER_ID | NUMBER | Unique Identifier for Purchase Order Header | ||
PO_LINE_ID | NUMBER | Unique Identifier for Purchase Order Line | ||
DELETE_MARK | NUMBER | Marked for purge | ||
TEXT_CODE | NUMBER | Text Code | ||
CREATION_DATE | DATE | ROW WHO Column | ||
CREATED_BY | NUMBER | ROW WHO Column | ||
LAST_UPDATED_BY | NUMBER | ROW WHO Column | ||
LAST_UPDATE_DATE | DATE | ROW WHO Column | ||
LAST_UPDATE_LOGIN | NUMBER | ROW WHO Column |
APPS.PMITS_QC_ALL_SPEC_VRS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESULT_ID | NUMBER | Unique Identifier for Result | ||
SAMPLE_ID | NUMBER | Unique Identifier for Sample | ||
TEST_ID | NUMBER | Unique Identifier for Test | ||
TEST_REPLICATE_CNT | NUMBER | Test Replicate Count | ||
QC_LAB_ORGN_CODE | CHAR | (3) | QC Lab Organization Code | |
RESULT_VALUE_NUM | NUMBER | Numeric Result | ||
RESULT_DATE | DATE | Result Date | ||
TEST_KIT_ITEM_ID | NUMBER | Test Kit Item ID | ||
TEST_KIT_LOT_NO | CHAR | (3) | Test Kit Lot Number | |
TEST_KIT_SUBLOT_NO | CHAR | (3) | Test Kit Sublot Number | |
ADDITIONAL_TEST_IND | CHAR | (3) | Additional Test Indicator | |
RESULT_MEANING | CHAR | (3) | Result Display Label | |
TESTER | CHAR | (3) | Tester | |
TESTER_ID | NUMBER | Tester ID | ||
TEST_PROVIDER_ID | NUMBER | Test Provider ID | ||
AD_HOC_PRINT_ON_COA_IND | CHAR | (1) | Adhoc Print on COA Indicator | |
SEQ | NUMBER | Test Sequence | ||
RESULT_VALUE_CHAR | CHAR | (1) | Text Result | |
TEST_RESULT | CHAR | (3) | Test Result. It is a decode on Text Result and Numeric Result | |
TEST_PROVIDER_CODE | CHAR | (3) | Test Provider Code | |
ASSAY_RETEST | NUMBER | Assay Retest | ||
RSLT_DELETE_MARK | CHAR | (3) | Marked for Purge | |
TEXT_CODE | NUMBER | Text Code | ||
SPEC_ID | NUMBER | Unique Identifier for Spec | ||
TEST_METHOD_ID | NUMBER | Unique Identifier for Test Method | ||
TEST_QTY | NUMBER | Test Quantity | ||
TEST_UOM | CHAR | (3) | Test UOM | |
SPEC_MIN_VALUE | CHAR | (3) | Spec Min | |
SPEC_TARGET_VALUE | CHAR | (3) | Spec Target | |
SPEC_MAX_VALUE | CHAR | (3) | Spec Max | |
TEST_REPLICATE | NUMBER | Replicate | ||
CHECK_RESULT_INTERVAL | NUMBER | Check Result Interval | ||
PRINT_ON_COA_IND | CHAR | (1) | Print on COA Indicator | |
USE_TO_CONTROL_STEP | CHAR | (1) | Use to control Step | |
OUT_OF_SPEC_ACTION | CHAR | (3) | Out of Spec Action Code | |
EXP_ERROR_TYPE | CHAR | (1) | Experimental Error Type | |
BELOW_SPEC_MIN | NUMBER | Below Spec Min | ||
ABOVE_SPEC_MIN | NUMBER | Above Spec Min | ||
BELOW_SPEC_MAX | NUMBER | Below Spec Max | ||
ABOVE_SPEC_MAX | NUMBER | Above Spec Max | ||
BELOW_MIN_ACTION_CODE | CHAR | (3) | Below Spec Min Action Code | |
ABOVE_MIN_ACTION_CODE | CHAR | (3) | Above Spec Min Action Code | |
OPTIONAL_IND | CHAR | (3) | Optional Test Indicator | |
DISPLAY_PRECISION | NUMBER | Numeric Display Precision | ||
REPORT_PRECISION | NUMBER | Numeric Reporting Precision | ||
TEST_PRIORITY | CHAR | (3) | Test Priority | |
RETEST_LOT_EXPIRY_IND | CHAR | (3) | Retest Lot Expiry Indicator | |
PRINT_SPEC_IND | CHAR | (3) | Print Spec Indicator | |
PRINT_RESULT_IND | CHAR | (3) | Print Result Indicator | |
BELOW_MAX_ACTION_CODE | CHAR | (3) | Below Spec Max Action Code | |
ABOVE_MAX_ACTION_CODE | CHAR | (3) | Above Spec Max Action Code | |
TEST_DISPLAY | CHAR | (3) | Test Display | |
TEST_CODE | CHAR | (3) | Test Code | |
TEST_DESC | CHAR | (3) | Test Description | |
TEST_OPRN_LINE_ID | NUMBER | Test Opration Line ID | ||
TEST_CLASS | CHAR | (3) | Test Class | |
TEST_TYPE_DESC | CHAR | (3) | Test Type Description | |
TEST_UNIT | CHAR | (3) | QC Test Unit Code | |
TEST_MIN_VALUE | NUMBER | Test Min Value | ||
TEST_MAX_VALUE | NUMBER | Test Max Value | ||
EXPRESSION | CHAR | (3) | Expression | |
TEST_METHOD_CODE | CHAR | (3) | Test Method Code | |
TEST_METHOD_DESC | CHAR | (3) | Test Method Description | |
TEST_DURATION | NUMBER | Test Duration | ||
RESOURCES | CHAR | (3) | Resources | |
EVALUATION_IND | CHAR | (3) | Evaluation Indicator | |
EVALUATION_IND_DISP | CHAR | (3) | Evaluation Indicator Meaning resolved using GEM LOOKUPS | |
SPEC_RSLT_ACT_CODE | CHAR | (3) | Action to be taken | |
IN_SPEC_IND_DISP | CHAR | (3) | In Spec Indicator Meaning resolved using GEM LOOKUPS | |
VALUE_IN_REPORT_PRECISION | NUMBER | Value in Report Precision | ||
EVENT_SPEC_DISP_ID | NUMBER | Unique Identifier for Event Spec Disposition | ||
EVENT_SPEC_DISP_SMP_EVT_ID | NUMBER | Sampling Event Id | ||
EVENT_SPEC_VR_ID | NUMBER | Spec Validity Rule Identifier | ||
EVENT_SPEC_DISP | CHAR | (3) | Event Spec Disposition | |
SPEC_USED_FOR_LOT_ATTRIB_IND | CHAR | (1) | Current Spec Results used to set Lot Attributes | |
EVT_SPEC_LOT_ATTR_IND_DISP | CHAR | (3) | Current Spec Results used to set Lot Attributes Meaning | |
EVT_SPEC_DISP_DEL_MARK | CHAR | (3) | Event Spec Disp delete Mark | |
SPEC_TARGET_MEANING | CHAR | (3) | Spec Traget Meaning resolved using est Values | |
SPEC_MIN_MEANING | CHAR | (3) | Spec Min Meaning resolved using Test Values | |
SPEC_MAX_MEANING | CHAR | (3) | Spec Max Meaning resolved using Test Values | |
TEST_MIN_MEANING | CHAR | (3) | Test Level Min resolved using Test Values | |
TEST_MAX_MEANING | CHAR | (3) | Test Level Max resolved using Test Values |
APPS.PMITS_QC_RESULTS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SAMPLING_EVENT_ID | NUMBER | Y | Unique Identifier for Sampling Event | |
STEP_NO | NUMBER | Step Number | ||
STEP_ID | NUMBER | Unique Identifier for Step | ||
SAMPLE_ID | NUMBER | Y | Unique Identifier for Sample | |
SAMPLE_NO | VARCHAR2 | (80) | Y | Sample Number |
SAMPLE_DESC | VARCHAR2 | (80) | Sample Description | |
QC_LAB_ORGN_CODE | VARCHAR2 | (4) | LAB Organization Code | |
ITEM_ID | NUMBER | Unique Identifier for Item | ||
LOCATION | VARCHAR2 | (16) | Location | |
EXPIRATION_DATE | DATE | Expiration Date | ||
LOT_ID | NUMBER | Unique Identifier for Lot | ||
LOT_NO | VARCHAR2 | (32) | Lot Number | |
BATCH_ID | NUMBER | Unique Identifier for Production Batch | ||
RECIPE_ID | NUMBER | Unique Identifier for Recipe | ||
FORMULA_ID | NUMBER | Unique Identifier for Formula | ||
FORMULALINE_ID | NUMBER | Unique Identifier for Formula Line | ||
ROUTING_ID | NUMBER | Unique Identifier for Routing | ||
OPRN_ID | NUMBER | Unique Identifier for Operation | ||
CHARGE | NUMBER | Charge | ||
CUST_ID | NUMBER | Unique Identifier for Customer | ||
ORDER_ID | NUMBER | Unique Identifier for Sales Order | ||
ORDER_LINE_ID | NUMBER | Unique Identifier for Sales Order Line | ||
ORG_ID | NUMBER | Unique Identifier for Operating Unit | ||
SUPPLIER_ID | NUMBER | Unique Identifier for Supplier | ||
SAMPLE_QTY | NUMBER | Sample Qty | ||
SAMPLE_UOM | VARCHAR2 | (4) | Sample UOM | |
SOURCE | VARCHAR2 | (1) | Y | Sample Source |
SOURCE_DISP | VARCHAR2 | (80) | Y | Sample Source Meaning W-WIP, I-Inventory,C-Customer and S-Supplier |
SAMPLER_ID | NUMBER | Y | Sample Take by | |
DATE_DRAWN | DATE | Sample Drawn On | ||
SOURCE_COMMENT | VARCHAR2 | (1024) | Source Comment | |
STORAGE_WHSE | VARCHAR2 | (4) | Storage warehouse | |
STORAGE_LOCATION | VARCHAR2 | (16) | Storage Location | |
EXTERNAL_ID | VARCHAR2 | (32) | External ID | |
SAMPLE_APPROVER_ID | VARCHAR2 | (30) | Sample Approver | |
INV_APPROVER_ID | VARCHAR2 | (30) | Inventory Approver | |
PRIORITY | VARCHAR2 | (2) | Priority | |
SAMPLE_INV_TRANS_IND | VARCHAR2 | (1) | Update Inventory Qty Indicator | |
SAMPLE_INV_TRANS_IND_DISP | VARCHAR2 | (80) | Update Inventory Qty Indicator Meaning | |
DELETE_MARK | NUMBER | (5) | Y | Marked for Purge |
DELETE_MARK_DISP | VARCHAR2 | (80) | 0-No, 1-Yes | |
SUPPLIER_SITE_ID | NUMBER | Unique Identifier for Supplier Site | ||
WHSE_CODE | VARCHAR2 | (4) | Warehouse Code | |
ORGN_CODE | VARCHAR2 | (4) | Organization Code | |
PO_HEADER_ID | NUMBER | Unique Identifier for Purchase order Header | ||
PO_LINE_ID | NUMBER | Unique Identifier for Purchase Order Line | ||
RECEIPT_ID | NUMBER | Unique Identifier for Receipt | ||
RECEIPT_LINE_ID | NUMBER | Unique Identifier for Receipt Line | ||
SHIP_TO_SITE_ID | NUMBER | Unique Identifier for Ship to Site | ||
SUPPLIER_LOT_NO | VARCHAR2 | (32) | Supplier Lot Number | |
LOT_RETEST_IND | VARCHAR2 | (1) | Lot Retest Indicator | |
SAMPLE_INSTANCE | NUMBER | Sample Instance. This need be looked at in conjunction with Sampling Events Number of Samples | ||
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
SUPPLIER_CODE | VARCHAR2 | (30) | Supplier Code | |
SUPPLIER_NAME | VARCHAR2 | (240) | Supplier name | |
SUPPLIER_SITE | VARCHAR2 | (15) | Supplier Site | |
PO_NUMBER | VARCHAR2 | (20) | Purchase Order Number | |
PO_LINE_NUMBER | NUMBER | Purchase Order Line number | ||
RECEIPT_NUMBER | VARCHAR2 | (30) | Receipt Number | |
RECEIPT_LINE_NUMBER | NUMBER | Receipt Line | ||
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
OPERATING_UNIT_NAME | VARCHAR2 | (240) | Operating Unit Name | |
SHIP_TO_SITE_NAME | VARCHAR2 | (40) | Ship to Site Name | |
ORDER_NUMBER | NUMBER | Sales Order Number | ||
ORDER_TYPE | VARCHAR2 | (30) | Sales Order Type | |
ORDER_LINE_NUMBER | NUMBER | Sales Order Line Number | ||
BATCH_NO | VARCHAR2 | (32) | Production Batch Number | |
PLANT_CODE | VARCHAR2 | (4) | Plant Code | |
FORMULA_NO | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERS | NUMBER | Formula Version | ||
OPRN_NO | VARCHAR2 | (16) | Operation Number | |
OPRN_VERS | NUMBER | (5) | Operation Version | |
RECIPE_NO | VARCHAR2 | (32) | Recipe Number | |
RECIPE_VERSION | NUMBER | (5) | Recipe version | |
ROUTING_NO | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERS | NUMBER | (5) | Routing Version | |
SAMPLE_SPEC_DISPOSITION | VARCHAR2 | (80) | Y | Sample Spec Disposition |
SPEC_NAME | VARCHAR2 | (80) | Sapec Name | |
SPEC_VERS | NUMBER | (10) | Spec Version | |
SPEC_USED_FOR_LOT_ATTRIB_IND | VARCHAR2 | (1) | Current Spec Results used to set Lot Attributes |
APPS.PMITS_QC_SAMPLES_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPEC_ID | NUMBER | Unique Identifier for Spec | ||
TEST_ID | NUMBER | Unique Identifier for Test | ||
TEST_METHOD_ID | NUMBER | Unique Identifier for Test method | ||
SEQ | NUMBER | Test Sequence | ||
TEST_METHOD_CODE | CHAR | (3) | Test Method Code | |
TEST_REPLICATE | NUMBER | Replicate | ||
TEST_QTY | NUMBER | Test Qty | ||
TEST_UOM | CHAR | (3) | Test UOM | |
SPEC_MIN_VALUE | CHAR | (3) | Spec Min. This includes both Spec Min Char and Num | |
SPEC_TARGET_VALUE | CHAR | (3) | Spec Target.This includes both Spec Target Char and Num | |
SPEC_MAX_VALUE | CHAR | (3) | Spec Max. This includes both Spec Max Char and Num | |
MIN_VALUE_NUM | NUMBER | Spec Numeric Min | ||
TARGET_VALUE_NUM | NUMBER | Spec Target Numeric | ||
MAX_VALUE_NUM | NUMBER | Spec Max Numeric | ||
MIN_VALUE_CHAR | CHAR | (3) | Spec Min Char | |
TARGET_VALUE_CHAR | CHAR | (3) | Spec Target Char | |
MAX_VALUE_CHAR | CHAR | (3) | Spec Max Char | |
BELOW_SPEC_MIN | NUMBER | Below Spec Min | ||
ABOVE_SPEC_MIN | NUMBER | Above Spec Min | ||
BELOW_SPEC_MAX | NUMBER | Below Spec Max | ||
ABOVE_SPEC_MAX | NUMBER | Above Spec Max | ||
BELOW_MIN_ACTION_CODE | CHAR | (3) | Below Spec Min Action Code | |
ABOVE_MIN_ACTION_CODE | CHAR | (3) | Above Spec Min Action Code | |
BELOW_MAX_ACTION_CODE | CHAR | (3) | Below Spec Max Action Code | |
ABOVE_MAX_ACTION_CODE | CHAR | (3) | Above Spec Max Action Code | |
OPTIONAL_IND | CHAR | (3) | Optional Test Indicator | |
DISPLAY_PRECISION | NUMBER | Numeric Result Display Precision | ||
REPORT_PRECISION | NUMBER | Numeric Result Reporting Precision | ||
OUT_OF_SPEC_ACTION | CHAR | (3) | Out of spec Action | |
TEST_PRIORITY | CHAR | (3) | Test Priority | |
RETEST_LOT_EXPIRY_IND | CHAR | (3) | Lot Retest / Expiry Indicator | |
EXP_ERROR_TYPE | CHAR | (3) | Experimental Error Type | |
PRINT_SPEC_IND | CHAR | (3) | Print Spec Indicator | |
PRINT_RESULT_IND | CHAR | (3) | Print Result Indicator | |
TEST_DISPLAY | CHAR | (3) | Test Display | |
TEXT_CODE | NUMBER | Test Code | ||
OUT_OF_SPEC_ACTION_DESC | CHAR | (3) | Out of spec Action Description | |
OUT_OF_SPEC_ACTION_INTERVAL | NUMBER | Out of Spec Action Interval | ||
EXPRESSION | CHAR | (3) | Expression | |
TEST_CODE | CHAR | (3) | Test Code | |
TEST_DESC | CHAR | (3) | Test Description | |
TEST_UNIT | CHAR | (3) | QC Unit Code | |
TEST_TYPE | CHAR | (3) | Test Type | |
TEST_TYPE_DESC | CHAR | (3) | Test Type meaning resolved using GEM LOOKUPS | |
TEST_CLASS | CHAR | (3) | Test Class | |
TEST_MIN_VALUE | NUMBER | Min Value allowed as per test definition | ||
TEST_MAX_VALUE | NUMBER | Max Value allowed as per test definition | ||
SPEC_TARGET_MEANING | CHAR | (3) | Target Meaning | |
SPEC_MIN_MEANING | CHAR | (3) | Spec Min Meaning | |
SPEC_MAX_MEANING | CHAR | (3) | Spec Max Meaning | |
TEST_MIN_MEANING | CHAR | (3) | Test Min Meaning | |
TEST_MAX_MEANING | CHAR | (3) | Test Max Meaning |
APPS.PMITS_QC_SPEC_TESTS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEST_ID | NUMBER | Y | Test Identifier | |
TEST_CODE | VARCHAR2 | (80) | Y | Unique Test Code |
TEST_DESC | VARCHAR2 | (240) | Y | Test Description |
TEST_METHOD_ID | NUMBER | Y | Identifier which Identifies Test Method | |
TEST_OPRN_LINE_ID | NUMBER | |||
TEST_PROVIDER_CODE | VARCHAR2 | (8) | ||
TEST_CLASS | VARCHAR2 | (8) | Test Class | |
TEST_CLASS_DESC | VARCHAR2 | (80) | ||
TEST_TYPE | VARCHAR2 | (1) | Y | Test Type of result validation |
TEST_UNIT | VARCHAR2 | (25) | Test Unit. This is kind of UOM for test. | |
MIN_VALUE_NUM | NUMBER | Min Numeric Value allowed for this Test | ||
MAX_VALUE_NUM | NUMBER | Max Numeric Value allowed for this Test | ||
EXP_ERROR_TYPE | VARCHAR2 | (1) | Experimental Error Type | |
BELOW_SPEC_MIN | NUMBER | Below Spec min | ||
ABOVE_SPEC_MIN | NUMBER | Above spec min | ||
BELOW_SPEC_MAX | NUMBER | Below Spec max | ||
ABOVE_SPEC_MAX | NUMBER | Above Spec max | ||
BELOW_MIN_ACTION_CODE | VARCHAR2 | (32) | Action code for Below Spec min | |
ABOVE_MIN_ACTION_CODE | VARCHAR2 | (32) | Action code for Above Spec min | |
BELOW_MAX_ACTION_CODE | VARCHAR2 | (32) | Action code for Below Spec max | |
ABOVE_MAX_ACTION_CODE | VARCHAR2 | (32) | Action code for Above Spec max | |
EXPRESSION | VARCHAR2 | (4000) | Expression | |
DISPLAY_PRECISION | NUMBER | (2) | Dispaly Precision for Numeric Values | |
REPORT_PRECISION | NUMBER | (2) | Reporting Precision for Numeric Values | |
PRIORITY | VARCHAR2 | (2) | Priority allowed values Low,Normal and High | |
TEST_OPRN_ID | NUMBER | |||
MIN_NUM | NUMBER | Min Value for Numeric Range display label | ||
MAX_NUM | NUMBER | Max Value for Numeric Range display label | ||
DISPLAY_LABEL_NUMERIC_RANGE | VARCHAR2 | (240) | Numeric Range display Label | |
TEST_VALUE_DESC | VARCHAR2 | (240) | Description for Text values | |
VALUE_CHAR | VARCHAR2 | (16) | Text Value | |
TEXT_RANGE_SEQ | NUMBER | Text Range Seq | ||
EXPRESSION_REF_TEST_ID | NUMBER | Reference Test Id for Expression |
APPS.PMITS_QC_TESTS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECIPE_ID | NUMBER | Recipe ID | ||
RECIPE_DESCRIPTION | CHAR | (3) | Recipe Description | |
RECIPE_NO | CHAR | (3) | Recipe Number | |
RECIPE_VERSION | NUMBER | Recipe Version | ||
OWNER_ORGN_CODE | CHAR | (3) | Owner Organization Code | |
CREATION_ORGN_CODE | CHAR | (3) | ||
FORMULA_ID | NUMBER | |||
ROUTING_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
RECIPE_STATUS | CHAR | (3) | ||
PLANNED_PROCESS_LOSS | NUMBER | |||
TEXT_CODE | CHAR | (3) | ||
DELETE_MARK | NUMBER | |||
OWNER_ID | NUMBER | |||
OWNER_LAB_TYPE | CHAR | (3) | ||
CALCULATE_STEP_QUANTITY | CHAR | (3) | ||
OWNER | CHAR | (3) | ||
FORMULA_NO | CHAR | (3) | ||
FORMULA_VERS | NUMBER | |||
RECIPE_UOM | CHAR | (3) | ||
TOTAL_OUTPUT_QTY | NUMBER | |||
ROUTING_NO | CHAR | (3) | ||
ROUTING_VERS | NUMBER | |||
PRODUCT | CHAR | (3) | ||
PRODUCT_UOM | CHAR | (3) | ||
PRODUCT_QTY | NUMBER | |||
STATUS | CHAR | (3) |
APPS.PMITS_RECIPE_MASTER_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECIPE_VALIDITY_RULE_ID | NUMBER | (15) | Y | Recipe Validity Rule ID |
RECIPE_ID | NUMBER | (15) | Y | Recipe ID |
ORGN_CODE | VARCHAR2 | (4) | Organization Code | |
ITEM_ID | NUMBER | (15) | Item ID | |
RECIPE_USE | VARCHAR2 | (80) | Y | Recipe Use |
PREFERENCE | NUMBER | (15) | Y | Preference |
START_DATE | DATE | Y | Start Date | |
END_DATE | DATE | End Date | ||
MIN_QTY | NUMBER | Y | Min Qty | |
MAX_QTY | NUMBER | Y | Max Qty | |
STD_QTY | NUMBER | Y | Standard Qty | |
ITEM_UM | VARCHAR2 | (4) | Item UOM | |
INV_MIN_QTY | NUMBER | Y | The minimum qty for which this Validity Rule can be used, expressed in the primary UOM of an item. | |
INV_MAX_QTY | NUMBER | Y | The maximum qty for which this Validity Rule can be used, expressed in the primary UOM of an item | |
TEXT_CODE | NUMBER | (10) | Text Code | |
DELETE_MARK | NUMBER | (5) | Y | Delete Mark |
VALIDITY_RULE_STATUS | VARCHAR2 | (30) | Y | Validity Rule Status |
LAB_TYPE | VARCHAR2 | (4) | Lab Type | |
RECIPE_NO | VARCHAR2 | (32) | Y | Recipe Number |
RECIPE_VERSION | NUMBER | (5) | Y | Recipe Version |
ITEM_NO | VARCHAR2 | (32) | Y | Item Number |
ITEM_DESC1 | VARCHAR2 | (70) | Y | Item Description |
FORMULA_NO | VARCHAR2 | (32) | Y | Formula Number |
FORMULA_VERS | NUMBER | Y | Formula Version | |
ROUTING_NO | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERS | NUMBER | (5) | Routing Version | |
STATUS | VARCHAR2 | (80) | Y |
APPS.PMITS_RECIPE_VALIDITY_RULE_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTING_ID | NUMBER | (10) | Y | Routing ID |
ROUTINGSTEP_ID | NUMBER | (10) | Y | Routing Step ID |
ROUTINGSTEP_NO | NUMBER | (5) | Y | Routing Step Number |
OPRN_ID | NUMBER | (10) | Y | Operation ID in this Routing Step |
STEP_QTY | NUMBER | Y | Step Quantity | |
STEPRELEASE_TYPE | VARCHAR2 | (80) | Y | Step Release Type |
TEXT_CODE | NUMBER | (10) | Text Code |
APPS.PMITS_ROUTING_DETAIL_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTING_ID | NUMBER | Routing ID | ||
ROUTING_NO | CHAR | (3) | Routing Number | |
ROUTING_VERS | NUMBER | Routing Version | ||
ROUTING_CLASS | CHAR | (3) | Routing Class | |
ROUTING_QTY | NUMBER | Routing Quantity | ||
ROUTING_STATUS | CHAR | (3) | Routing Status | |
ROUTING_DESC | CHAR | (3) | Routing Description | |
ITEM_UM | CHAR | (3) | Item UOM | |
DELETE_MARK | NUMBER | Delete Mark | ||
TEXT_CODE | NUMBER | Text Code | ||
INACTIVE_IND | CHAR | (3) | Inactive Indicator | |
EFFECTIVE_START_DATE | DATE | Effective Start Date | ||
EFFECTIVE_END_DATE | DATE | Effective End Date | ||
OWNER_ID | NUMBER | Owner ID | ||
PROJECT_ID | NUMBER | Project ID | ||
PROCESS_LOSS | NUMBER | Process Loss | ||
OWNER | CHAR | (3) | Owner Name | |
DESCRIPTION | CHAR | (3) | Owner Display Name | |
OWNER_ORGN_CODE | CHAR | (3) | Owner Organization Code | |
ROUTING_CLASS_DESC | CHAR | (3) | Routing Class Description | |
STATUS | CHAR | (3) | Routing Status |
APPS.PMITS_ROUTING_MASTER_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SOURCE | NUMBER | |||
SUBLEDGER_ID | NUMBER | Subsidiary ledger key. | ||
CO_CODE | VARCHAR2 | (4) | Company of transaction. | |
FISCAL_YEAR | NUMBER | Fiscal year of gl posting. | ||
PERIOD | NUMBER | Period of gl posting. | ||
SUB_EVENT_CODE | VARCHAR2 | (4) | ||
VOUCHER_ID | NUMBER | GL journal voucher identifier. | ||
DOC_TYPE | VARCHAR2 | (4) | Document type. | |
DOC_ID | NUMBER | Document identifier within doc type. | ||
JOIN_DOC_ID | NUMBER | This will have actual Document id for XFER,TRNI,TRNR,MTRI | ||
LINE_ID | NUMBER | Detail line identifier. | ||
ACCT_TTL_CODE | VARCHAR2 | (4) | ||
ACCTG_UNIT_NO | VARCHAR2 | (240) | OPM Accounting unit Description. | |
ACCT_NO | VARCHAR2 | (240) | OPM Account Description. | |
DEBIT_CREDIT_SIGN | NUMBER | Debit or Credit indicator for the Amounts: -1=credit; =1=debit. | ||
ACCTG_UNIT_DESC | VARCHAR2 | (70) | ||
ACCT_DESC | VARCHAR2 | (70) | ||
AMOUNT_BASE | NUMBER | GL amount in Base currency. | ||
AMOUNT_TRANS | NUMBER | GL amount in Transaction currency. | ||
CURRENCY_BASE | VARCHAR2 | (4) | Base currency of transaction. | |
CURRENCY_TRANS | VARCHAR2 | (4) | Currency of transaction. | |
JV_QUANTITY | NUMBER | Quantity of GL Account. | ||
JV_QUANTITY_UM | VARCHAR2 | (4) | Unit of measure of quantity. | |
SUB_EVENT_DESC | VARCHAR2 | (70) | Sub Event Description. | |
TRANS_SOURCE_CODE | VARCHAR2 | (4) | Abbreviation assigned to subsystem | |
TRANS_SOURCE_DESC | VARCHAR2 | (70) | subsystem description | |
GL_TRANS_DATE | DATE | GL transaction date. | ||
ORGN_CODE | VARCHAR2 | (16) | Organization of transaction. | |
DOC_NO | VARCHAR2 | (40) | Document Number. | |
DOC_DATE | DATE | Document Transaction Date. | ||
LINE_NO | VARCHAR2 | (150) | Detail line Number. | |
RESOURCE_ITEM_NO | VARCHAR2 | (32) | Item Number. | |
RESOURCE_ITEM_NO_DESC | VARCHAR2 | (240) | Item Description. | |
TRANS_DATE | DATE | Transaction Date. | ||
WHSE_CODE | VARCHAR2 | (4) | Warehouse Code | |
TRANS_QTY_USAGE | NUMBER | Transaction Qty Usage | ||
TRANS_QTY_USAGE_UM | VARCHAR2 | (25) | Transaction Qty Usage UOM | |
REFERENCE_NO | NUMBER | The Subsidiary Ledger Run reference number. | ||
TRANS_TYPE | VARCHAR2 | (11) | Transaction Type. This column is used to join subsidiary ledger data with inventory data |
APPS.PMITS_TEST_SUBLEDGER_V is not referenced by any database object
A Business Intelligence System view
PMI Warehouse Master view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WHSE_CODE | VARCHAR2 | (4) | Y | Code for the warehouse. |
WHSE_NAME | VARCHAR2 | (40) | Y | Name of the warehouse. |
ORGN_CODE | VARCHAR2 | (4) | Y | Organization that owns the warehouse. |
LOCT_CTL | NUMBER | (5) | Y | Location control indicator. 0=Warehouse is not location controlled,1=Validated location control, 2=Non-validated location control. |
LOCT_CTL_DISP | VARCHAR2 | (80) | Y | Location control indicator code resolved using lookup |
ADDR_ID | NUMBER | (10) | Surrogate key to the address of the warehouse. | |
CONSIGN_IND | NUMBER | (5) | Y | Consignment indicator. 0=Not a consigment warehouse, 1=Consignment warehouse. |
CONSIGN_IND_DISP | VARCHAR2 | (80) | Y | Consignment indicator code resolved using lookup. |
REGION_CODE | VARCHAR2 | (8) | Region code | |
WHSE_CLASS | VARCHAR2 | (8) | Warehouse class. | |
WHSE_CONTACT | VARCHAR2 | (40) | Contact person at the warehouse. | |
WHSE_PHONE | VARCHAR2 | (20) | Phone number | |
TAXLOC_CODE | VARCHAR2 | (10) | Tax location of warehouse. | |
LAST_UPDATE_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column |
CREATION_DATE | DATE | Y | Standard who column | |
CREATED_BY | NUMBER | (15) | Y | Standard who column |
DELETE_MARK | NUMBER | (5) | Y | Standard: 0=Active record (default); 1=Marked for (logical) deletion |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
INGREDIENT_STAGE | VARCHAR2 | (16) | Staging location for ingredients | |
PRODUCT_STAGE | VARCHAR2 | (16) | Staging location for products | |
RECV_STAGE | VARCHAR2 | (16) | Staging location for receiving. Acts as default location for receiving allocations | |
SHIP_STAGE | VARCHAR2 | (16) | Staging location for shipping. Acts as default location for shipment allocations | |
MTL_ORGANIZATION_ID | NUMBER | MTL Parameters Table Organization ID | ||
MTL_ORGANIZATION_CODE | VARCHAR2 | (3) | MTL Parameters Table Organization Code |
APPS.PMITS_WAREHOUSE_MASTER_V is not referenced by any database object
A Business Intelligence System view
Allocation Class List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALLOC_CLASS | VARCHAR2 | (8) | Allocation Class | |
ALLOC_DESC | VARCHAR2 | (70) | Allocation Description |
APPS.PMI_ALOC_CLS_LOV_V is not referenced by any database object
A Business Intelligence System view
Allocation Class List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALLOC_CLASS | VARCHAR2 | (8) | Allocation Class | |
ALLOC_DESC | VARCHAR2 | (70) | Allocation Description |
APPS.PMI_ALOC_CLS_V is not referenced by any database object
A Business Intelligence System view
Cost Method List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COST_MTHD_CODE | VARCHAR2 | (10) | Y | Cost Method Code |
COST_MTHD_DESC | VARCHAR2 | (40) | Y | Cost Method Description |
APPS.PMI_COST_MTHD_LOV_V is not referenced by any database object
A Business Intelligence System view
Cost Method List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COST_MTHD_CODE | VARCHAR2 | (10) | Y | Cost Method Code |
COST_MTHD_DESC | VARCHAR2 | (40) | Y | Cost Method Description |
APPS.PMI_COST_MTHD_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | Y | |
PERIOD_TYPE | VARCHAR2 | (15) | Y | |
PERIOD_YEAR | NUMBER | (15) | Y | |
QUARTER_NUM | NUMBER | (15) | Y | |
PERIOD_NUM | NUMBER | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
START_DATE | DATE | Y | ||
END_DATE | DATE | Y |
A Business Intelligence System view
View to get GL Calendar Period, Quarter and Year level data from GL Periods
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
YEAR_NAME | VARCHAR2 | (15) | Y | |
YEAR_START_DATE | DATE | Y | ||
YEAR_END_DATE | DATE | Y | ||
QUARTER_NAME | VARCHAR2 | (15) | Y | |
QUARTER_START_DATE | DATE | Y | ||
QUARTER_END_DATE | DATE | Y | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
PERIOD_START_DATE | DATE | Y | ||
PERIOD_END_DATE | DATE | Y | ||
PERIOD_NUM | NUMBER | (15) | Y | |
QUARTER_NUM | NUMBER | (15) | Y | |
PERIOD_YEAR | NUMBER | (15) | Y | |
YEAR_ID | VARCHAR2 | (31) | ||
QUARTER_ID | VARCHAR2 | (31) | ||
PERIOD_ID | VARCHAR2 | (31) |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | (15) | Y | Party identifier |
PARTY_NUMBER | VARCHAR2 | (30) | Y | Unique identification number for this party |
PARTY_NAME | VARCHAR2 | (360) | Y | Name of this party |
PARTY_TYPE | VARCHAR2 | (30) | Y | The party type can only be Person, Organization, Group or Relationship. |
PARTY_CITY | VARCHAR2 | (60) | City of the Identifying address | |
PARTY_STATE | VARCHAR2 | (60) | State of the Identifying address | |
PARTY_COUNTRY | VARCHAR2 | (60) | The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address. | |
LOCATION_ID | NUMBER | (15) | Y | Unique identifier for this location |
SITE_USE_ID | NUMBER | (15) | Y | Site use identifier |
PARTY_SITE_NUMBER | VARCHAR2 | (30) | Y | Party site number |
PARTY_SITE_NAME | VARCHAR2 | (240) | User-defined name for the site | |
PARTY_SITE_CITY | VARCHAR2 | (60) | City | |
PARTY_SITE_STATE | VARCHAR2 | (60) | State | |
PARTY_SITE_COUNTRY | VARCHAR2 | (60) | Y | Country code from the TERRITORY_CODE column in the FND_TERRITORY table |
A Business Intelligence System view
Inventory Calendar View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGN_CODE | VARCHAR2 | (4) | Y | Organization Code |
FISCAL_YEAR | VARCHAR2 | (4) | Y | Fiscal Year from GL calendar |
PERIOD_ID | NUMBER | (10) | Y | Period ID |
PERIOD | NUMBER | (5) | Y | Period from GL calendar |
CALENDAR_DESC | VARCHAR2 | (40) | Y | Calendar |
CLOSED_YEAR_IND | NUMBER | (5) | Y | ClosedYear Indicator |
CURRENT_YEAR_IND | NUMBER | (5) | Y | Current Year Indicator |
CLOSED_PERIOD_IND | NUMBER | (5) | Y | Closed Period Indicator |
CURRENT_PERIOD_IND | NUMBER | (5) | Y | Current Period Indicator |
PERIOD_TYPE | NUMBER | (5) | Y | Period Type can have Year/Quarter/Period as value |
PERIOD_DESC | VARCHAR2 | (40) | Y | Period Description |
END_DATE | DATE | Y | End Date for the period type | |
START_DATE | DATE | Start Date for the period type | ||
CREATION_DATE | DATE | Y | Creation date | |
LAST_UPDATE_DATE | DATE | Y | Last Updated date |
A Business Intelligence System view
Inventory Class List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ICINV_CLASS | VARCHAR2 | (8) | Inventory Class | |
ICINV_CLASS_DESC | VARCHAR2 | (70) | Inventory Class Description |
APPS.PMI_INV_CLS_LOV_V is not referenced by any database object
A Business Intelligence System view
Inventory Class List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ICINV_CLASS | VARCHAR2 | (8) | Inventory Class | |
ICINV_CLASS_DESC | VARCHAR2 | (70) | Inventory Class Description |
APPS.PMI_INV_CLS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | (10) | Y | Item ID |
VALUE | VARCHAR2 | (32) | Y | Item Number |
ITEM_NUMBER | VARCHAR2 | (32) | Y | Item Number |
APPS.PMI_ITEM_LOV_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
START_ITEM_ID | NUMBER | item_id of the a start-lot | ||
START_LOT_ID | NUMBER | Y | lot_id of the start-lot | |
SHARED_ITEM_ID | NUMBER | item_id of lot sharing ingredient lot with start-lot | ||
SHARED_LOT_ID | NUMBER | Y | lot_id of lot sharing ingredient lot with start lot |
A Business Intelligence System view
This view lists raw material lots that are used in the manufacture of a product lot.
In this context, a raw material lot is any lot that cannot be further decomposed
into a lower level of constituent ingredients.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_ITEM_ID | NUMBER | item_id of a product lot | ||
PRODUCT_LOT_ID | NUMBER | Y | lot_id of a product lot | |
INGRED_ITEM_ID | NUMBER | item_id of a raw material lot of the product lot | ||
INGRED_LOT_ID | NUMBER | Y | lot_id of a raw material lot of the product lot |
A Business Intelligence System view
Planning Class List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANNING_CLASS | VARCHAR2 | (8) | Planning Class | |
PLANNING_CLASS_DESC | VARCHAR2 | (70) | Planning Class description |
APPS.PMI_PLNG_CLS_LOV_V is not referenced by any database object
A Business Intelligence System view
Planning Class List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANNING_CLASS | VARCHAR2 | (8) | Planning Class | |
PLANNING_CLASS_DESC | VARCHAR2 | (70) | Planning Class description |
APPS.PMI_PLNG_CLS_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | Y | OPM Company Code |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
WAREHOUSE_ID | VARCHAR2 | (4) | Y | OPM Warehouse Code |
CONV_ONHAND | NUMBER | Current On-hand Quantity Converted into PMI Global UOM for Lot contolled Items | ||
CUR_OHD_VAL | NUMBER | |||
CONV_EXP_QTY | NUMBER | Current Expired Quantity Converted into PMI Global UOM for Lot contolled Items | ||
CUR_EXP_VAL | NUMBER | Current Expired Inventory Value for Lot contolled Items |
APPS.PMI_REP_EXP_INVENTORY_V is not referenced by any database object
A Business Intelligence System view
PMI Gross Margin Report view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OPERATING_UNIT_ID | NUMBER | (15) | Operating Unit ID | |
SALES_COMPANY | VARCHAR2 | (4) | Sales Company | |
SALES_ORGANIZATION | VARCHAR2 | (4) | Sales Organization | |
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year | |
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter | |
PERIOD_ID | VARCHAR2 | (31) | Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period | |
REVENUE | NUMBER | Sales Revenue in Base Currency | ||
DISCOUNT | NUMBER | Charges or Discounts in Base Currency | ||
COGS | NUMBER | Cost of Goods Sold in Base Currency | ||
MARGIN | NUMBER | Margin in Base Currency |
APPS.PMI_REP_GROSS_MARGIN_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | Y | Key to map Process Manufacturing Company PMF Dimension Value |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | Key to map Process Manufacturing Organization PMF Dimension Value |
YEAR_ID | VARCHAR2 | (31) | Key to map Year Level PMF Time Dimension Value | |
QUARTER_ID | VARCHAR2 | (31) | Key to map Quarter Level PMF Time Dimension Value | |
PERIOD_ID | VARCHAR2 | (31) | Key to map Period Level PMF Time Dimension Value | |
TOT_NO_BTCHS | NUMBER | This column will have 1 as its value | ||
LATE_BTCHS | NUMBER | This column will have 1 as its value batch is late |
APPS.PMI_REP_LATE_BATCHES_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | OPM Company Code | |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
WAREHOUSE_ID | VARCHAR2 | (4) | Y | OPM Warehouse Code |
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year | |
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter | |
PERIOD_ID | VARCHAR2 | (31) | Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period | |
ITEM_ID | NUMBER | (10) | Y | Item ID |
UOM | VARCHAR2 | (4) | PMI Global UOM | |
WHSE_ONHAND_QTY | NUMBER | |||
WHSE_ONHAND_CONV | NUMBER | |||
WHSE_ONHAND_VALUE | NUMBER | |||
WHSE_SALE_QTY | NUMBER | |||
WHSE_SALE_CONV | NUMBER | |||
WHSE_SALE_VALUE | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (40) | ||
S_DATE | DATE | Y | GL Period Start Date | |
E_DATE | DATE | Y | GL Period End Date |
APPS.PMI_REP_ONHAND_SALES_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | Y | OPM Company Code |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year | |
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter | |
PERIOD_ID | VARCHAR2 | (31) | Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period | |
LINE_TYPE | NUMBER | (5) | Y | Line Type -1 for Ingredient and 1 for Product |
ACTUAL_QTY | NUMBER | |||
PLAN_QTY | NUMBER | Batch Plan Quantity in PMI Global UOM |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | Y | OPM Company Code |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year | |
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter | |
PERIOD_ID | VARCHAR2 | (31) | Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period | |
PND_BATCHES | NUMBER | Number of Pending Batches | ||
PND_VALUE | NUMBER | Value of Pending Batches | ||
WIP_BATCHES | NUMBER | Number of WIP Batches | ||
WIP_VALUE | NUMBER | Value of WIP Batches | ||
CMP_BATCHES | NUMBER | Number of Completed Batches | ||
CMP_VALUE | NUMBER | Value of Completed Batches |
APPS.PMI_REP_PROD_STATUS_V is not referenced by any database object
A Business Intelligence System view
PMI Product Usage Variance Report view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | Y | OPM Company Code |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year | |
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter | |
PERIOD_ID | VARCHAR2 | (31) | Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period | |
ACTUAL_QTY | NUMBER | |||
PLAN_QTY | NUMBER |
APPS.PMI_REP_PROD_USG_VARANCE_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | Y | OPM Company Code |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year | |
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter | |
PERIOD_ID | VARCHAR2 | (31) | Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period | |
ACTUAL_QTY | NUMBER | |||
PLAN_QTY | NUMBER | Batch Ingredient Plan Quantity in PMI Global UOM |
APPS.PMI_REP_PROD_YLD_VARANCE_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FISCAL_YEAR | VARCHAR2 | (4) | Y | |
COMPANY_ID | VARCHAR2 | (4) | OPM Company Code | |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
WAREHOUSE_ID | VARCHAR2 | (4) | Y | OPM Warehouse Code |
ITEM_ID | NUMBER | (10) | Y | |
ITEM_NO | VARCHAR2 | (32) | ||
ITEM_UM | VARCHAR2 | (4) | ||
WHSE_ONHAND_QTY | NUMBER | |||
WHSE_ONHAND_CONV | NUMBER | |||
WHSE_ONHAND_VALUE | NUMBER | |||
WHSE_SALE_QTY | NUMBER | |||
WHSE_SALE_CONV | NUMBER | |||
WHSE_SALE_VALUE | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (40) | ||
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter |
APPS.PMI_REP_QTR_ONHAND_V is not referenced by any database object
MultiLingual view (a language resolved view of the data.)
PMI Sales Details Report view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | Item ID | |
ORDER_QUANTITY | NUMBER | Order Quantity | ||
WAREHOUSE_SHIPPED_FROM | VARCHAR2 | (4) | Warehouse Shipped From | |
EXTENDED_PRICE_BASE_CURRENCY | NUMBER | Extended Price Base Currency | ||
CHARGES_BASE_CURRENCY | NUMBER | Charges in Base Currency | ||
SALES_COMPANY | VARCHAR2 | (4) | Sales Company | |
SALES_ORGANIZATION | VARCHAR2 | (4) | Sales Organization | |
PERIOD_START_DATE | DATE | Period Start Date | ||
OPERATING_UNIT_ID | NUMBER | (15) | Operating Unit ID | |
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year | |
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter | |
PERIOD_ID | VARCHAR2 | (31) | Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | OPM Company Code | |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year | |
QUARTER_ID | VARCHAR2 | (31) | Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter | |
PERIOD_ID | VARCHAR2 | (31) | Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period | |
ITEM_ID | NUMBER | (10) | Y | |
UOM | VARCHAR2 | (4) | ||
QTY_PRODUCED | NUMBER | Yield Quantity in PMI Global UOM | ||
PROD_VALUE | NUMBER | Yield Value | ||
QTY_CONSUMED | NUMBER | Consumed Ingredient Quantity in PMI Global UOM | ||
INGD_VALUE | NUMBER |
APPS.PMI_REP_TOP_10_PROD_INGRD_V is not referenced by any database object
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FISCAL_YEAR | VARCHAR2 | (4) | Y | |
COMPANY_ID | VARCHAR2 | (4) | OPM Company Code | |
ORGANIZATION_ID | VARCHAR2 | (4) | Y | OPM Organization Code |
WAREHOUSE_ID | VARCHAR2 | (4) | Y | OPM Warehouse Code |
ITEM_ID | NUMBER | (10) | Y | |
ITEM_NO | VARCHAR2 | (32) | ||
ITEM_UM | VARCHAR2 | (4) | ||
WHSE_ONHAND_QTY | NUMBER | |||
WHSE_ONHAND_CONV | NUMBER | |||
WHSE_ONHAND_VALUE | NUMBER | |||
WHSE_SALE_QTY | NUMBER | |||
WHSE_SALE_CONV | NUMBER | |||
WHSE_SALE_VALUE | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (40) | ||
YEAR_ID | VARCHAR2 | (31) | Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year |
APPS.PMI_REP_YR_ONHAND_V is not referenced by any database object
A Business Intelligence System view
Unit of Measure List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UM_CODE | VARCHAR2 | (25) | Units of measure Code | |
UM_DESC | VARCHAR2 | (40) | Units of measure description |
APPS.PMI_UOM_LOV_V is not referenced by any database object
A Business Intelligence System view
Unit of Measure List Of Values View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
UM_CODE | VARCHAR2 | (25) | Units of measure Code | |
UM_DESC | VARCHAR2 | (40) | Units of measure description |
APPS.PMI_UOM_V is not referenced by any database object
A Business Intelligence System view
Warehouse Class view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | Y | Item Id |
ITEM_NO | VARCHAR2 | (32) | Y | Item number |
ITEM_DESC1 | VARCHAR2 | (70) | Y | Item Description |
APPS.PMI_WHSE_CLS_LOV_V is not referenced by any database object
A Business Intelligence System view
Warehouse Class view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ID | NUMBER | (10) | Y | Item Id |
ITEM_NO | VARCHAR2 | (32) | Y | Item number |
ITEM_DESC1 | VARCHAR2 | (70) | Y | Item Description |
APPS.PMI_WHSE_CLS_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |