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 - CSP Tables and Views

TABLE - CSP.CSP_CARRIER_DELIVERY_TIMES

TABLE - CSP.CSP_CURR_SUP_DEM_SUMS

TABLE - CSP.CSP_EXCESS_LISTS

TABLE - CSP.CSP_EXCESS_LIST_SERIAL_LOTS

TABLE - CSP.CSP_EXCESS_RULES_B

TABLE - CSP.CSP_EXCESS_RULES_TL

TABLE - CSP.CSP_FAILURE_RATES

TABLE - CSP.CSP_FORECAST_RULES_B

TABLE - CSP.CSP_FORECAST_RULES_TL

TABLE - CSP.CSP_INV_LOC_ASSIGNMENTS

TABLE - CSP.CSP_LOOP_CALC_RULES_B

TABLE - CSP.CSP_LOOP_CALC_RULES_TL

TABLE - CSP.CSP_MOVEORDER_HEADERS

TABLE - CSP.CSP_MOVEORDER_LINES

TABLE - CSP.CSP_MSTRSTCK_LISTS_ITMS

TABLE - CSP.CSP_NOTIFICATIONS

TABLE - CSP.CSP_NOTIFICATION_DETAILS

TABLE - CSP.CSP_PACKLIST_BOXES

TABLE - CSP.CSP_PACKLIST_HEADERS

TABLE - CSP.CSP_PACKLIST_LINES

TABLE - CSP.CSP_PACKLIST_SERIAL_LOTS

TABLE - CSP.CSP_PARTS_LOOPS_B

TABLE - CSP.CSP_PARTS_LOOPS_TL

TABLE - CSP.CSP_PICKLIST_HEADERS

TABLE - CSP.CSP_PICKLIST_LINES

TABLE - CSP.CSP_PICKLIST_SERIAL_LOTS

TABLE - CSP.CSP_PLANNING_PARAMETERS

TABLE - CSP.CSP_PRODUCT_POPULATIONS

TABLE - CSP.CSP_PRODUCT_TASKS

TABLE - CSP.CSP_REP_HIERARCHIES

TABLE - CSP.CSP_REQUIREMENT_HEADERS

TABLE - CSP.CSP_REQUIREMENT_LINES

TABLE - CSP.CSP_REQ_LINE_DETAILS

TABLE - CSP.CSP_RS_CUST_RELATIONS

TABLE - CSP.CSP_SAFETY_FACTORS

TABLE - CSP.CSP_SEC_INVENTORIES

TABLE - CSP.CSP_STOCK_LISTS

TABLE - CSP.CSP_SUPERSEDE_ITEMS

TABLE - CSP.CSP_SUPPLY_CHAIN

TABLE - CSP.CSP_TASK_PARTS

TABLE - CSP.CSP_USAGE_HEADERS

TABLE - CSP.CSP_USAGE_HISTORIES

VIEW - APPS.CSP_ARRIVAL_DATES_V

VIEW - APPS.CSP_ASL_ITEMS_V

VIEW - APPS.CSP_AVAILABLE_PARTS_IN_LOOP_V

VIEW - APPS.CSP_CARRIER_DELIVERY_TIMES_V

VIEW - APPS.CSP_CURR_SUP_DEM_SUMS_V

VIEW - APPS.CSP_CURR_SUP_DEM_SUMS_V2

VIEW - APPS.CSP_DC_PARTS_V

VIEW - APPS.CSP_ENGINEER_DAYS_V

VIEW - APPS.CSP_EOO_CANCEL_RECOMM_V

VIEW - APPS.CSP_EXCESS_LISTS_V

VIEW - APPS.CSP_EXCESS_RULES_VL

VIEW - APPS.CSP_FAILURE_RATES_V

VIEW - APPS.CSP_FORECAST_RULES_B_V

VIEW - APPS.CSP_FORECAST_RULES_VL

VIEW - APPS.CSP_GET_LOT_NUMBERS_V

VIEW - APPS.CSP_GET_SERIAL_NUMBERS_V

VIEW - APPS.CSP_INV_LOC_ASSIGNMENTS_V

VIEW - APPS.CSP_ITEM_SUB_INVENTORIES_ALL_V

VIEW - APPS.CSP_LOCATION_ADDRESS_V

VIEW - APPS.CSP_LOOP_CALC_RULES_V

VIEW - APPS.CSP_LOOP_CALC_RULES_VL

VIEW - APPS.CSP_MATERIAL_TRANSACTIONS_V1

VIEW - APPS.CSP_MINMAX_NOTIFS_V

VIEW - APPS.CSP_MOVEORDERS_V

VIEW - APPS.CSP_MOVEORDER_HEADERS_V

VIEW - APPS.CSP_MOVEORDER_LINES_V

VIEW - APPS.CSP_MO_LINES_V

VIEW - APPS.CSP_MSTRSTCK_LISTS_ITMS_V

VIEW - APPS.CSP_NAV_NODE_TYPES

VIEW - APPS.CSP_NOTIFICATIONS_V

VIEW - APPS.CSP_NOTIFICATION_DETAILS_V

VIEW - APPS.CSP_NOT_PLOOP_NAV

VIEW - APPS.CSP_NOT_PLTYPES_NAV

VIEW - APPS.CSP_NOT_STAT_ITEMS_NAV

VIEW - APPS.CSP_NOT_TYSTAT_NAV

VIEW - APPS.CSP_ORDERS_DUE_V

VIEW - APPS.CSP_ORG_USAGE_DETAILS_V

VIEW - APPS.CSP_PACKLIST_BOXES_V

VIEW - APPS.CSP_PACKLIST_HEADERS_V

VIEW - APPS.CSP_PACKLIST_LINES_V

VIEW - APPS.CSP_PACKLIST_SERIAL_LOTS_V

VIEW - APPS.CSP_PACK_LIST_NAV

VIEW - APPS.CSP_PARTS_LOOPS_B_V

VIEW - APPS.CSP_PARTS_LOOPS_NAV

VIEW - APPS.CSP_PARTS_LOOPS_VL

VIEW - APPS.CSP_PART_CATEGORIES_V

VIEW - APPS.CSP_PICKLIST_HEADERS_V

VIEW - APPS.CSP_PICKLIST_LINES_V

VIEW - APPS.CSP_PICKLIST_LINES_V1

VIEW - APPS.CSP_PICKLIST_SERIAL_LOTS_V1

VIEW - APPS.CSP_PICK_TRANSACTIONS_V

VIEW - APPS.CSP_PLANNING_DETAILS_V

VIEW - APPS.CSP_PLANNING_DRILLDOWN_V

VIEW - APPS.CSP_PLANNING_HEADERS_V

VIEW - APPS.CSP_PLANNING_ORG_HDR_V

VIEW - APPS.CSP_PLANNING_PARAMETERS_V

VIEW - APPS.CSP_PLANNING_SUBINV_HDR_V

VIEW - APPS.CSP_PLANNING_TOPNODE_HDR_V

VIEW - APPS.CSP_PLIST_BOXES_NAV

VIEW - APPS.CSP_PLIST_BOXITEMS_NAV

VIEW - APPS.CSP_PLIST_ITMSLNO_NAV

VIEW - APPS.CSP_PLIST_STATUS_NAV

VIEW - APPS.CSP_PLN_DRILLDOWN_ORG_V

VIEW - APPS.CSP_PLN_DRILLDOWN_SUBINV_V

VIEW - APPS.CSP_PLN_DRILLDOWN_SUBINV_WH_V

VIEW - APPS.CSP_PLN_ORG_NAV

VIEW - APPS.CSP_PLN_REGIONS_NAV

VIEW - APPS.CSP_PLN_REGION_ORG_NAV

VIEW - APPS.CSP_PLN_SUBINV_NAV

VIEW - APPS.CSP_PRODUCT_POPULATIONS_FR_V

VIEW - APPS.CSP_PRODUCT_POPULATIONS_V

VIEW - APPS.CSP_PRODUCT_TASKS_V

VIEW - APPS.CSP_RECV_PARTS_V

VIEW - APPS.CSP_REGION_ITEMS_V

VIEW - APPS.CSP_REG_USAGE_DETAILS_V

VIEW - APPS.CSP_REP_HIERARCHIES_NAV

VIEW - APPS.CSP_REP_HIERARCHIES_V

VIEW - APPS.CSP_REP_HIER_SECINV_NAV

VIEW - APPS.CSP_REQUIRED_PARTS_V

VIEW - APPS.CSP_REQUIREMENT_HEADERS_V

VIEW - APPS.CSP_REQ_LINE_DETAILS_V

VIEW - APPS.CSP_RESOURCE_DEFAULT_INV_LOC_V

VIEW - APPS.CSP_RESOURCE_INV_LOC_V

VIEW - APPS.CSP_RS_RESOURCES_V

VIEW - APPS.CSP_RS_SHIP_TO_ADDRESSES_V

VIEW - APPS.CSP_RS_SUBINVENTORIES_V

VIEW - APPS.CSP_SEC_INVENTORIES_NAV

VIEW - APPS.CSP_SEC_INVENTORIES_V

VIEW - APPS.CSP_SUBINV_USAGE_DETAILS_V

VIEW - APPS.CSP_TASK_PARTS_V

VIEW - APPS.CSP_USAGE_HISTORIES_V

VIEW - APPS.CSP_USAGE_HISTORIES_V1

VIEW - APPS.CSP_USAGE_REG_ORG_SUBINV_V

Table: CSP_CARRIER_DELIVERY_TIMES

Primary Key: CSP_CARRIER_DELIVERY_TIMES_PK

1. RELATION_SHIP_ID

Foreign Keys from this table:

Comments

This table stores delivery time related information for organization , carrier and shipmethode combinations. This information is used to caliculate optimal shipping methode to be used to transfer parts form one organization to another when a disparcher from schedualr asks for various resource options available for him schedule tasks.

Indexes

Columns

[top of page]

CSP.CSP_CARRIER_DELIVERY_TIMES does not reference any database object

CSP.CSP_CARRIER_DELIVERY_TIMES is referenced by following:

APPS

SYNONYM - CSP_CARRIER_DELIVERY_TIMES

[top of page]

Table: CSP_CURR_SUP_DEM_SUMS

Primary Key: CSP_CURR_SUP_DEM_SUMS_PK

1. SUPPLY_DEMAND_ID

Primary Key: CSP_CURR_SUP_DEM_UK

1. ORGANIZATION_ID
2. INVENTORY_ITEM_ID
3. SUBINVENTORY_CODE

Foreign Keys from this table:

Comments

The concurrent program "Create Part Availability Data" populates this table with supply and demand information for service items. This information is used in the Planner's Desktop and also by the concurrent program "Create Notifications".

Indexes

Columns

[top of page]

CSP.CSP_CURR_SUP_DEM_SUMS does not reference any database object

CSP.CSP_CURR_SUP_DEM_SUMS is referenced by following:

APPS

SYNONYM - CSP_CURR_SUP_DEM_SUMS

[top of page]

Table: CSP_EXCESS_LISTS

Primary Key: CSP_EXCESS_LISTS_PK

1. EXCESS_LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_EXCESS_LISTS store the list of items available more than maximum level in subinvetories or organization

Indexes

Columns

[top of page]

CSP.CSP_EXCESS_LISTS does not reference any database object

CSP.CSP_EXCESS_LISTS is referenced by following:

APPS

SYNONYM - CSP_EXCESS_LISTS

[top of page]

Table: CSP_EXCESS_LIST_SERIAL_LOTS

Primary Key: CSP_EXCESS_LIST_SERIAL_LOTS_PK

1. EXCESS_LIST_SERIAL_LOT_ID

Foreign Keys from this table:

Comments

CSP_EXCESS_LIST_SERIAL_LOTS stores information of excess items serial and lot numbers that are returned.

Indexes

Columns

[top of page]

CSP.CSP_EXCESS_LIST_SERIAL_LOTS does not reference any database object

CSP.CSP_EXCESS_LIST_SERIAL_LOTS is referenced by following:

APPS

SYNONYM - CSP_EXCESS_LIST_SERIAL_LOTS

[top of page]

Table: CSP_EXCESS_RULES_B

Primary Key: CSP_EXCESS_RULES_B_PK

1. EXCESS_RULE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table is used for defining excess rules.

Indexes

Columns

[top of page]

CSP.CSP_EXCESS_RULES_B does not reference any database object

CSP.CSP_EXCESS_RULES_B is referenced by following:

APPS

SYNONYM - CSP_EXCESS_RULES_B

[top of page]

Table: CSP_EXCESS_RULES_TL

Primary Key: CSP_EXCESS_RULES_TL_PK

1. EXCESS_RULE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

Translated Excess rules definitions.

Indexes

Columns

[top of page]

CSP.CSP_EXCESS_RULES_TL does not reference any database object

CSP.CSP_EXCESS_RULES_TL is referenced by following:

APPS

SYNONYM - CSP_EXCESS_RULES_TL

[top of page]

Table: CSP_FAILURE_RATES

Primary Key: CSP_FAILURE_RATES_PK

1. FAILURE_RATE_ID

Comments

This table stores the failure rates for the components used to repair a product. The failure rates are calculated for a region as specified in the Planner's Desktop.

Indexes

Columns

[top of page]

CSP.CSP_FAILURE_RATES does not reference any database object

CSP.CSP_FAILURE_RATES is referenced by following:

APPS

SYNONYM - CSP_FAILURE_RATES

[top of page]

Table: CSP_FORECAST_RULES_B

Primary Key: CSP_FORECAST_RULES_B_PK

1. FORECAST_RULE_ID

Foreign Keys to this table:

Comments

This table stores the definitions of forecast rules being used in parts loops and in the master stocklist. The four forecast methods supported are: Simple Average, Weighted Average, Exponential Smoothing and Trend Enhanced.
The 2 period types are Weekly and Periodic. Periodic is identical to the inventory accounting periods defined in the Inventory Accounting Periods form.
For Weighted Average we allow a maximum of 12 periods.

Indexes

Columns

[top of page]

CSP.CSP_FORECAST_RULES_B does not reference any database object

CSP.CSP_FORECAST_RULES_B is referenced by following:

APPS

SYNONYM - CSP_FORECAST_RULES_B

[top of page]

Table: CSP_FORECAST_RULES_TL

Primary Key: CSP_FORECAST_RULES_TL_PK

1. FORECAST_RULE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

Translated forecast rules definitions.

Indexes

Columns

[top of page]

CSP.CSP_FORECAST_RULES_TL does not reference any database object

CSP.CSP_FORECAST_RULES_TL is referenced by following:

APPS

SYNONYM - CSP_FORECAST_RULES_TL

[top of page]

Table: CSP_INV_LOC_ASSIGNMENTS

Primary Key: CSP_INV_LOC_ASSIGNMENTS_PK

1. CSP_INV_LOC_ASSIGNMENT_ID

Foreign Keys from this table:

Comments

This table stores the relationship between a resource (typically an engineer) and a subinventory/locator. If the DEFAULT_CODE is 'In" it means that this will be the default subinventory/locator for parts in transactions. "Out" in this column means that this subinventory/locator is the default for parts out transactions.

Indexes

Columns

[top of page]

CSP.CSP_INV_LOC_ASSIGNMENTS does not reference any database object

CSP.CSP_INV_LOC_ASSIGNMENTS is referenced by following:

APPS

SYNONYM - CSP_INV_LOC_ASSIGNMENTS

[top of page]

Table: CSP_LOOP_CALC_RULES_B

Primary Key: CSP_LOOP_CALC_RULES_B_PK

1. CALCULATION_RULE_ID

Foreign Keys to this table:

Comments

CSP_LOOP_CALC_RULES_B stores rules which are used by the concurrent program "Create Notifications" to decide wether different supply/demand information should be included in the calculations or not. The TOLERANCE_PERCENT is used to decide if the calculated result is inside tolerance level. The level is defined on the master stocklist.
TIME_FENCE is a number of days used to decide wether a transaction should be included in the calculation. TIME_FENCE is also used by the "Create Part Availability" concurrent program to include only those supplies/demands which are inside the TIME_FENCE.

Indexes

Columns

[top of page]

CSP.CSP_LOOP_CALC_RULES_B does not reference any database object

CSP.CSP_LOOP_CALC_RULES_B is referenced by following:

APPS

SYNONYM - CSP_LOOP_CALC_RULES_B

[top of page]

Table: CSP_LOOP_CALC_RULES_TL

Primary Key: CSP_LOOP_CALC_RULES_TL_PK

1. CALCULATION_RULE_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

Translated calculation rules definitions.

Indexes

Columns

[top of page]

CSP.CSP_LOOP_CALC_RULES_TL does not reference any database object

CSP.CSP_LOOP_CALC_RULES_TL is referenced by following:

APPS

SYNONYM - CSP_LOOP_CALC_RULES_TL

[top of page]

Table: CSP_MOVEORDER_HEADERS

Primary Key: CSP_MOVEORDER_HEADERS_PK

1. HEADER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_MOVEORDER_HEADERS stores extra information for a move order. The LOCATION_ID identifies the ship to address. The CARRIER is an indication of which carrier should be used to deliver this order. The SHIPMENT_METHOD indicates how the order should be delivered.

Indexes

Columns

[top of page]

CSP.CSP_MOVEORDER_HEADERS does not reference any database object

CSP.CSP_MOVEORDER_HEADERS is referenced by following:

APPS

SYNONYM - CSP_MOVEORDER_HEADERS

[top of page]

Table: CSP_MOVEORDER_LINES

Primary Key: CSP_MOVEORDER_LINES_PK

1. LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_MOVEORDER_LINES stores links to the Service Request and the Taks number.
CUSTOMER_PO identifies the customers purchase order number.

Indexes

Columns

[top of page]

CSP.CSP_MOVEORDER_LINES does not reference any database object

CSP.CSP_MOVEORDER_LINES is referenced by following:

APPS

SYNONYM - CSP_MOVEORDER_LINES

[top of page]

Table: CSP_MSTRSTCK_LISTS_ITMS

Primary Key: CSP_MSTRSTCK_LISTS_ITMS_PK

1. MSL_ID

Foreign Keys from this table:

Comments

CSP_MSTRSTCK_LISTS_ITMS holds the master stocklist for a Parts Loop. TOTAL_LOOP_QUANTITY shows how many units of this part should be available in the loop. TOTAL_LOOP_MIN_GOOD_QUANTITY shows how much of the total available quantity should be onhand good parts. PLANNER_CODE identifies the responsible planner of this part.

Indexes

Columns

[top of page]

CSP.CSP_MSTRSTCK_LISTS_ITMS does not reference any database object

CSP.CSP_MSTRSTCK_LISTS_ITMS is referenced by following:

APPS

SYNONYM - CSP_MSTRSTCK_LISTS_ITMS

[top of page]

Table: CSP_NOTIFICATIONS

Primary Key: CSP_NOTIFICATIONS_PK

1. NOTIFICATION_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_NOTIFICATIONS stores the result of the concurrent program "Create Notifications". Reason identifies one of 3 different types of notifications generated. Above (A) total quantity in loop, Below (B) total quantity in loop and Not enough good parts in loop (N). STATUS shows if it is an open, pending or closed notification.

Indexes

Columns

[top of page]

CSP.CSP_NOTIFICATIONS does not reference any database object

CSP.CSP_NOTIFICATIONS is referenced by following:

APPS

SYNONYM - CSP_NOTIFICATIONS

[top of page]

Table: CSP_NOTIFICATION_DETAILS

Primary Key: CSP_NOTIFICATION_DETAILS_PK1

1. NOTIFICATION_DETAIL_ID

Foreign Keys from this table:

Comments

This table stores recommendations for how a warehouse notification may be handled.

Indexes

Columns

[top of page]

CSP.CSP_NOTIFICATION_DETAILS does not reference any database object

CSP.CSP_NOTIFICATION_DETAILS is referenced by following:

APPS

SYNONYM - CSP_NOTIFICATION_DETAILS

[top of page]

Table: CSP_PACKLIST_BOXES

Primary Key: CSP_PACKLIST_BOXES_PK

1. BOX_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_PACKLIST_BOXES stores the weight and the name of a box used for packing parts on a move order.

Indexes

Columns

[top of page]

CSP.CSP_PACKLIST_BOXES does not reference any database object

CSP.CSP_PACKLIST_BOXES is referenced by following:

APPS

SYNONYM - CSP_PACKLIST_BOXES

[top of page]

Table: CSP_PACKLIST_HEADERS

Primary Key: CSP_PACKLIST_HEADERS_PK

1. PACKLIST_HEADER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_PACKLIST_HEADERS stores the shipping information for parts being shipped.
PACKLIST_LINE_STATUS shows in what state the packlist line is: Packed, shipped or received.
DATE_PACKED is the date when the packlist was completed. DATE_SHIPPED is the date when the packlist was shipped. DATE_RECEIVED is the date when the shipment was completely received.

Indexes

Columns

[top of page]

CSP.CSP_PACKLIST_HEADERS does not reference any database object

CSP.CSP_PACKLIST_HEADERS is referenced by following:

APPS

SYNONYM - CSP_PACKLIST_HEADERS

[top of page]

Table: CSP_PACKLIST_LINES

Primary Key: CSP_PACKLIST_LINES_PK

1. PACKLIST_LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_PACKLIST_LINES identifies the items being packed in the different boxes. PACKLIST_LINE_STATUS shows in what state the packlist line is: Packed, shipped or received.
QUANTITY_PACKED is the quantity of this item packed in this box. QUANTITY_SHIPPED is the quantity shipped. QUANTOTY_RECEIVED is the quantity received of this item.

Indexes

Columns

[top of page]

CSP.CSP_PACKLIST_LINES does not reference any database object

CSP.CSP_PACKLIST_LINES is referenced by following:

APPS

SYNONYM - CSP_PACKLIST_LINES

[top of page]

Table: CSP_PACKLIST_SERIAL_LOTS

Primary Key: CSP_PACKLIST_SERIAL_LOTS_PK

1. PACKLIST_SERIAL_LOT_ID

Foreign Keys from this table:

Comments

CSP_PACKLIST_SERIAL_LOTS stores information on which serial and lot numbers that go into the different boxes of a packlist.

Indexes

Columns

[top of page]

CSP.CSP_PACKLIST_SERIAL_LOTS does not reference any database object

CSP.CSP_PACKLIST_SERIAL_LOTS is referenced by following:

APPS

SYNONYM - CSP_PACKLIST_SERIAL_LOTS

[top of page]

Table: CSP_PARTS_LOOPS_B

Primary Key: CSP_PARTS_LOOP_B_PK

1. PARTS_LOOP_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_PARTS_LOOPS_B stores information about parts loops that are used to plan service parts. PLANNER_CODE identifies the responsible planner for this loop. CALCULATION_RULE_ID identifies the calculation rule to be used when generating notifications. FORECAST_RULE_ID identifies the forecast rule to be used when displaying the forecast in the Planner's Desktop.

Indexes

Columns

[top of page]

CSP.CSP_PARTS_LOOPS_B does not reference any database object

CSP.CSP_PARTS_LOOPS_B is referenced by following:

APPS

SYNONYM - CSP_PARTS_LOOPS_B

[top of page]

Table: CSP_PARTS_LOOPS_TL

Primary Key: CSP_PARTS_LOOPS_TL_PK

1. PARTS_LOOP_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

Translated Parts Loop definition

Indexes

Columns

[top of page]

CSP.CSP_PARTS_LOOPS_TL does not reference any database object

CSP.CSP_PARTS_LOOPS_TL is referenced by following:

APPS

SYNONYM - CSP_PARTS_LOOPS_TL

[top of page]

Table: CSP_PICKLIST_HEADERS

Primary Key: CSP_PICKLIST_HEADERS_PK

1. PICKLIST_HEADER_ID

Foreign Keys to this table:

Comments

CSP_PICKLIST_HEADERS stores the information about a picklist. PICKLIST_STATUS shows the status of the picklist. A picklist has 3 different states: Open (1), Printed (2) or Confirmed (3). CREATED_DATE is the date when the picklist was first printed. CONFIRMED_DATE is the date when the picklist was confirmed.

Indexes

Columns

[top of page]

CSP.CSP_PICKLIST_HEADERS does not reference any database object

CSP.CSP_PICKLIST_HEADERS is referenced by following:

APPS

SYNONYM - CSP_PICKLIST_HEADERS

[top of page]

Table: CSP_PICKLIST_LINES

Primary Key: CSP_PICKLIST_LINES_PK

1. PICKLIST_LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_PICKLIST_LINES stores the items that go on a picklist. TRANSACTION_TEMP_ID identifies the corresponding record in the MTL_MATERIAL_TRANSACTIONS_TEMP table.

Indexes

Columns

[top of page]

CSP.CSP_PICKLIST_LINES does not reference any database object

CSP.CSP_PICKLIST_LINES is referenced by following:

APPS

SYNONYM - CSP_PICKLIST_LINES

[top of page]

Table: CSP_PICKLIST_SERIAL_LOTS

Primary Key: CSP_PICKLIST_SERIAL_LOTS_PK

1. PICKLIST_SERIAL_LOT_ID

Foreign Keys from this table:

Comments

CSP_PICKLIST_SERIAL_LOTS stores information on which serial and lot numbers that was picked.

Indexes

Columns

[top of page]

CSP.CSP_PICKLIST_SERIAL_LOTS does not reference any database object

CSP.CSP_PICKLIST_SERIAL_LOTS is referenced by following:

APPS

SYNONYM - CSP_PICKLIST_SERIAL_LOTS

[top of page]

Table: CSP_PLANNING_PARAMETERS

Primary Key: CSP_PLANNING_PARAMETERS_PK

1. PLANNING_PARAMETERS_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

CSP_PLANNING_PARAMETERS stores information about parameters used in Authorised Stock List planning for Organizations and Subinventories. ORGANIZATION_TYPE identifies if the Organization is Warehouse or Field Engineer Organization. FORECAST_RULE_ID identifies the Forecast rule to be used when generating Authorised Stock List recommendations. CALCULATION_RULE_ID identifies the calculation rule used. EXCESS_RULE_ID identifies the Excess Parts Rule used. SERVICE_LEVEL identifies the Service Level required for an Organization or Subinventory. EDQ_FACTOR identifies the Economic Delivery Quantity value. ASL_FLAG identifies if Authorised Stock List is applicable for an Organization or Subinventory. SAFETY_STOCK_FLAG identifies if Safety Stock needs to be used for the Organization/Subinventory. CONIDTION_TYPE identifies the condition of the Subinventory. PLANNER_CODE identifies the responsible planner for the Organization.

Indexes

Columns

[top of page]

CSP.CSP_PLANNING_PARAMETERS does not reference any database object

CSP.CSP_PLANNING_PARAMETERS is referenced by following:

APPS

SYNONYM - CSP_PLANNING_PARAMETERS

MATERIALIZED VIEW - CSP_SUP_DEM_PN_MV

MATERIALIZED VIEW - CSP_USAGE_ORG_MV

MATERIALIZED VIEW - CSP_USAGE_REG_MV

[top of page]

Table: CSP_PRODUCT_POPULATIONS

Primary Key: CSP_PRODUCT_POPULATIONS_PK

1. PRODUCT_POPULATION_ID

Foreign Keys from this table:

Comments

This table stores the population of a product in a region. It also stores population changes used in the Product Norm planning.

Indexes

Columns