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: | Resource availability information |
---|
CRP_AVAILABLE_RESOURCES stores resource availability information for
all departments/resources and lines used in a plan. Resource
availability is stored in this table for different date ranges in the
planning horizon.
RESOURCE_START_DATE and RESOURCE_END_DATE contain the date ranges for
which the resource availability information is applicable.
RESOURCE_HOURS stores the daily resource availability for routing
based resources. MAX_RATE column contains the maximum rate for
lines. The total daily availability is the product of RESOURCE_UNITS
and RESOURCE_HOURS for routing based resources. For lines, the
total daily availability is calculated as the MAX_RATE multiplied by
the RESOURCE_UNITS.
CRP_AVAILABLE_RESOURCES is populated by the snapshot and is used
by the planner. Data in this table can be viewed in the Planner's
Workbench.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_AVAILABLE_RESOURCES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
DEPARTMENT_ID RESOURCE_ID |
CRP_AVAILABLE_RESOURCES_N2 | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
LINE_ID |
CRP_AVAILABLE_RESOURCES_N3 | NONUNIQUE | APPS_TS_TX_IDX |
APPLIED
COMPILE_DESIGNATOR ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPILE_DESIGNATOR | VARCHAR2 | (20) | Y | MPS, MRP or DRP plan identifier |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
LINE_ID | NUMBER | Line identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
RESOURCE_ID | NUMBER | Resource identifier | ||
RESOURCE_HOURS | NUMBER | Daily availability of resource in hours | ||
MAX_RATE | NUMBER | Hourly maximum rate for line | ||
RESOURCE_UNITS | NUMBER | Number of units of the resource | ||
STATUS | NUMBER | Attribute for online replanning | ||
APPLIED | NUMBER | Attribute for online replanning | ||
RESOURCE_START_DATE | DATE | Y | Start date of resource availability | |
RESOURCE_END_DATE | DATE | End date of resource availability | ||
UPDATED | NUMBER | Y | Flag to determine whether add workday modification was applied | |
ORIGINAL_CAPACITY | NUMBER | Not currently used | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
CRP.CRP_AVAILABLE_RESOURCES does not reference any database object
CRP.CRP_AVAILABLE_RESOURCES is referenced by following:
Description: | Bill of resource sets |
---|
Foreign Key Column | Foreign Table |
---|---|
CRP_BILL_OF_RESOURCE_ITEMS.BILL_OF_RESOURCES
CRP_BILL_OF_RESOURCE_ITEMS.ORGANIZATION_ID |
CRP_BILLS_OF_RESOURCES |
CRP_BILLS_OF_RESOURCES stores the bills of resource sets. This table
is populated by the Define Bill of Resource Sets form.
.
ROLLUP_START_DATE and ROLLUP_COMPLETION_DATE are updated by the CRP
Bill of Resources Load concurrent program and store the start and
completion dates.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_BILLS_OF_RESOURCES_U1 | UNIQUE | APPS_TS_TX_IDX |
BILL_OF_RESOURCES
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BILL_OF_RESOURCES | VARCHAR2 | (10) | Y | Bill of resource set identifier |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
DESCRIPTION | VARCHAR2 | (50) | Bill of resource set description | |
DISABLE_DATE | DATE | Bill of resource set disable date | ||
ROLLUP_START_DATE | DATE | Bill of resources load start date | ||
ROLLUP_COMPLETION_DATE | DATE | Bill of resources load completion date | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
CRP.CRP_BILLS_OF_RESOURCES does not reference any database object
CRP.CRP_BILLS_OF_RESOURCES is referenced by following:
Description: | Items in a bill of resource set |
---|
Foreign Key Column | Foreign Table |
---|---|
CRP_BILL_OF_RESOURCE_ITEMS.INVENTORY_ITEM_ID
CRP_BILL_OF_RESOURCE_ITEMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CRP_BILL_OF_RESOURCE_ITEMS.BILL_OF_RESOURCES
CRP_BILL_OF_RESOURCE_ITEMS.ORGANIZATION_ID |
CRP_BILLS_OF_RESOURCES |
Foreign Key Column | Foreign Table |
---|---|
CRP_RESOURCE_HOURS.ASSEMBLY_ITEM_ID
CRP_RESOURCE_HOURS.BILL_OF_RESOURCES CRP_RESOURCE_HOURS.ORGANIZATION_ID |
CRP_BILL_OF_RESOURCE_ITEMS |
CRP_BILL_OF_RESOURCE_ITEMS stores a row for each item included in a
bill of resource set. Items are assigned to a bill of resource set in
the Enter Bill of Resources form and by the Bill of Resources Load
concurrent program.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_BILL_OF_RESOURCE_ITEMS_U1 | UNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
BILL_OF_RESOURCES ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
BILL_OF_RESOURCES | VARCHAR2 | (10) | Y | Bill of resource set identifier |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
CRP.CRP_BILL_OF_RESOURCE_ITEMS does not reference any database object
CRP.CRP_BILL_OF_RESOURCE_ITEMS is referenced by following:
Description: | Deltas between the primary calendar and shift calendars |
---|
Foreign Key Column | Foreign Table |
---|---|
CRP_CAL_SHIFT_DELTA.CALENDAR_CODE
CRP_CAL_SHIFT_DELTA.EXCEPTION_SET_ID CRP_CAL_SHIFT_DELTA.CALENDAR_DATE |
BOM_CALENDAR_DATES |
CRP_CAL_SHIFT_DELTA.CALENDAR_CODE
CRP_CAL_SHIFT_DELTA.EXCEPTION_SET_ID CRP_CAL_SHIFT_DELTA.SHIFT_NUM CRP_CAL_SHIFT_DELTA.CALENDAR_DATE |
BOM_SHIFT_DATES |
CRP_CAL_SHIFT_DELTA stores the deltas between the organization
calendar stored in BOM_CALENDAR_DATES and the shift calendars stored
in BOM_SHIFT_DATES. It stores a row for each workday in the
organization calendar which is not a workday in the shift calendars
and a row for each workday in the shift calendar which is not a
workday in the organization calendar.
.
DELTA_CODE is set to 1 if the workday is defined as a workday in the
organization calendar but not in the shifts calendar. It is set to 2
if the workday is defined as a workday in the shifts calendar but not
in the organization calendar.
.
This table is be populated by the Oracle Bills of Material Build
Workday Calendar concurrent program. The RCCP and CRP inquiries and
reports use this table to calculate the available hours of
department-resources.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_CAL_SHIFT_DELTA_U1 | UNIQUE | APPS_TS_TX_IDX |
CALENDAR_CODE
EXCEPTION_SET_ID SHIFT_NUM CALENDAR_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALENDAR_CODE | VARCHAR2 | (10) | Y | Calendar identifier |
EXCEPTION_SET_ID | NUMBER | Y | Exception set identifier | |
SHIFT_NUM | NUMBER | Y | Shift identifier | |
CALENDAR_DATE | DATE | Y | Shift workday date or organization calendar workday date | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
DELTA_CODE | NUMBER | Y | Delta code | |
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column |
CRP.CRP_CAL_SHIFT_DELTA does not reference any database object
CRP.CRP_CAL_SHIFT_DELTA is referenced by following:
Description: | Bucketed resource availability and requirement information |
---|
CRP_CAPACITY_PLANS is a table used by the form module CRPFCVCP
for displaying bucketed information on resource availability and
requirement. It is populated at run time by user exits.
Each row stores a type of information about a particular resource.
There are 15 different types of information for resources and 9
different types for assembly lines. For a given resource, there will
be 15 rows of information in the table, each with a different TYPE.
Similarly, for a given LINE, there will be 9 rows of information in
the table.
All of the information is bucketed into 36 weekly buckets. This
bucketed information is stored in the columns PERIOD1 through
PERIOD36.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_CAPACITY_PLANS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
QUERY_ID
ORGANIZATION_ID DEPARTMENT_ID RESOURCE_ID |
CRP_CAPACITY_PLANS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
QUERY_ID
ORGANIZATION_ID LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Y | Query Identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
RESOURCE_ID | NUMBER | Resource identifier | ||
LINE_ID | NUMBER | Line Identifier | ||
TYPE_ID | NUMBER | Type Identifier | ||
TYPE_TEXT | VARCHAR2 | (50) | Horizontal bucket attribute type | |
PERIOD1 | NUMBER | Generic number column | ||
PERIOD2 | NUMBER | Generic number column | ||
PERIOD3 | NUMBER | Generic number column | ||
PERIOD4 | NUMBER | Generic number column | ||
PERIOD5 | NUMBER | Generic number column | ||
PERIOD6 | NUMBER | Generic number column | ||
PERIOD7 | NUMBER | Generic number column | ||
PERIOD8 | NUMBER | Generic number column | ||
PERIOD9 | NUMBER | Generic number column | ||
PERIOD10 | NUMBER | Generic number column | ||
PERIOD11 | NUMBER | Generic number column | ||
PERIOD12 | NUMBER | Generic number column | ||
PERIOD13 | NUMBER | Generic number column | ||
PERIOD14 | NUMBER | Generic number column | ||
PERIOD15 | NUMBER | Generic number column | ||
PERIOD16 | NUMBER | Generic number column | ||
PERIOD17 | NUMBER | Generic number column | ||
PERIOD18 | NUMBER | Generic number column | ||
PERIOD19 | NUMBER | Generic number column | ||
PERIOD20 | NUMBER | Generic number column | ||
PERIOD21 | NUMBER | Generic number column | ||
PERIOD22 | NUMBER | Generic number column | ||
PERIOD23 | NUMBER | Generic number column | ||
PERIOD24 | NUMBER | Generic number column | ||
PERIOD25 | NUMBER | Generic number column | ||
PERIOD26 | NUMBER | Generic number column | ||
PERIOD27 | NUMBER | Generic number column | ||
PERIOD28 | NUMBER | Generic number column | ||
PERIOD29 | NUMBER | Generic number column | ||
PERIOD30 | NUMBER | Generic number column | ||
PERIOD31 | NUMBER | Generic number column | ||
PERIOD32 | NUMBER | Generic number column | ||
PERIOD33 | NUMBER | Generic number column | ||
PERIOD34 | NUMBER | Generic number column | ||
PERIOD35 | NUMBER | Generic number column | ||
PERIOD36 | NUMBER | Generic number column | ||
DEPARTMENT_CLASS | VARCHAR2 | (50) | Department Class | |
RESOURCE_TYPE | VARCHAR2 | (80) | Resource type | |
DEPARTMENT_NAME | VARCHAR2 | (50) | Department name | |
RESOURCE_NAME | VARCHAR2 | (50) | Resource name | |
RESOURCE_GROUP_NAME | VARCHAR2 | (50) | Resource Group Name | |
LINE_NAME | VARCHAR2 | (50) | Line name | |
BILL_OF_RESOURCE | VARCHAR2 | (50) | Bill of resource | |
SIMULATION_SET | VARCHAR2 | (50) | Simulation Set | |
DESIGNATOR | VARCHAR2 | (50) | Plan or schedule name |
CRP.CRP_CAPACITY_PLANS does not reference any database object
CRP.CRP_CAPACITY_PLANS is referenced by following:
Description: | User interface setup information for CRP forms |
---|
CRP_DISPLAY_OPTIONS stores the user interface configuration of the
Horizontal window in the RCCP and CRP Inquiry form. A row is stored
for each user which specifies display details such as field width,
window size, and display factors for the Horizontal window.
Columns AVAILABLE_RATE to REPETITIVE_SCHEDULES are attribute display
indicators that indicates whether the corresponding attribute will be
displayed in the form. For example, if REQUIRED_RATE is set to 'Y',
then the required rate for assembly lines will be displayed in the
form.
User can change the configuration through the Preferences window in
CRPFCVCP form.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_DISPLAY_OPTIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_ID | NUMBER | Y | User Identifier | |
DEFAULT_FLAG | NUMBER | Default setup indicator | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
SUMMARY_FIELD_WIDTH | NUMBER | Field width | ||
SUMMARY_DISPLAY_FACTOR | NUMBER | Display factor | ||
SUMMARY_WINDOW_SIZE | NUMBER | Window size | ||
SUMMARY_WINDOW_WIDTH | NUMBER | Window width | ||
SUMMARY_DECIMAL_PLACES | NUMBER | Number of decimal places | ||
AVAILABLE_RATE | VARCHAR2 | (1) | Attribute display indicator | |
REQUIRED_RATE | VARCHAR2 | (1) | Attribute display indicator | |
NET_AVAILABLE_RATE | VARCHAR2 | (1) | Attribute display indicator | |
CUM_AVAILABLE_RATE | VARCHAR2 | (1) | Attribute display indicator | |
RATE_UTILIZATION | VARCHAR2 | (1) | Attribute display indicator | |
CUM_RATE_UTILIZATION | VARCHAR2 | (1) | Attribute display indicator | |
DAILY_REQUIRED_RATE | VARCHAR2 | (1) | Attribute display indicator | |
DAILY_AVAILABLE_RATE | VARCHAR2 | (1) | Attribute display indicator | |
LINE_COST | VARCHAR2 | (1) | Attribute display indicator | |
HOURS_AVAILABLE | VARCHAR2 | (1) | Attribute display indicator | |
REQUIRED_HOURS | VARCHAR2 | (1) | Attribute display indicator | |
NET_HOURS_AVAILABLE | VARCHAR2 | (1) | Attribute display indicator | |
CUM_HOURS_AVAILABLE | VARCHAR2 | (1) | Attribute display indicator | |
ROUTING_UTILIZATION | VARCHAR2 | (1) | Attribute display indicator | |
CUM_ROUTING_UTILIZATION | VARCHAR2 | (1) | Attribute display indicator | |
HOURS_REQUIRED_PER_DAY | VARCHAR2 | (1) | Attribute display indicator | |
HOURS_AVAILABLE_PER_DAY | VARCHAR2 | (1) | Attribute display indicator | |
TOTAL_RESOURCE_COST | VARCHAR2 | (1) | Attribute display indicator | |
SUM_OF_CAPACITY_CHANGES | VARCHAR2 | (1) | Attribute display indicator | |
CUM_SUM_OF_CHANGES | VARCHAR2 | (1) | Attribute display indicator | |
PLANNED_ORDERS | VARCHAR2 | (1) | Attribute display indicator | |
NON_STANDARD_JOB_ORDERS | VARCHAR2 | (1) | Attribute display indicator | |
DISCRETE_JOBS | VARCHAR2 | (1) | Attribute display indicator | |
REPETITIVE_SCHEDULES | VARCHAR2 | (1) | Attribute display indicator |
CRP.CRP_DISPLAY_OPTIONS does not reference any database object
CRP.CRP_DISPLAY_OPTIONS is referenced by following:
Description: | Generic query table for inquiry forms |
---|
CRP_FORM_QUERY is a generic table used by forms for querying data
populated by user-exits. Each row represents some information that the
user needs displayed in a form. This table is populated by the user
exit CAP_PLAN, for the RCCP and CRP inquiries.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_FORM_QUERY_N1 | NONUNIQUE | APPS_TS_NOLOGGING | QUERY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUERY_ID | NUMBER | Y | Query identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
DATE1 | DATE | Generic date column | ||
DATE2 | DATE | Generic date column | ||
DATE3 | DATE | Generic date column | ||
DATE4 | DATE | Generic date column | ||
DATE5 | DATE | Generic date column | ||
DATE6 | DATE | Generic date column | ||
DATE7 | DATE | Generic date column | ||
DATE8 | DATE | Generic date column | ||
NUMBER1 | NUMBER | Generic number column | ||
NUMBER2 | NUMBER | Generic number column | ||
NUMBER3 | NUMBER | Generic number column | ||
NUMBER4 | NUMBER | Generic number column | ||
NUMBER5 | NUMBER | Generic number column | ||
NUMBER6 | NUMBER | Generic number column | ||
NUMBER7 | NUMBER | Generic number column | ||
NUMBER8 | NUMBER | Generic number column | ||
NUMBER9 | NUMBER | Generic number column | ||
NUMBER10 | NUMBER | Generic number column | ||
CHAR1 | VARCHAR2 | (255) | Generic character column | |
CHAR2 | VARCHAR2 | (255) | Generic character column | |
CHAR3 | VARCHAR2 | (255) | Generic character column | |
CHAR4 | VARCHAR2 | (255) | Generic character column | |
CHAR5 | VARCHAR2 | (255) | Generic character column | |
CHAR6 | VARCHAR2 | (255) | Generic character column | |
CHAR7 | VARCHAR2 | (255) | Generic character column | |
CHAR8 | VARCHAR2 | (255) | Generic character column | |
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
NUMBER11 | NUMBER | Generic number column | ||
NUMBER12 | NUMBER | Generic number column | ||
NUMBER13 | NUMBER | Generic number column | ||
NUMBER14 | NUMBER | Generic number column | ||
NUMBER15 | NUMBER | Generic number column | ||
NUMBER16 | NUMBER | Generic number column | ||
NUMBER17 | NUMBER | Generic number column | ||
NUMBER18 | NUMBER | Generic number column | ||
CHAR9 | VARCHAR2 | (255) | Generic character column | |
CHAR10 | VARCHAR2 | (255) | Generic character column |
CRP.CRP_FORM_QUERY does not reference any database object
CRP.CRP_FORM_QUERY is referenced by following:
Description: | List of resources planned in the CRP run |
---|
Foreign Key Column | Foreign Table |
---|---|
CRP_PLANNED_RESOURCES.DEPARTMENT_ID
CRP_PLANNED_RESOURCES.RESOURCE_ID |
BOM_DEPARTMENT_RESOURCES |
CRP_PLANNED_RESOURCES.LINE_ID | WIP_LINES |
CRP_PLANNED_RESOURCES stores the list of resources planned by the
planning process. CRP_PLANNED_RESOURCES stores resource information
for both routing based departments/resources and rate based lines.
OWNING_DEPARTMENT_ID stores the department identifier of the owning
department for shared resources.
RESOURCE_SHORTAGE_TYPE and RESOURCE_EXCESS_TYPE columns indicate the
nature of time fences used in calculating resource exceptions in the
memory based planner.
OVERUTILIZED_PERCENT and UNDERUTILIZED_PERCENT contain tolerances for
flagging resource overutilization and underutilization exceptions in
the memory based planner.
This table is populated by the Snapshot, and is used by the Planner.
Data in the table can be viewed in the Planner's Workbench.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_PLANNED_RESOURCES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
DEPARTMENT_ID RESOURCE_ID ORGANIZATION_ID |
CRP_PLANNED_RESOURCES_N2 | NONUNIQUE | APPS_TS_TX_IDX |
COMPILE_DESIGNATOR
LINE_ID ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Y | MPS, MRP or DRP plan identifier |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
LINE_ID | NUMBER | Line identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
RESOURCE_ID | NUMBER | Resource identifier | ||
OWNING_DEPARTMENT_ID | NUMBER | Owning Department identifier for shared resource | ||
RESOURCE_SHORTAGE_TYPE | NUMBER | Resource shortage type | ||
RESOURCE_EXCESS_TYPE | NUMBER | Resource excess type | ||
OVERUTILIZED_PERCENT | NUMBER | Overutilization Tolerance(%) | ||
UNDERUTILIZED_PERCENT | NUMBER | Underutilization Tolerance(%) | ||
MAX_UTILIZATION | NUMBER | Not currently used | ||
MIN_UTILIZATION | NUMBER | Not currently used | ||
UTILIZATION | NUMBER | Utilization of the planned resource | ||
EFFICIENCY | NUMBER | Efficiency of the planned resource | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
CRP.CRP_PLANNED_RESOURCES does not reference any database object
CRP.CRP_PLANNED_RESOURCES is referenced by following:
Description: | Results of the rollup for rough cut capacity |
---|
Foreign Key Column | Foreign Table |
---|---|
CRP_RESOURCE_HOURS.ASSEMBLY_ITEM_ID
CRP_RESOURCE_HOURS.BILL_OF_RESOURCES CRP_RESOURCE_HOURS.ORGANIZATION_ID |
CRP_BILL_OF_RESOURCE_ITEMS |
CRP_RESOURCE_HOURS.DEPARTMENT_ID
CRP_RESOURCE_HOURS.RESOURCE_ID |
BOM_DEPARTMENT_RESOURCES |
CRP_RESOURCE_HOURS.SOURCE_ITEM_ID
CRP_RESOURCE_HOURS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CRP_RESOURCE_HOURS.OPERATION_SEQUENCE_ID
CRP_RESOURCE_HOURS.RESOURCE_SEQ_NUM |
BOM_OPERATION_RESOURCES |
CRP_RESOURCE_HOURS stores a row for each resource or repetitive line
required to build an assembly from its lowest level components. Each
row also includes the department where the assembly is being built,
the resource hours required, the usage of the components in the
assembly, and the set back days from the due date of the assembly when
the resource or the line is required.
RESOURCE_DEPARTMENT_HOURS is calculated by multiplying the usage rate
or amount of the assembly by the conversion rate defined for that
assembly.
SETBACK_DAYS is the number of days from the due date of the assembly
that the resource is needed.
ASSEMBLY_USAGE is a resource hours multiplier derived from the usage
of the component. Therefore the assembly usage for the resource
required to make an assembly from its immediate components is one.
SOURCE_ITEM_ID is the component in the assembly that is the source of
the repetitive or routing-based requirements.
This table is populated by the Bill of Resource Load concurrent
program and the Enter Bill of Resources form. The rough cut capacity
inquiry and report use this table to compile the rough cut capacity
plan.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_RESOURCE_HOURS_U1 | UNIQUE | APPS_TS_TX_IDX | TRANSACTION_ID |
CRP_RESOURCE_HOURS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
BILL_OF_RESOURCES
ASSEMBLY_ITEM_ID ORGANIZATION_ID |
CRP_RESOURCE_HOURS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
DEPARTMENT_ID
RESOURCE_ID BILL_OF_RESOURCES ORGANIZATION_ID |
CRP_RESOURCE_HOURS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
LINE_ID
BILL_OF_RESOURCES ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Y | Unique id for the row | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
BILL_OF_RESOURCES | VARCHAR2 | (10) | Y | Bill of resource set identifier |
ASSEMBLY_ITEM_ID | NUMBER | Y | Assembly item identifier | |
SOURCE_ITEM_ID | NUMBER | Y | Component that is the source of the requirement | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
RESOURCE_ID | NUMBER | Resource identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
LINE_ID | NUMBER | Repetitive line identifier | ||
RESOURCE_DEPARTMENT_HOURS | NUMBER | Required resource hours | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number in routing | ||
OPERATION_SEQUENCE_ID | NUMBER | Operation sequence id | ||
RESOURCE_SEQ_NUM | NUMBER | Resource sequence num | ||
SETBACK_DAYS | NUMBER | Resource set back days from assembly due date | ||
ASSEMBLY_USAGE | NUMBER | Resource hours multiplier for assembly usage | ||
ORIGINATION_TYPE | NUMBER | Y | Origination type of requirement | |
RESOURCE_UNITS | NUMBER | Operation resource units | ||
BASIS | NUMBER | Operation basis | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
DDF_CONTEXT | VARCHAR2 | (30) | Structure defining column for the developer descriptive flexfield | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
CRP.CRP_RESOURCE_HOURS does not reference any database object
CRP.CRP_RESOURCE_HOURS is referenced by following:
Description: | Capacity resource plan |
---|
Foreign Key Column | Foreign Table |
---|---|
CRP_RESOURCE_PLAN.SOURCE_TRANSACTION_ID | MRP_RECOMMENDATIONS |
CRP_RESOURCE_PLAN stores the resource requirements for WIP discrete
jobs, WIP nonstandard jobs, suggested planned orders, and suggested
repetitive schedules for a MRP plan.
.
SOURCE_TRANSACTION_ID uniquely identifies an order in
MRP_RECOMMENDATIONS.
.
In the case of a discrete resource requirement, the RESOURCE_END_DATE
and DAILY_RESOURCE_HOURS columns are NULL, and RESOURCE_DATE contains
the resource requirement date.
.
In the case of a repetitive requirement, RESOURCE_END_DATE contains
the end date of the requirement, DAILY_RESOURCE_HOURS contains the
daily resource requirement, RESOURCE_DATE contains the start date of
the requirement, and RESOURCE_HOURS contains the total resource
requirement over the period.
.
This table is populated by the memory based planner or the CRP
planner. It is used to display capacity requirements in the Planner's
Workbench form and by CRP inquiry and CRP reports to compile the
capacity plan.
.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_RESOURCE_PLAN_U1 | UNIQUE | APPS_TS_TX_IDX | TRANSACTION_ID |
CRP_RESOURCE_PLAN_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
DESIGNATOR RESOURCE_ID DEPARTMENT_ID ASSEMBLY_ITEM_ID |
CRP_RESOURCE_PLAN_N2 | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_TRANSACTION_ID |
CRP_RESOURCE_PLAN_N3 | NONUNIQUE | APPS_TS_TX_IDX |
ASSEMBLY_ITEM_ID
DESIGNATOR ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Y | Unique identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
DEPARTMENT_ID | NUMBER | Y | Department identifier | |
RESOURCE_ID | NUMBER | Y | Resource identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
DESIGNATOR | VARCHAR2 | (10) | Y | MRP plan identifier |
SOURCE_TRANSACTION_ID | NUMBER | Y | Order identifier | |
ASSEMBLY_ITEM_ID | NUMBER | Y | Assembly item identifier | |
SOURCE_ITEM_ID | NUMBER | Source item identifier | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number in routing | ||
RESOURCE_DATE | DATE | Y | Resource need date | |
RESOURCE_SEQ_NUM | NUMBER | Resource sequence number | ||
RESOURCE_HOURS | NUMBER | Y | Resource hours needed | |
REPETITIVE_TYPE | NUMBER | Y | Repetitive type | |
SUPPLY_TYPE | NUMBER | Supply Type Identifier | ||
RESOURCE_END_DATE | DATE | Last date resource is needed for repetitive schedules | ||
DAILY_RESOURCE_HOURS | NUMBER | Daily resource hours needed for repetitive schedules | ||
LOAD_RATE | NUMBER | Load Rate | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column |
CRP.CRP_RESOURCE_PLAN does not reference any database object
CRP.CRP_RESOURCE_PLAN is referenced by following:
Description: | Simulation set names |
---|
CRP_SIMULATION_SETS stores the names of the simulation sets.
Simulation sets are used to group multiple resource changes. Each
resource change defined in BOM_RESOURCE_CHANGES can be associated with
a simulation set. The USE_IN_WIP flag determines if the resource
change associated with a particular simulation set is used by the WIP
scheduler. The RCCP and CRP reports and inquiries can be run for a
particular simulation set.
Index | Type | Tablespace | Column |
---|---|---|---|
CRP_SIMULATION_SETS_U1 | UNIQUE | APPS_TS_TX_IDX |
SIMULATION_SET
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SIMULATION_SET | VARCHAR2 | (10) | Y | Simulation set identifier |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
DESCRIPTION | VARCHAR2 | (50) | Simulation set description | |
USE_IN_WIP_FLAG | NUMBER | Use in WIP flag | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
CRP.CRP_SIMULATION_SETS does not reference any database object
CRP.CRP_SIMULATION_SETS is referenced by following:
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEPARTMENT_ID | NUMBER | Y | Department identifier | |
DEPT_CODE | VARCHAR2 | (10) | Y | Department code |
DEPT_DESCRIPTION | VARCHAR2 | (240) | Department description | |
RESOURCE_ID | NUMBER | Y | Resource identifier | |
RES_CODE | VARCHAR2 | (10) | Y | Resource code |
RES_DESCRIPTION | VARCHAR2 | (240) | Resource description | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
AVAILABLE_DATE | DATE | Y | Resource availability date | |
AVAILABLE_HOURS | NUMBER | Available resource hours |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEPARTMENT_ID | NUMBER | Department identifier | ||
DEPT_CODE | VARCHAR2 | (10) | Department code | |
DEPT_DESCRIPTION | VARCHAR2 | (240) | Department description | |
RESOURCE_ID | NUMBER | Resource identifier | ||
RES_CODE | VARCHAR2 | (10) | Resource code | |
RES_DESCRIPTION | VARCHAR2 | (240) | Resource description | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
AVAILABLE_DATE | DATE | Resource availability date | ||
AVAILABLE_HOURS | NUMBER | Resource availablle hours |
APPS.CRP_AVAILABLE_HOURS is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
COMPILE_DESIGNATOR | VARCHAR2 | (20) | MPS, MRP or DRP plan identifier | |
LINE_ID | NUMBER | Line identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
DEPT_LINE_CODE | VARCHAR2 | (10) | Department/Line code | |
DEPT_LINE_DESC | VARCHAR2 | (240) | Department/Line description | |
RESOURCE_ID | NUMBER | Resource identifier | ||
RESOURCE_CODE | VARCHAR2 | (10) | Resource code | |
RESOURCE_DESC | VARCHAR2 | (240) | Resource description | |
RESOURCE_START_DATE | DATE | Start date of the resource availability | ||
RESOURCE_END_DATE | DATE | End date of the resource availability | ||
RESOURCE_HOURS | NUMBER | Daily availability of the resource in hours | ||
RESOURCE_UNITS | NUMBER | Number of resource units | ||
TOTAL_AVAILABILITY | NUMBER | Total availability of the resource in hours | ||
UOM | VARCHAR2 | (4000) | Unit of measure | |
MAX_RATE | NUMBER | Maximum hourly rate of the line | ||
UPDATED | NUMBER | Flag to determine whether an ADD WORKDAY modification was applied | ||
STATUS | NUMBER | Attribute used for online planning | ||
APPLIED | NUMBER | Attribute used for online planning | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
BILL_OF_RESOURCES | VARCHAR2 | (10) | Y | Bill of resource identifier |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.CRP_BILL_OF_RESOURCE_ITEMS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
BILL_OF_RESOURCE | VARCHAR2 | (50) | Bill of resource | |
CREATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
DEPARTMENT_CLASS | VARCHAR2 | (50) | Department Class | |
DEPARTMENT_ID | NUMBER | Department identifier | ||
DEPARTMENT_NAME | VARCHAR2 | (50) | Department name | |
DESIGNATOR | VARCHAR2 | (50) | Plan or schedule name | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LINE_ID | NUMBER | Line Identifier | ||
LINE_NAME | VARCHAR2 | (50) | Line name | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
PERIOD1 | NUMBER | Generic number column | ||
PERIOD10 | NUMBER | Generic number column | ||
PERIOD11 | NUMBER | Generic number column | ||
PERIOD12 | NUMBER | Generic number column | ||
PERIOD13 | NUMBER | Generic number column | ||
PERIOD14 | NUMBER | Generic number column | ||
PERIOD15 | NUMBER | Generic number column | ||
PERIOD16 | NUMBER | Generic number column | ||
PERIOD17 | NUMBER | Generic number column | ||
PERIOD18 | NUMBER | Generic number column | ||
PERIOD19 | NUMBER | Generic number column | ||
PERIOD2 | NUMBER | Generic number column | ||
PERIOD20 | NUMBER | Generic number column | ||
PERIOD21 | NUMBER | Generic number column | ||
PERIOD22 | NUMBER | Generic number column | ||
PERIOD23 | NUMBER | Generic number column | ||
PERIOD24 | NUMBER | Generic number column | ||
PERIOD25 | NUMBER | Generic number column | ||
PERIOD26 | NUMBER | Generic number column | ||
PERIOD27 | NUMBER | Generic number column | ||
PERIOD28 | NUMBER | Generic number column | ||
PERIOD29 | NUMBER | Generic number column | ||
PERIOD3 | NUMBER | Generic number column | ||
PERIOD30 | NUMBER | Generic number column | ||
PERIOD31 | NUMBER | Generic number column | ||
PERIOD32 | NUMBER | Generic number column | ||
PERIOD33 | NUMBER | Generic number column | ||
PERIOD34 | NUMBER | Generic number column | ||
PERIOD35 | NUMBER | Generic number column | ||
PERIOD36 | NUMBER | Generic number column | ||
PERIOD4 | NUMBER | Generic number column | ||
PERIOD5 | NUMBER | Generic number column | ||
PERIOD6 | NUMBER | Generic number column | ||
PERIOD7 | NUMBER | Generic number column | ||
PERIOD8 | NUMBER | Generic number column | ||
PERIOD9 | NUMBER | Generic number column | ||
QUERY_ID | NUMBER | Y | Query Identifier | |
RESOURCE_ID | NUMBER | Resource identifier | ||
RESOURCE_NAME | VARCHAR2 | (50) | Resource name | |
RESOURCE_GROUP_NAME | VARCHAR2 | (50) | Resource Group Name | |
RESOURCE_TYPE | VARCHAR2 | (80) | Resource Type | |
SIMULATION_SET | VARCHAR2 | (50) | Simulation Set | |
TYPE_ID | NUMBER | Type Identifier | ||
TYPE_TEXT | VARCHAR2 | (80) | Y | Horizontal bucket attribute type |
APPS.CRP_CAPACITY_PLANS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
QUERY_ID | NUMBER | Y | Query identifier | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Department code | |
DEPARTMENT_ID | NUMBER | Department identifier | ||
RESOURCE_CODE | VARCHAR2 | (10) | Resource code | |
RESOURCE_ID | NUMBER | Resource identifier | ||
LINE_CODE | VARCHAR2 | (10) | Line name | |
LINE_ID | NUMBER | WIP line identifier | ||
RESOURCE_START_DATE | DATE | Start date of resource requirement | ||
RESOURCE_END_DATE | DATE | End date of resource requirement | ||
SCHEDULE_START_DATE | DATE | Start date of the supply entry | ||
RATE_END_DATE | DATE | Repetitive production rate end date | ||
OP_SEQ_NUMBER | VARCHAR2 | (255) | Operation sequence number | |
FIRM | NUMBER | Supply firm type | ||
REQUIRED_HOURS | NUMBER | Resource hours required | ||
LOAD_RATE | NUMBER | Load rate for repetitive schedules | ||
DAILY_RESOURCE_HOURS | NUMBER | Daily available resource hours | ||
SCHEDULE_QUANTITY | NUMBER | Schedule quantity | ||
DAILY_RATE | NUMBER | Daily production rate for repetitive schedules | ||
ORDER_TYPE | VARCHAR2 | (80) | Order type | |
REQUIREMENT_TYPE | VARCHAR2 | (80) | Resource requirement type | |
ORDER_NUMBER | VARCHAR2 | (240) | Order number | |
USING_ASSEMBLY | VARCHAR2 | (40) | Assembly for which the supply is defined | |
SOURCE_ITEM | VARCHAR2 | (40) | The item that generated the resource requirement | |
ASSEMBLY_ITEM_ID | NUMBER | Assembly item identifier | ||
SOURCE_ITEM_ID | NUMBER | Source item identifier | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column |
APPS.CRP_FORM_QUERY_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEPARTMENT_ID | NUMBER | Y | Department identifier | |
DEPT_CODE | VARCHAR2 | (10) | Y | Department code |
DEPT_DESCRIPTION | VARCHAR2 | (240) | Department description | |
RESOURCE_ID | NUMBER | Y | Resource identifier | |
RES_CODE | VARCHAR2 | (10) | Y | Resource code |
RES_DESCRIPTION | VARCHAR2 | (240) | Resource description | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
AVAILABLE_DATE | DATE | Y | Resource availability date | |
AVAILABLE_HOURS | NUMBER | Availble resource hours |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Y | MPS, MRP or DRP plan identifier |
OWNING_DEPARTMENT_ID | NUMBER | Owning department identifier for shared resource | ||
OWNING_DEPARTMENT_CODE | VARCHAR2 | (10) | Owning department code for shared resource | |
DEPARTMENT_ID | NUMBER | Department identifier | ||
DEPARTMENT_LINE_CODE | VARCHAR2 | (10) | Department/Line code | |
DEPT_LINE_DESCRIPTION | VARCHAR2 | (240) | Department/Line description | |
DEPARTMENT_CLASS | VARCHAR2 | (10) | Department class | |
RESOURCE_ID | NUMBER | Resource identifier | ||
RESOURCE_CODE | VARCHAR2 | (10) | Resource code | |
RESOURCE_TYPE | NUMBER | Resource type | ||
RESOURCE_TYPE_CODE | VARCHAR2 | (80) | Resource type code | |
RESOURCE_GROUP_NAME | VARCHAR2 | (30) | Resource group name | |
LINE_ID | NUMBER | Line identifier | ||
MAX_RATE | NUMBER | Maximum hourly rate for a line | ||
MIN_RATE | NUMBER | Minimum hourly rate for a line | ||
RESOURCE_SHORTAGE_TYPE | NUMBER | Resource shortage type | ||
RESOURCE_EXCESS_TYPE | NUMBER | Resource excess type | ||
OVERUTILIZED_PERCENT | NUMBER | Overutilization tolerance(%) | ||
UNDERUTILIZED_PERCENT | NUMBER | Underutilization tolerance(%) | ||
MAX_UTILIZATION | NUMBER | Not currently used | ||
MIN_UTILIZATION | NUMBER | Not currently used | ||
UTILIZATION | NUMBER | Utilization of the planned resource | ||
EFFICIENCY | NUMBER | Efficiency of the planned resource | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who column | |
CREATION_DATE | DATE | Y | Standard Who column | |
CREATED_BY | NUMBER | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
DISABLE_DATE | DATE | inactive date |
APPS.CRP_PLANNED_RESOURCES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | Resource identifier | ||
RESOURCE_CODE | VARCHAR2 | (10) | Y | Resource code |
RES_DESCRIPTION | VARCHAR2 | (240) | Resource description | |
DEPARTMENT_ID | NUMBER | Department identifier | ||
DEPT_CODE | VARCHAR2 | (10) | Y | Department code |
DEPT_DESCRIPTION | VARCHAR2 | (240) | Department description | |
BILL_OF_RESOURCES | VARCHAR2 | (10) | Y | Bill of resource set identifier |
SCHEDULE_DESIGNATOR | VARCHAR2 | (10) | Y | Schedule identifier |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
REQ_DATE | DATE | Y | Resource need date | |
REQUIRED_HOURS | NUMBER | Resource hours needed |
APPS.CRP_REQUIRED_HOURS is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
TRANSACTION_ID | NUMBER | Unique id for the row | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
BILL_OF_RESOURCES | VARCHAR2 | (10) | Bill of resource identifier | |
ASSEMBLY_ITEM_ID | NUMBER | Assembly item identifier | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Department code | |
RESOURCE_ID | NUMBER | Resource identifier | ||
RESOURCE_CODE | VARCHAR2 | (10) | Resource code | |
RESOURCE_SEQ_NUM | NUMBER | Resource sequence num | ||
LINE_ID | NUMBER | Repetitive line identifier | ||
LINE_CODE | VARCHAR2 | (10) | Line name | |
SOURCE_ITEM_ID | NUMBER | Component that is the source of the requirement | ||
SETBACK_DAYS | NUMBER | Resource set back days from assembly due date | ||
ASSEMBLY_USAGE | NUMBER | Resource hours multiplier for assembly usage | ||
REQUIRED_HOURS | NUMBER | Resource hours required per unit | ||
RESOURCE_UNITS | NUMBER | Operation resource units | ||
BASIS | NUMBER | Operation basis | ||
OP_SEQ_NUM | NUMBER | Operation sequence number | ||
OPERATION_SEQUENCE_ID | NUMBER | Operation sequence id | ||
ORIGINATION_TYPE_TEXT | VARCHAR2 | (80) | Origination of requirement | |
ORIGINATION_TYPE | NUMBER | Origination type of requirement | ||
TOTAL_HOURS | NUMBER | Total resource required hours | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
DDF_CONTEXT | VARCHAR2 | (30) | Structure defining column for the developer descriptive flexfield | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.CRP_RESOURCE_HOURS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
SOURCE_TABLE | VARCHAR2 | (22) | Source table | |
TRANSACTION_ID | NUMBER | Transaction identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | MPS, MRP or DRP plan identifier | |
DEPARTMENT_ID | NUMBER | Department identifier | ||
DEPARTMENT_LINE_CODE | VARCHAR2 | (10) | Department/Line code | |
RESOURCE_ID | NUMBER | Resource identifier | ||
RESOURCE_CODE | VARCHAR2 | (10) | Resource code | |
RESOURCE_DATE | DATE | Resource need date | ||
RESOURCE_END_DATE | DATE | Resource need end date | ||
ASSEMBLY_ITEM_ID | NUMBER | Assembly item identifier | ||
ASSEMBLY_ITEM_NUMBER | VARCHAR2 | (40) | Assembly item number | |
SOURCE_ITEM_ID | NUMBER | Source item identifier(for MPS Plans) | ||
SOURCE_ITEM_NUMBER | VARCHAR2 | (40) | Source item number | |
SOURCE_TRANSACTION_ID | NUMBER | Source transaction identifier | ||
RESOURCE_HOURS | NUMBER | Resource hours needed | ||
DAILY_RESOURCE_HOURS | NUMBER | Daily resource hours needed | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number in routing | ||
SCHEDULE_START_DATE | DATE | Schedule start date | ||
SCHEDULE_QUANTITY | NUMBER | Schedule quantity | ||
ORDER_NUMBER | VARCHAR2 | (4000) | Order number | |
ORDER_TYPE | VARCHAR2 | (80) | Order type | |
DAILY_RATE | NUMBER | Daily rate | ||
SCHEDULE_END_DATE | DATE | Schedule end date | ||
LOAD_RATE | NUMBER | Load rate | ||
REPETITIVE_TYPE | NUMBER | Is this item built repetitively? |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Not currently used | |
TRANSACTION_ID | NUMBER | Not currently used | ||
ORGANIZATION_ID | NUMBER | Not currently used | ||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Not currently used | |
DEPARTMENT_ID | NUMBER | Not currently used | ||
RESOURCE_ID | NUMBER | Not currently used | ||
ASSEMBLY_ITEM_ID | NUMBER | Not currently used | ||
SOURCE_TRANSACTION_ID | NUMBER | Not currently used |
APPS.CRP_RESOURCE_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |