Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

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.

eTRM - CRP Tables and Views

TABLE - CRP.CRP_AVAILABLE_RESOURCES

TABLE - CRP.CRP_BILLS_OF_RESOURCES

TABLE - CRP.CRP_BILL_OF_RESOURCE_ITEMS

TABLE - CRP.CRP_CAL_SHIFT_DELTA

TABLE - CRP.CRP_CAPACITY_PLANS

TABLE - CRP.CRP_DISPLAY_OPTIONS

TABLE - CRP.CRP_FORM_QUERY

TABLE - CRP.CRP_PLANNED_RESOURCES

TABLE - CRP.CRP_RESOURCE_HOURS

TABLE - CRP.CRP_RESOURCE_PLAN

TABLE - CRP.CRP_SIMULATION_SETS

VIEW - APPS.CRP_24HR_AVAILABLE_HOURS

VIEW - APPS.CRP_AVAILABLE_HOURS

VIEW - APPS.CRP_AVAILABLE_RESOURCES_V

VIEW - APPS.CRP_BILL_OF_RESOURCE_ITEMS_V

VIEW - APPS.CRP_CAPACITY_PLANS_V

VIEW - APPS.CRP_FORM_QUERY_V

VIEW - APPS.CRP_OTHER_AVAILABLE_HOURS

VIEW - APPS.CRP_PLANNED_RESOURCES_V

VIEW - APPS.CRP_REQUIRED_HOURS

VIEW - APPS.CRP_RESOURCE_HOURS_V

VIEW - APPS.CRP_RESOURCE_REQUIREMENTS_V

VIEW - APPS.CRP_RESOURCE_V

Table: CRP_AVAILABLE_RESOURCES

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_AVAILABLE_RESOURCES does not reference any database object

CRP.CRP_AVAILABLE_RESOURCES is referenced by following:

CRP

VIEW - CRP_AVAILABLE_RESOURCES#

[top of page]

Table: CRP_BILLS_OF_RESOURCES

Primary Key: CRP_BILLS_OF_RESOURCES_PK

1. BILL_OF_RESOURCES
2. ORGANIZATION_ID

Foreign Keys to this table:

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_BILLS_OF_RESOURCES does not reference any database object

CRP.CRP_BILLS_OF_RESOURCES is referenced by following:

CRP

VIEW - CRP_BILLS_OF_RESOURCES#

[top of page]

Table: CRP_BILL_OF_RESOURCE_ITEMS

Primary Key: CRP_BILL_OF_RESOURCE_ITEMS_PK

1. INVENTORY_ITEM_ID
2. BILL_OF_RESOURCES
3. ORGANIZATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_BILL_OF_RESOURCE_ITEMS does not reference any database object

CRP.CRP_BILL_OF_RESOURCE_ITEMS is referenced by following:

CRP

VIEW - CRP_BILL_OF_RESOURCE_ITEMS#

[top of page]

Table: CRP_CAL_SHIFT_DELTA

Primary Key: CRP_CAL_SHIFT_DELTA_PK

1. CALENDAR_CODE
2. EXCEPTION_SET_ID
3. SHIFT_NUM
4. CALENDAR_DATE

Foreign Keys from this table:

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_CAL_SHIFT_DELTA does not reference any database object

CRP.CRP_CAL_SHIFT_DELTA is referenced by following:

CRP

VIEW - CRP_CAL_SHIFT_DELTA#

[top of page]

Table: CRP_CAPACITY_PLANS

Primary Key: CRP_CAPACITY_PLANS_PK

1. QUERY_ID

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_CAPACITY_PLANS does not reference any database object

CRP.CRP_CAPACITY_PLANS is referenced by following:

CRP

VIEW - CRP_CAPACITY_PLANS#

[top of page]

Table: CRP_DISPLAY_OPTIONS

Primary Key: CRP_DISPLAY_OPTIONS_PK

1. USER_ID

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_DISPLAY_OPTIONS does not reference any database object

CRP.CRP_DISPLAY_OPTIONS is referenced by following:

CRP

VIEW - CRP_DISPLAY_OPTIONS#

[top of page]

Table: CRP_FORM_QUERY

Primary Key: CRP_FORM_QUERY_PK

1. QUERY_ID

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_FORM_QUERY does not reference any database object

CRP.CRP_FORM_QUERY is referenced by following:

CRP

VIEW - CRP_FORM_QUERY#

[top of page]

Table: CRP_PLANNED_RESOURCES

Foreign Keys from this table:

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_PLANNED_RESOURCES does not reference any database object

CRP.CRP_PLANNED_RESOURCES is referenced by following:

CRP

VIEW - CRP_PLANNED_RESOURCES#

[top of page]

Table: CRP_RESOURCE_HOURS

Primary Key: CRP_RESOURCE_HOURS_PK

1. TRANSACTION_ID

Foreign Keys from this table:

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_RESOURCE_HOURS does not reference any database object

CRP.CRP_RESOURCE_HOURS is referenced by following:

CRP

VIEW - CRP_RESOURCE_HOURS#

[top of page]

Table: CRP_RESOURCE_PLAN

Primary Key: CRP_RESOURCE_PLAN_PK

1. TRANSACTION_ID

Foreign Keys from this table:

Comments

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.
.

Indexes

Columns

[top of page]

CRP.CRP_RESOURCE_PLAN does not reference any database object

CRP.CRP_RESOURCE_PLAN is referenced by following:

CRP

VIEW - CRP_RESOURCE_PLAN#

[top of page]

Table: CRP_SIMULATION_SETS

Primary Key: CRP_SIMULATION_SET_PK

1. SIMULATION_SET
2. ORGANIZATION_ID

Comments

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.

Indexes

Columns

[top of page]

CRP.CRP_SIMULATION_SETS does not reference any database object

CRP.CRP_SIMULATION_SETS is referenced by following:

CRP

VIEW - CRP_SIMULATION_SETS#

[top of page]

View: CRP_24HR_AVAILABLE_HOURS

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - BOM_CALENDAR_DATES

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_DEPARTMENT_RESOURCES

SYNONYM - BOM_RESOURCES

SYNONYM - MTL_PARAMETERS

APPS

VIEW - CRP_AVAILABLE_HOURS

[top of page]

View: CRP_AVAILABLE_HOURS

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns

[top of page]

APPS

VIEW - CRP_24HR_AVAILABLE_HOURS

VIEW - CRP_OTHER_AVAILABLE_HOURS

APPS.CRP_AVAILABLE_HOURS is not referenced by any database object

[top of page]

View: CRP_AVAILABLE_RESOURCES_V

Comments

View Type

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.

Columns

[top of page]

APPS

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_RESOURCES

SYNONYM - CRP_AVAILABLE_RESOURCES

PACKAGE - FND_PROFILE

SYNONYM - MTL_PARAMETERS

SYNONYM - WIP_LINES

APPS.CRP_AVAILABLE_RESOURCES_V is not referenced by any database object

[top of page]

View: CRP_BILL_OF_RESOURCE_ITEMS_V

Comments

View Type

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.

Columns

[top of page]

APPS

SYNONYM - CRP_BILL_OF_RESOURCE_ITEMS

- MTL_SYSTEM_ITEMS_VL

APPS.CRP_BILL_OF_RESOURCE_ITEMS_V is not referenced by any database object

[top of page]

View: CRP_CAPACITY_PLANS_V

Comments

View Type

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.

Columns

[top of page]

APPS

SYNONYM - CRP_CAPACITY_PLANS

SYNONYM - MTL_PARAMETERS

- MFG_LOOKUPS

APPS.CRP_CAPACITY_PLANS_V is not referenced by any database object

[top of page]

View: CRP_FORM_QUERY_V

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_RESOURCES

SYNONYM - CRP_FORM_QUERY

SYNONYM - WIP_ENTITIES

SYNONYM - WIP_LINES

- MFG_LOOKUPS

- MTL_ITEM_FLEXFIELDS

APPS.CRP_FORM_QUERY_V is not referenced by any database object

[top of page]

View: CRP_OTHER_AVAILABLE_HOURS

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_DEPARTMENT_RESOURCES

SYNONYM - BOM_RESOURCES

SYNONYM - BOM_RESOURCE_SHIFTS

SYNONYM - BOM_SHIFT_DATES

SYNONYM - BOM_SHIFT_TIMES

SYNONYM - MTL_PARAMETERS

APPS

VIEW - CRP_AVAILABLE_HOURS

[top of page]

View: CRP_PLANNED_RESOURCES_V

Comments

View Type

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.

Columns

[top of page]

APPS

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_DEPARTMENT_RESOURCES

SYNONYM - BOM_RESOURCES

SYNONYM - CRP_PLANNED_RESOURCES

SYNONYM - MTL_PARAMETERS

SYNONYM - WIP_LINES

- MFG_LOOKUPS

APPS.CRP_PLANNED_RESOURCES_V is not referenced by any database object

[top of page]

View: CRP_REQUIRED_HOURS

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - BOM_CALENDAR_DATES

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_RESOURCES

SYNONYM - CRP_RESOURCE_HOURS

SYNONYM - MRP_SCHEDULE_DATES

SYNONYM - MRP_SCHEDULE_DESIGNATORS

SYNONYM - MTL_PARAMETERS

APPS.CRP_REQUIRED_HOURS is not referenced by any database object

[top of page]

View: CRP_RESOURCE_HOURS_V

Comments

View Type

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.

Columns

[top of page]

APPS

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_RESOURCES

SYNONYM - CRP_RESOURCE_HOURS

SYNONYM - WIP_LINES

- MFG_LOOKUPS

APPS.CRP_RESOURCE_HOURS_V is not referenced by any database object

[top of page]

View: CRP_RESOURCE_REQUIREMENTS_V

Comments

View Type

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.

Columns

[top of page]

APPS

SYNONYM - BOM_DEPARTMENTS

SYNONYM - BOM_RESOURCES

SYNONYM - CRP_RESOURCE_PLAN

PACKAGE - MRP_GET_ORDER

SYNONYM - MRP_RECOMMENDATIONS

SYNONYM - MRP_SUGG_REP_SCHEDULES

SYNONYM - MTL_PARAMETERS

SYNONYM - WIP_LINES

- MTL_SYSTEM_ITEMS_KFV

- MFG_LOOKUPS

APPS.CRP_RESOURCE_REQUIREMENTS_V is not referenced by any database object

[top of page]

View: CRP_RESOURCE_V

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns

[top of page]

APPS

SYNONYM - CRP_RESOURCE_PLAN

SYNONYM - MRP_RECOMMENDATIONS

SYNONYM - MRP_SUGG_REP_SCHEDULES

APPS.CRP_RESOURCE_V is not referenced by any database object

[top of page]