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: |
---|
Index | Type | Tablespace | Column |
---|---|---|---|
SYS_IL0000510128C00023$$ | UNIQUE | SYSTEM | |
SYS_IL0000510128C00024$$ | UNIQUE | SYSTEM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | |||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
SOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
REQUIRED_ITEM_ID | NUMBER | |||
REQUIRED_ITEM_REV | VARCHAR2 | (3) | ||
REQUIRED_QUANTITY | NUMBER | |||
SUPPLIED_ITEM_ID | NUMBER | |||
SUPPLIED_ITEM_REV | VARCHAR2 | (3) | ||
SUPPLIED_QUANTITY | NUMBER | |||
SUPPLIED_ITEM_TYPE | VARCHAR2 | (10) | ||
SHIPPING_DATE | DATE | |||
SHIPPING_METHOD | VARCHAR2 | (30) | ||
SHIPPING_COST | NUMBER | |||
ARRIVAL_DATE | DATE | |||
DISTANCE | NUMBER | |||
OPEN_OR_CLOSED | VARCHAR2 | (10) | ||
GEOMETRY | SDO_GEOMETRY | (1) |
Description: | This table stores the deliver time related information |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_CARRIER_DELIVERY_TIMES.TIMEZONE_ID | HZ_TIMEZONES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_CARRIER_DELIVERY_TIMES_U1 | UNIQUE | APPS_TS_TX_IDX | RELATION_SHIP_ID |
CSP_CARRIER_DELIVERY_TIMES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SHIPPING_METHOD
ORGANIZATION_ID |
CSP_CARRIER_DELIVERY_TIMES_N2 | NONUNIQUE | APPS_TS_TX_IDX | FREIGHT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELATION_SHIP_ID | NUMBER | (35) | Y | Relationship identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization Identifer |
FREIGHT_CODE | VARCHAR2 | (30) | Freight Code | |
SHIPPING_METHOD | VARCHAR2 | (30) | Y | Shipping methode Code |
LEAD_TIME | NUMBER | Lead time | ||
LEAD_TIME_UOM | VARCHAR2 | (3) | Unit of measure code | |
DELIVERY_TIME | DATE | Delivery time | ||
CUTOFF_TIME | DATE | Cutoff time | ||
TIMEZONE_ID | NUMBER | (35) | Timezone identifier | |
SAFETY_ZONE | NUMBER | Saftey zone | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | (35) | Security group identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory name | |
LOCATION_ID | NUMBER | (38) | Location identifier | |
DISTANCE | NUMBER | |||
DISTANCE_UOM | VARCHAR2 | (10) |
CSP.CSP_CARRIER_DELIVERY_TIMES does not reference any database object
CSP.CSP_CARRIER_DELIVERY_TIMES is referenced by following:
Description: | Summarized supply and demand information. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_CURR_SUP_DEM_SUMS.HIERARCHY_NODE_ID | CSP_REP_HIERARCHIES |
CSP_CURR_SUP_DEM_SUMS.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
CSP_CURR_SUP_DEM_SUMS.INVENTORY_ITEM_ID
CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_CURR_SUP_DEM_SUMS.SUBINVENTORY_CODE
CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
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".
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_CURR_SUP_DEM_SUMS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID |
CSP_CURR_SUP_DEM_SUMS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SUBINVENTORY_CODE |
CSP_CURR_SUP_DEM_SUMS_N3 | NONUNIQUE | APPS_TS_TX_IDX | HIERARCHY_NODE_ID |
CSP_CURR_SUP_DEM_SUMS_N4 | NONUNIQUE | APPS_TS_TX_IDX | PARTS_LOOP_ID |
CSP_CURR_SUP_DEM_SUMS_N5 | NONUNIQUE | APPS_TS_TX_IDX | PLANNING_PARAMETERS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLY_DEMAND_ID | NUMBER | (35) | Supply demand unique identifier | |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
REQUEST_ID | NUMBER | (35) | Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (35) | Standard Who Column | |
PROGRAM_ID | NUMBER | (35) | Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
HIERARCHY_NODE_ID | NUMBER | (35) | Hierarchy node identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory identifier | |
ONHAND_BAD | NUMBER | (35) | Quantity of onhand bad parts | |
ONHAND_GOOD | NUMBER | (35) | Quantity of onhand good parts | |
INTRANSIT_MOVE_ORDERS | NUMBER | (35) | Quantity of item on moveorders being in transit | |
OPEN_INTERORG_TRANSF_IN | NUMBER | (35) | Quantity of item on interorganization transfers expected in | |
OPEN_INTERORG_TRANSF_OUT | NUMBER | (35) | Quantity of item on interorganization transfers expected out | |
OPEN_SALES_ORDERS | NUMBER | (35) | Quantity of item on open sales orders | |
OPEN_MOVE_ORDERS_IN | NUMBER | (35) | Quantity of item on moveorders expected in | |
OPEN_MOVE_ORDERS_OUT | NUMBER | (35) | Quantity of item on moveorders expected out | |
OPEN_REQUISITIONS | NUMBER | (35) | Quantity of item on open requisitions | |
OPEN_PURCHASE_ORDERS | NUMBER | (35) | Quantity of item on open purchase orders | |
OPEN_WORK_ORDERS | NUMBER | (35) | Quantity of item on open work orders | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
PLANNING_PARAMETERS_ID | NUMBER | (35) | Planning node identifier | |
EXCESS_QUANTITY | NUMBER | (35) | Excess quantity of item |
CSP.CSP_CURR_SUP_DEM_SUMS does not reference any database object
CSP.CSP_CURR_SUP_DEM_SUMS is referenced by following:
Description: | Excess Spare Parts |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_EXCESS_LISTS.INVENTORY_ITEM_ID
CSP_EXCESS_LISTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_EXCESS_LISTS.SUBINVENTORY_CODE
CSP_EXCESS_LISTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_EXCESS_LISTS.REQUISITION_LINE_ID | PO_REQUISITION_HEADERS_ALL |
Foreign Key Column | Foreign Table |
---|---|
CSP_EXCESS_LIST_SERIAL_LOTS.EXCESS_LINE_ID | CSP_EXCESS_LISTS |
CSP_EXCESS_LISTS store the list of items available more than maximum level in subinvetories or organization
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_EXCESS_LISTS_U1 | UNIQUE | APPS_TS_TX_IDX | EXCESS_LINE_ID |
CSP_EXCESS_LISTS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID |
CSP_EXCESS_LISTS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SUBINVENTORY_CODE |
CSP_EXCESS_LISTS_N3 | NONUNIQUE | APPS_TS_TX_IDX | REQUISITION_LINE_ID |
CSP_EXCESS_LISTS_N4 | NONUNIQUE | APPS_TS_TX_IDX | RETURN_ORGANIZATION_ID |
CSP_EXCESS_LISTS_N5 | NONUNIQUE | APPS_TS_TX_IDX |
RETURN_ORGANIZATION_ID
RETURN_SUBINVENTORY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCESS_LINE_ID | NUMBER | (35) | Y | Excesslist unique Identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
EXCESS_QUANTITY | NUMBER | (35) | Y | Excess Quantity |
CONDITION_CODE | VARCHAR2 | (30) | Y | Item Condition code |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory identifier | |
RETURNED_QUANTITY | NUMBER | (35) | Returned Quantity | |
CURRENT_RETURN_QTY | NUMBER | (35) | Current return quantity | |
REQUISITION_LINE_ID | NUMBER | (35) | Requisition Identifier | |
EXCESS_STATUS | VARCHAR2 | (30) | Excess status | |
REASON_CODE | VARCHAR2 | (240) | Reason why excess was not returned. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments | |
RETURN_ORGANIZATION_ID | NUMBER | (35) | Return to organization id | |
RETURN_SUBINVENTORY_NAME | VARCHAR2 | (10) | Return to subinventory |
CSP.CSP_EXCESS_LISTS does not reference any database object
CSP.CSP_EXCESS_LISTS is referenced by following:
Description: | Excess list serial and lot numbers |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_EXCESS_LIST_SERIAL_LOTS.EXCESS_LINE_ID | CSP_EXCESS_LISTS |
CSP_EXCESS_LIST_SERIAL_LOTS stores information of excess items serial and lot numbers that are returned.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_EXCESS_LIST_SERIAL_LOTS_U1 | UNIQUE | APPS_TS_TX_IDX | EXCESS_LIST_SERIAL_LOT_ID |
CSP_EXCESS_LIST_SERIAL_LOTS_N1 | NONUNIQUE | APPS_TS_TX_IDX | EXCESS_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCESS_LIST_SERIAL_LOT_ID | NUMBER | (35) | Y | Excess list serial and lot unique identifier |
EXCESS_LINE_ID | NUMBER | (35) | Y | Excess line identifier |
QUANTITY | NUMBER | (35) | Y | Quantity |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
LOT_NUMBER | VARCHAR2 | (240) | Lot Number | |
SERIAL_NUMBER | VARCHAR2 | (240) | Serial number | |
REVISION | VARCHAR2 | (240) | Revision | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments | |
LOCATOR_ID | NUMBER | Locator identifier |
CSP.CSP_EXCESS_LIST_SERIAL_LOTS does not reference any database object
CSP.CSP_EXCESS_LIST_SERIAL_LOTS is referenced by following:
Description: | To Store Excess Rules |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_EXCESS_RULES_B.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
CSP_EXCESS_RULES_B.CATEGORY_ID | MTL_CATEGORIES_B |
Foreign Key Column | Foreign Table |
---|---|
CSP_EXCESS_RULES_TL.EXCESS_RULE_ID | CSP_EXCESS_RULES_B |
CSP_PLANNING_PARAMETERS.EXCESS_RULE_ID | CSP_EXCESS_RULES_B |
This table is used for defining excess rules.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_EXCESS_RULES_B_U1 | UNIQUE | APPS_TS_TX_IDX | EXCESS_RULE_ID |
CSP_EXCESS_RULES_B_U2 | UNIQUE | APPS_TS_TX_IDX | EXCESS_RULE_NAME |
CSP_EXCESS_RULES_B_N1 | NONUNIQUE | APPS_TS_TX_IDX |
CATEGORY_ID
CATEGORY_SET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCESS_RULE_ID | NUMBER | (35) | Y | To store unique id |
EXCESS_RULE_NAME | VARCHAR2 | (30) | Y | Excess Rule Name |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
TOTAL_MAX_EXCESS | NUMBER | Percent of Maximum of all parts | ||
LINE_MAX_EXCESS | NUMBER | Maximum percentage of excess parts | ||
DAYS_SINCE_RECEIPT | NUMBER | (35) | No of days since parts received | |
TOTAL_EXCESS_VALUE | NUMBER | Total value of excess parts | ||
TOP_EXCESS_LINES | NUMBER | (35) | Top excess lines | |
CATEGORY_SET_ID | NUMBER | (35) | Category set Identifier | |
CATEGORY_ID | NUMBER | (35) | Category Identfier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | (35) | Security group identifier |
CSP.CSP_EXCESS_RULES_B does not reference any database object
CSP.CSP_EXCESS_RULES_B is referenced by following:
Description: | Translated Excess rules definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_EXCESS_RULES_TL.EXCESS_RULE_ID | CSP_EXCESS_RULES_B |
Translated Excess rules definitions.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_EXCESS_RULES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
EXCESS_RULE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCESS_RULE_ID | NUMBER | (35) | Y | Excess Rule Identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard who column | |
SOURCE_LANG | VARCHAR2 | (4) | Langauge from which things are translated | |
LANGUAGE | VARCHAR2 | (4) | Y | Language of Text. The language to which things are translated. |
DESCRIPTION | VARCHAR2 | (240) | Description of Excess rule | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments |
CSP.CSP_EXCESS_RULES_TL does not reference any database object
CSP.CSP_EXCESS_RULES_TL is referenced by following:
Description: | Stores component's failure rates for a product. |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_FAILURE_RATES_U1 | UNIQUE | APPS_TS_TX_IDX | FAILURE_RATE_ID |
CSP_FAILURE_RATES_U2 | UNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
PRODUCT_ID PLANNING_PARAMETERS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FAILURE_RATE_ID | NUMBER | (38) | Y | Failure rate identifier |
CREATED_BY | NUMBER | (38) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (38) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who column | |
PRODUCT_ID | NUMBER | (38) | Y | Product identifier. |
INVENTORY_ITEM_ID | NUMBER | (38) | Y | Component identifier |
CALCULATED_FAILURE_RATE | NUMBER | Calculated failure rate | ||
MANUAL_FAILURE_RATE | NUMBER | Manually entered failure rate | ||
PLANNING_PARAMETERS_ID | NUMBER | (38) | Y | Planning parameter identifier |
SECURITY_GROUP_ID | NUMBER | (38) | Used in hosted environments |
CSP.CSP_FAILURE_RATES does not reference any database object
CSP.CSP_FAILURE_RATES is referenced by following:
Description: | Stores forecast rules |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_FORECAST_RULES_TL.FORECAST_RULE_ID | CSP_FORECAST_RULES_B |
CSP_MSTRSTCK_LISTS_ITMS.FORECAST_RULE_ID | CSP_FORECAST_RULES_B |
CSP_PARTS_LOOPS_B.FORECAST_RULE_ID | CSP_FORECAST_RULES_B |
CSP_PLANNING_PARAMETERS.FORECAST_RULE_ID | CSP_FORECAST_RULES_B |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_FORECAST_RULES_B_U1 | UNIQUE | APPS_TS_TX_IDX | FORECAST_RULE_ID |
CSP_FORECAST_RULES_B_U2 | UNIQUE | APPS_TS_TX_IDX | FORECAST_RULE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_RULE_ID | NUMBER | (35) | Y | Forecast rule unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
FORECAST_RULE_NAME | VARCHAR2 | (240) | Y | Forecast rule name |
PERIOD_TYPE | VARCHAR2 | (30) | Y | Not used. |
FORECAST_PERIODS | NUMBER | (35) | Y | Number of forecast periods that wil be generated |
FORECAST_METHOD | VARCHAR2 | (30) | Y | Forecast method 1=Simple Average 2=Weighted Average 3=Exponential Smoothing 4=Trend Enhanced |
HISTORY_PERIODS | NUMBER | (35) | Y | Number of history periods to base forecast on |
ALPHA | NUMBER | (35) | Alpha factor used by Exponential Smoothing and Trend Enhanced | |
BETA | NUMBER | (35) | Beta factor used by Trend Enhanced | |
WEIGHTED_AVG_PERIOD1 | NUMBER | Weight to put on history period 1 for Weighted Average | ||
WEIGHTED_AVG_PERIOD2 | NUMBER | Weight to put on history period 2 for Weighted Average | ||
WEIGHTED_AVG_PERIOD3 | NUMBER | Weight to put on history period 3 for Weighted Average | ||
WEIGHTED_AVG_PERIOD4 | NUMBER | Weight to put on history period 4 for Weighted Average | ||
WEIGHTED_AVG_PERIOD5 | NUMBER | Weight to put on history period 5 for Weighted Average | ||
WEIGHTED_AVG_PERIOD6 | NUMBER | Weight to put on history period 6 for Weighted Average | ||
WEIGHTED_AVG_PERIOD7 | NUMBER | Weight to put on history period 7 for Weighted Average | ||
WEIGHTED_AVG_PERIOD8 | NUMBER | Weight to put on history period 8 for Weighted Average | ||
WEIGHTED_AVG_PERIOD9 | NUMBER | Weight to put on history period 9 for Weighted Average | ||
WEIGHTED_AVG_PERIOD10 | NUMBER | Weight to put on history period 10 for Weighted Average | ||
WEIGHTED_AVG_PERIOD11 | NUMBER | Weight to put on history period 11 for Weighted Average | ||
WEIGHTED_AVG_PERIOD12 | NUMBER | Weight to put on history period 12 for Weighted Average | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
PERIOD_SIZE | NUMBER | (35) | Period size | |
TRACKING_SIGNAL_CYCLE | NUMBER | (35) | Number of tracking signal cycles |
CSP.CSP_FORECAST_RULES_B does not reference any database object
CSP.CSP_FORECAST_RULES_B is referenced by following:
Description: | Translated forecast rules definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_FORECAST_RULES_TL.FORECAST_RULE_ID | CSP_FORECAST_RULES_B |
Translated forecast rules definitions.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_FORECAST_RULES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
FORECAST_RULE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_RULE_ID | NUMBER | (35) | Y | Forecast rule unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
SOURCE_LANG | VARCHAR2 | (4) | Y | Langauge from which things are translated |
LANGUAGE | VARCHAR2 | (4) | Y | Language of Text. The language to which things are translated. |
DESCRIPTION | VARCHAR2 | (240) | Description of forecast rule | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_FORECAST_RULES_TL does not reference any database object
CSP.CSP_FORECAST_RULES_TL is referenced by following:
Description: | Inventory location assignments to resources |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_INV_LOC_ASSIGNMENTS.SUBINVENTORY_CODE
CSP_INV_LOC_ASSIGNMENTS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_INV_LOC_ASSIGNMENTS.LOCATOR_ID
CSP_INV_LOC_ASSIGNMENTS.ORGANIZATION_ID |
MTL_ITEM_LOCATIONS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_INV_LOC_ASSIGNMENTS_U1 | UNIQUE | APPS_TS_TX_IDX | CSP_INV_LOC_ASSIGNMENT_ID |
CSP_INV_LOC_ASSIGNMENTS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SUBINVENTORY_CODE
ORGANIZATION_ID |
CSP_INV_LOC_ASSIGNMENTS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
LOCATOR_ID
ORGANIZATION_ID |
CSP_INV_LOC_ASSIGNMENTS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_TYPE
RESOURCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CSP_INV_LOC_ASSIGNMENT_ID | NUMBER | (35) | Y | Inventory location assigment unique identifer |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
RESOURCE_ID | NUMBER | (35) | Y | Resource identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Y | Subinventory identifier |
LOCATOR_ID | NUMBER | (35) | Locator identifier | |
RESOURCE_TYPE | VARCHAR2 | (30) | Y | Type of resource |
EFFECTIVE_DATE_START | DATE | Start date of assignment | ||
EFFECTIVE_DATE_END | DATE | End date of assignment | ||
DEFAULT_CODE | VARCHAR2 | (30) | Default value for parts in and parts out transactions. IN=default inventory location for parts in OUT=default inventory location for parts out | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defiing column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_INV_LOC_ASSIGNMENTS does not reference any database object
CSP.CSP_INV_LOC_ASSIGNMENTS is referenced by following:
Description: | Stores calculation rules |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_LOOP_CALC_RULES_TL.CALCULATION_RULE_ID | CSP_LOOP_CALC_RULES_B |
CSP_PARTS_LOOPS_B.CALCULATION_RULE_ID | CSP_LOOP_CALC_RULES_B |
CSP_PLANNING_PARAMETERS.CALCULATION_RULE_ID | CSP_LOOP_CALC_RULES_B |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_LOOP_CALC_RULES_B_U1 | UNIQUE | APPS_TS_TX_IDX | CALCULATION_RULE_ID |
CSP_LOOP_CALC_RULES_B_U2 | UNIQUE | APPS_TS_TX_IDX | CALCULATION_RULE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALCULATION_RULE_ID | NUMBER | (35) | Y | Calculation rule unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
CALCULATION_RULE_NAME | VARCHAR2 | (150) | Y | Calculation rule name |
INCLUDE_SALES_ORDERS | VARCHAR2 | (30) | Y | Include sales orders Y/N |
INCLUDE_MOVE_ORDERS | VARCHAR2 | (30) | Include moveorders Y/N | |
INCLUDE_REPAIR_ORDERS | VARCHAR2 | (30) | Y | Include repair orders Y/N |
INCLUDE_WORK_ORDERS | VARCHAR2 | (30) | Y | Include work orders Y/N |
INCLUDE_PURCHASE_ORDERS | VARCHAR2 | (30) | Y | Include purchase orders Y/N |
INCLUDE_REQUISITIONS | VARCHAR2 | (30) | Y | Include requisitions Y/N |
INCLUDE_INTERORG_TRANSFERS | VARCHAR2 | (30) | Y | Include interorganization transfers Y/N |
INCLUDE_ONHAND_GOOD | VARCHAR2 | (30) | Y | Include onhand good Y/N |
INCLUDE_ONHAND_BAD | VARCHAR2 | (30) | Y | Include onhand bad Y/N |
INCLUDE_INTRANSIT_MOVE_ORDERS | VARCHAR2 | (30) | Include intransit moveorders Y/N | |
TOLERANCE_PERCENT | NUMBER | (35) | Y | Tolerence percent |
TIME_FENCE | NUMBER | (35) | Y | Time fence |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
INCLUDE_DOA | VARCHAR2 | (30) | Include Defective on Arrival Y/N | |
ROLLUP_SUPERCESSION | VARCHAR2 | (30) | Rollup supercession | |
FORECAST_LOWER_SUPERCESSION | VARCHAR2 | (30) | Forecase lower supercession |
CSP.CSP_LOOP_CALC_RULES_B does not reference any database object
CSP.CSP_LOOP_CALC_RULES_B is referenced by following:
Description: | Translated calculation rules definitions |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_LOOP_CALC_RULES_TL.CALCULATION_RULE_ID | CSP_LOOP_CALC_RULES_B |
Translated calculation rules definitions.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_LOOP_CALC_RULES_TL_U1 | UNIQUE | APPS_TS_TX_IDX |
CALCULATION_RULE_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CALCULATION_RULE_ID | NUMBER | (35) | Y | Calculation rule unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
LANGUAGE | VARCHAR2 | (4) | Y | Language of Text. The language to which things are translated |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language from which things are translated. |
DESCRIPTION | VARCHAR2 | (240) | Description of calculation rule | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_LOOP_CALC_RULES_TL does not reference any database object
CSP.CSP_LOOP_CALC_RULES_TL is referenced by following:
Description: | Holds extra information for moveorder headers |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_MOVEORDER_HEADERS.HEADER_ID | MTL_TXN_REQUEST_HEADERS |
Foreign Key Column | Foreign Table |
---|---|
CSP_MOVEORDER_LINES.HEADER_ID | CSP_MOVEORDER_HEADERS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_MOVEORDER_HEADERS_U1 | UNIQUE | APPS_TS_TX_IDX | HEADER_ID |
CSP_MOVEORDER_HEADERS_N1 | NONUNIQUE | APPS_TS_TX_IDX | LOCATION_ID |
CSP_MOVEORDER_HEADERS_N2 | NONUNIQUE | APPS_TS_TX_IDX | PARTY_SITE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | (35) | Y | Moveorder header unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
CARRIER | VARCHAR2 | (30) | Freight carrier | |
SHIPMENT_METHOD | VARCHAR2 | (30) | Shipment method | |
AUTORECEIPT_FLAG | VARCHAR2 | (30) | Autoreceipt flag Y=autoreceipt N=manual receipt | |
LOCATION_ID | NUMBER | (35) | Location identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
PARTY_SITE_ID | NUMBER | (35) | Party Site Identifier |
CSP.CSP_MOVEORDER_HEADERS does not reference any database object
CSP.CSP_MOVEORDER_HEADERS is referenced by following:
Description: | Holds extra information for moveorder lines |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_MOVEORDER_LINES.HEADER_ID | CSP_MOVEORDER_HEADERS |
CSP_MOVEORDER_LINES.HEADER_ID | MTL_TXN_REQUEST_HEADERS |
CSP_MOVEORDER_LINES.LINE_ID | MTL_TXN_REQUEST_LINES |
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_LINES.LINE_ID | CSP_MOVEORDER_LINES |
CSP_PICKLIST_LINES.LINE_ID | CSP_MOVEORDER_LINES |
CSP_MOVEORDER_LINES stores links to the Service Request and the Taks number.
CUSTOMER_PO identifies the customers purchase order number.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_MOVEORDER_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | LINE_ID |
CSP_MOVEORDER_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX | HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | (35) | Y | Moveorder line unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_LOGIN | NUMBER | (35) | Standard Who column | |
HEADER_ID | NUMBER | (35) | Y | Moveorder header unique identifier |
CUSTOMER_PO | VARCHAR2 | (30) | Customer's purchase order number | |
INCIDENT_ID | NUMBER | (35) | Service request identifier | |
TASK_ID | NUMBER | (35) | Task identifier | |
TASK_ASSIGNMENT_ID | NUMBER | (35) | Task assignment identifier | |
COMMENTS | VARCHAR2 | (240) | Moveorder comments | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_MOVEORDER_LINES does not reference any database object
CSP.CSP_MOVEORDER_LINES is referenced by following:
Description: | Master stocklist |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_MSTRSTCK_LISTS_ITMS.PARTS_LOOPS_ID | CSP_PARTS_LOOPS_B |
CSP_MSTRSTCK_LISTS_ITMS.PLANNER_CODE
CSP_MSTRSTCK_LISTS_ITMS.ORGANIZATION_ID |
MTL_PLANNERS |
CSP_MSTRSTCK_LISTS_ITMS.INVENTORY_ITEM_ID
CSP_MSTRSTCK_LISTS_ITMS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_MSTRSTCK_LISTS_ITMS.FORECAST_RULE_ID | CSP_FORECAST_RULES_B |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_MSTRSTCK_LISTS_ITMS_U1 | UNIQUE | APPS_TS_TX_IDX | MSL_ID |
CSP_MSTRSTCK_LISTS_ITMS_N1 | NONUNIQUE | APPS_TS_TX_IDX | PARTS_LOOPS_ID |
CSP_MSTRSTCK_LISTS_ITMS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MSL_ID | NUMBER | (35) | Y | Master stocklist unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_LOGIN | NUMBER | (35) | Standard Who column | |
PARTS_LOOPS_ID | NUMBER | (35) | Y | Parts loop identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
REVISION | VARCHAR2 | (3) | Item revision | |
FORECAST_RULE_ID | NUMBER | (35) | Forecast rule identifier | |
TOTAL_LOOP_QUANTITY | NUMBER | (35) | Y | Total quantity in parts loop for this item |
TOTAL_LOOP_MIN_GOOD_QUANTITY | NUMBER | Minimum quantity onhand good for this item | ||
PLANNER_CODE | VARCHAR2 | (10) | Y | Planner identifier |
PLANNING_TYPE_CODE | VARCHAR2 | (30) | Planning type. 1=Reorder point planning 2=Min-max planning 4=MPS planning 6=Not planned | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_MSTRSTCK_LISTS_ITMS does not reference any database object
CSP.CSP_MSTRSTCK_LISTS_ITMS is referenced by following:
Description: | Holds parts loop notifications |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_NOTIFICATIONS.PLANNER_CODE
CSP_NOTIFICATIONS.ORGANIZATION_ID |
MTL_PLANNERS |
CSP_NOTIFICATIONS.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
CSP_NOTIFICATIONS.INVENTORY_ITEM_ID
CSP_NOTIFICATIONS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
Foreign Key Column | Foreign Table |
---|---|
CSP_NOTIFICATION_DETAILS.NOTIFICATION_ID | CSP_NOTIFICATIONS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_NOTIFICATIONS_U1 | UNIQUE | APPS_TS_TX_IDX | NOTIFICATION_ID |
CSP_NOTIFICATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
PLANNER_CODE
ORGANIZATION_ID |
CSP_NOTIFICATIONS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
PARTS_LOOP_ID
INVENTORY_ITEM_ID |
CSP_NOTIFICATIONS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOTIFICATION_ID | NUMBER | (35) | Y | Notification unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
REQUEST_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
PLANNER_CODE | VARCHAR2 | (10) | Planner identifier | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
NOTIFICATION_DATE | DATE | Y | Date of notification | |
REASON | VARCHAR2 | (240) | Y | Notification reason A=Above B=Below N=Not enough good parts |
STATUS | VARCHAR2 | (30) | Y | Notification status 1=Open 2=Pending 3=Closed |
QUANTITY | NUMBER | (35) | Quantity | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
NEED_DATE | DATE | Need by date | ||
SUPPRESS_END_DATE | DATE | Notification suppressed till this date | ||
NOTIFICATION_TYPE | VARCHAR2 | (30) | Notification type |
CSP.CSP_NOTIFICATIONS does not reference any database object
CSP.CSP_NOTIFICATIONS is referenced by following:
Description: | Details on how to handle a warehouse notification. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_NOTIFICATION_DETAILS.NOTIFICATION_ID | CSP_NOTIFICATIONS |
CSP_NOTIFICATION_DETAILS.INVENTORY_ITEM_ID
CSP_NOTIFICATION_DETAILS.SOURCE_ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
This table stores recommendations for how a warehouse notification may be handled.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_NOTIFICATION_DETAILS_U1 | NONUNIQUE | APPS_TS_TX_IDX | NOTIFICATION_DETAIL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOTIFICATION_DETAIL_ID | NUMBER | (38) | Y | Nofication detail identifier |
CREATED_BY | NUMBER | (38) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (38) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who column | |
NOTIFICATION_ID | NUMBER | (38) | Y | Notification identifier |
INVENTORY_ITEM_ID | NUMBER | (38) | Y | Inventory item identifier |
AVAILABLE_QUANTITY | NUMBER | (38) | Y | Available quantity |
ORDER_BY_DATE | DATE | Y | Order by date | |
SOURCE_TYPE | VARCHAR2 | (30) | Y | Source type |
SOURCE_ORGANIZATION_ID | NUMBER | (38) | Source organization identifier | |
SOURCE_SUBINVENTORY | VARCHAR2 | (30) | Source subinventory | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | (38) | Used in hosted environments | |
REPAIR_SUPPLIER_ID | NUMBER | (38) | Repair Supplier Identifier | |
ORDER_NUMBER | NUMBER | Order Number |
CSP.CSP_NOTIFICATION_DETAILS does not reference any database object
CSP.CSP_NOTIFICATION_DETAILS is referenced by following:
Description: | Packlist Boxes |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_BOXES.PACKLIST_HEADER_ID | CSP_PACKLIST_HEADERS |
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_LINES.BOX_ID | CSP_PACKLIST_BOXES |
CSP_PACKLIST_BOXES stores the weight and the name of a box used for packing parts on a move order.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PACKLIST_BOXES_U1 | UNIQUE | APPS_TS_TX_IDX | BOX_ID |
CSP_PACKLIST_BOXES_N1 | NONUNIQUE | APPS_TS_TX_IDX | PACKLIST_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOX_ID | NUMBER | (35) | Y | Box identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
BOX_NAME | VARCHAR2 | (30) | Y | Box name |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PACKLIST_HEADER_ID | NUMBER | (35) | Y | Packlist unique identifier |
WEIGHT | NUMBER | (35) | Weight | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_PACKLIST_BOXES does not reference any database object
CSP.CSP_PACKLIST_BOXES is referenced by following:
Description: | Packlist headers |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_HEADERS.SUBINVENTORY_CODE
CSP_PACKLIST_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_BOXES.PACKLIST_HEADER_ID | CSP_PACKLIST_HEADERS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PACKLIST_HEADERS_U1 | UNIQUE | APPS_TS_TX_IDX | PACKLIST_HEADER_ID |
CSP_PACKLIST_HEADERS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PACKLIST_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PACKLIST_HEADER_ID | NUMBER | (35) | Y | Packlist unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PACKLIST_NUMBER | VARCHAR2 | (10) | Y | Packlist number |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory identifier | |
PACKLIST_STATUS | VARCHAR2 | (30) | Y | Packlist status |
DATE_CREATED | DATE | Y | Date packlist was created | |
DATE_PACKED | DATE | Date packlist was packed | ||
DATE_SHIPPED | DATE | Date packlist was shipped | ||
DATE_RECEIVED | DATE | Date packlist was completely received | ||
CARRIER | VARCHAR2 | (60) | Freight carrier | |
SHIPMENT_METHOD | VARCHAR2 | (60) | Shipment method | |
WAYBILL | VARCHAR2 | (60) | Carrier's waybill number | |
COMMENTS | VARCHAR2 | (240) | Packlist comments | |
LOCATION_ID | NUMBER | (35) | Location identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
PARTY_SITE_ID | NUMBER | (35) | Party Site Identifier |
CSP.CSP_PACKLIST_HEADERS does not reference any database object
CSP.CSP_PACKLIST_HEADERS is referenced by following:
Description: | Packlist lines |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_LINES.INVENTORY_ITEM_ID
CSP_PACKLIST_LINES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_PACKLIST_LINES.LINE_ID | MTL_TXN_REQUEST_LINES |
CSP_PACKLIST_LINES.BOX_ID | CSP_PACKLIST_BOXES |
CSP_PACKLIST_LINES.PICKLIST_LINE_ID | CSP_PICKLIST_LINES |
CSP_PACKLIST_LINES.LINE_ID | CSP_MOVEORDER_LINES |
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_SERIAL_LOTS.PACKLIST_LINE_ID | CSP_PACKLIST_LINES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PACKLIST_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | PACKLIST_LINE_ID |
CSP_PACKLIST_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID |
CSP_PACKLIST_LINES_N2 | NONUNIQUE | APPS_TS_TX_IDX | LINE_ID |
CSP_PACKLIST_LINES_N3 | NONUNIQUE | APPS_TS_TX_IDX | BOX_ID |
CSP_PACKLIST_LINES_N4 | NONUNIQUE | APPS_TS_TX_IDX | PICKLIST_LINE_ID |
CSP_PACKLIST_LINES_N5 | NONUNIQUE | APPS_TS_TX_IDX | PACKLIST_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PACKLIST_LINE_ID | NUMBER | (35) | Y | Packlist line unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PACKLIST_LINE_NUMBER | NUMBER | (35) | Y | Packlist line number |
PACKLIST_HEADER_ID | NUMBER | (35) | Y | Packlist unique identifier |
BOX_ID | NUMBER | (35) | Y | Box identifier |
PICKLIST_LINE_ID | NUMBER | (35) | Picklist line identifier | |
LINE_ID | NUMBER | (35) | Y | Moverorder line identifier |
PACKLIST_LINE_STATUS | VARCHAR2 | (30) | Y | Packlist line status 1=Open 2=Shipped 3=Received |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
UOM_CODE | VARCHAR2 | (3) | Y | Unit of measure |
QUANTITY_PACKED | NUMBER | (35) | Y | Quantity packed |
QUANTITY_SHIPPED | NUMBER | (35) | Quantity shipped | |
QUANTITY_RECEIVED | NUMBER | (35) | Quantity received | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_PACKLIST_LINES does not reference any database object
CSP.CSP_PACKLIST_LINES is referenced by following:
Description: | Packlist serial and lot numbers |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_SERIAL_LOTS.PACKLIST_LINE_ID | CSP_PACKLIST_LINES |
CSP_PACKLIST_SERIAL_LOTS.SERIAL_NUMBER
CSP_PACKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID CSP_PACKLIST_SERIAL_LOTS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
CSP_PACKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID
CSP_PACKLIST_SERIAL_LOTS.ORGANIZATION_ID CSP_PACKLIST_SERIAL_LOTS.LOT_NUMBER |
MTL_LOT_NUMBERS |
CSP_PACKLIST_SERIAL_LOTS stores information on which serial and lot numbers that go into the different boxes of a packlist.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PACKLIST_SERIAL_LOTS_U1 | UNIQUE | APPS_TS_TX_IDX | PACKLIST_SERIAL_LOT_ID |
CSP_PACKLIST_SERIAL_LOTS_N1 | NONUNIQUE | APPS_TS_TX_IDX | PACKLIST_LINE_ID |
CSP_PACKLIST_SERIAL_LOTS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID SERIAL_NUMBER |
CSP_PACKLIST_SERIAL_LOTS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID LOT_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PACKLIST_SERIAL_LOT_ID | NUMBER | (35) | Y | Packlist serial and lot unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
PACKLIST_LINE_ID | NUMBER | (35) | Y | Packlist line identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
QUANTITY | NUMBER | (35) | Y | Quantity |
LOT_NUMBER | VARCHAR2 | (240) | Lot number | |
SERIAL_NUMBER | VARCHAR2 | (240) | Serial number | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_PACKLIST_SERIAL_LOTS does not reference any database object
CSP.CSP_PACKLIST_SERIAL_LOTS is referenced by following:
Description: | Parts Loop definition |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PARTS_LOOPS_B.FORECAST_RULE_ID | CSP_FORECAST_RULES_B |
CSP_PARTS_LOOPS_B.CALCULATION_RULE_ID | CSP_LOOP_CALC_RULES_B |
CSP_PARTS_LOOPS_B.PLANNER_CODE
CSP_PARTS_LOOPS_B.ORGANIZATION_ID |
MTL_PLANNERS |
Foreign Key Column | Foreign Table |
---|---|
CSP_CURR_SUP_DEM_SUMS.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
CSP_MSTRSTCK_LISTS_ITMS.PARTS_LOOPS_ID | CSP_PARTS_LOOPS_B |
CSP_NOTIFICATIONS.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
CSP_PARTS_LOOPS_TL.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
CSP_SEC_INVENTORIES.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
CSP_USAGE_HISTORIES.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PARTS_LOOPS_B_U1 | UNIQUE | APPS_TS_TX_IDX | PARTS_LOOP_ID |
CSP_PARTS_LOOPS_B_U2 | UNIQUE | APPS_TS_TX_IDX | PARTS_LOOP_NAME |
CSP_PARTS_LOOPS_B_N1 | NONUNIQUE | APPS_TS_TX_IDX | FORECAST_RULE_ID |
CSP_PARTS_LOOPS_B_N2 | NONUNIQUE | APPS_TS_TX_IDX | CALCULATION_RULE_ID |
CSP_PARTS_LOOPS_B_N3 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
PLANNER_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTS_LOOP_ID | NUMBER | (35) | Y | Parts loop unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
PLANNER_CODE | VARCHAR2 | (10) | Y | Planner identifier |
CALCULATION_RULE_ID | NUMBER | (35) | Y | Calculation rule identifier |
FORECAST_RULE_ID | NUMBER | (35) | Y | Forecast rule identifier |
PARTS_LOOP_NAME | VARCHAR2 | (30) | Y | Parts loop name |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_PARTS_LOOPS_B does not reference any database object
CSP.CSP_PARTS_LOOPS_B is referenced by following:
Description: | Translated Parts Loop definition |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PARTS_LOOPS_TL.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
Translated Parts Loop definition
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PARTS_LOOPS_TL_U1 | NONUNIQUE | APPS_TS_TX_IDX |
PARTS_LOOP_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTS_LOOP_ID | NUMBER | (35) | Y | Parts loop unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
LANGUAGE | VARCHAR2 | (4) | Y | Language of Text. The language to which things are translateed. |
SOURCE_LANG | VARCHAR2 | (4) | Y | Language from which things are translated. |
DESCRIPTION | VARCHAR2 | (240) | Description of parts loop | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_PARTS_LOOPS_TL does not reference any database object
CSP.CSP_PARTS_LOOPS_TL is referenced by following:
Description: | Picklist headers |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PICKLIST_LINES.PICKLIST_HEADER_ID | CSP_PICKLIST_HEADERS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PICKLIST_HEADERS_U1 | UNIQUE | APPS_TS_TX_IDX | PICKLIST_HEADER_ID |
CSP_PICKLIST_HEADERS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
PICKLIST_STATUS
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PICKLIST_HEADER_ID | NUMBER | Y | Picklist unique identifier | |
CREATED_BY | NUMBER | (15) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
PICKLIST_NUMBER | VARCHAR2 | (30) | Y | Picklist number |
PICKLIST_STATUS | VARCHAR2 | (30) | Y | Picklist status. 1=Open 2=Printed 3=Confirmed |
DATE_CREATED | DATE | Date when picklist was created | ||
DATE_CONFIRMED | DATE | Date when picklist was confirmed | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_PICKLIST_HEADERS does not reference any database object
CSP.CSP_PICKLIST_HEADERS is referenced by following:
Description: | Picklist lines |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PICKLIST_LINES.PICKLIST_HEADER_ID | CSP_PICKLIST_HEADERS |
CSP_PICKLIST_LINES.LINE_ID | MTL_TXN_REQUEST_LINES |
CSP_PICKLIST_LINES.LINE_ID | CSP_MOVEORDER_LINES |
Foreign Key Column | Foreign Table |
---|---|
CSP_PACKLIST_LINES.PICKLIST_LINE_ID | CSP_PICKLIST_LINES |
CSP_PICKLIST_SERIAL_LOTS.PICKLIST_LINE_ID | CSP_PICKLIST_LINES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PICKLIST_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | PICKLIST_LINE_ID |
CSP_PICKLIST_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX | PICKLIST_HEADER_ID |
CSP_PICKLIST_LINES_N2 | NONUNIQUE | APPS_TS_TX_IDX | LINE_ID |
CSP_PICKLIST_LINES_N3 | NONUNIQUE | APPS_TS_TX_IDX | TRANSACTION_TEMP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PICKLIST_LINE_ID | NUMBER | (35) | Y | Picklist line unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
PICKLIST_LINE_NUMBER | NUMBER | (35) | Y | Picklist line number |
PICKLIST_HEADER_ID | NUMBER | (35) | Y | Picklist unique identifier |
LINE_ID | NUMBER | (35) | Y | Moveorder line identifier |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
UOM_CODE | VARCHAR2 | (3) | Y | Unit of measure |
REVISION | VARCHAR2 | (3) | Item revision | |
QUANTITY_PICKED | NUMBER | (35) | Y | Quantity picked |
TRANSACTION_TEMP_ID | NUMBER | (35) | Y | Temporary transaction identifier |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_PICKLIST_LINES does not reference any database object
CSP.CSP_PICKLIST_LINES is referenced by following:
Description: | Picklist serial and lotnumbers |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PICKLIST_SERIAL_LOTS.PICKLIST_LINE_ID | CSP_PICKLIST_LINES |
CSP_PICKLIST_SERIAL_LOTS.SERIAL_NUMBER
CSP_PICKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID CSP_PICKLIST_SERIAL_LOTS.ORGANIZATION_ID |
MTL_SERIAL_NUMBERS |
CSP_PICKLIST_SERIAL_LOTS.INVENTORY_ITEM_ID
CSP_PICKLIST_SERIAL_LOTS.ORGANIZATION_ID CSP_PICKLIST_SERIAL_LOTS.LOT_NUMBER |
MTL_LOT_NUMBERS |
CSP_PICKLIST_SERIAL_LOTS stores information on which serial and lot numbers that was picked.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PICKLIST_SERIAL_LOTS_U1 | UNIQUE | APPS_TS_TX_IDX | PICKLIST_SERIAL_LOT_ID |
CSP_PICKLIST_SERIAL_LOTS_N1 | NONUNIQUE | APPS_TS_TX_IDX | PICKLIST_LINE_ID |
CSP_PICKLIST_SERIAL_LOTS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID SERIAL_NUMBER |
CSP_PICKLIST_SERIAL_LOTS_N3 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID LOT_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PICKLIST_SERIAL_LOT_ID | NUMBER | (35) | Y | Picklist serial and lot unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
PICKLIST_LINE_ID | NUMBER | (35) | Y | Picklist line identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
QUANTITY | NUMBER | (35) | Y | Quantity |
LOT_NUMBER | VARCHAR2 | (240) | Lot number | |
SERIAL_NUMBER | VARCHAR2 | (30) | Serial number | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_PICKLIST_SERIAL_LOTS does not reference any database object
CSP.CSP_PICKLIST_SERIAL_LOTS is referenced by following:
Description: | Planning Parameters Definition |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PLANNING_PARAMETERS.FORECAST_RULE_ID | CSP_FORECAST_RULES_B |
CSP_PLANNING_PARAMETERS.EXCESS_RULE_ID | CSP_EXCESS_RULES_B |
CSP_PLANNING_PARAMETERS.SECONDARY_INVENTORY
CSP_PLANNING_PARAMETERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_PLANNING_PARAMETERS.CALCULATION_RULE_ID | CSP_LOOP_CALC_RULES_B |
CSP_PLANNING_PARAMETERS.CATEGORY_ID | MTL_CATEGORIES_B |
CSP_PLANNING_PARAMETERS.CATEGORY_SET_ID | MTL_CATEGORY_SETS_B |
Foreign Key Column | Foreign Table |
---|---|
CSP_PRODUCT_POPULATIONS.PLANNING_PARAMETERS_ID | CSP_PLANNING_PARAMETERS |
CSP_USAGE_HEADERS.PLANNING_PARAMETERS_ID | CSP_PLANNING_PARAMETERS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PLANNING_PARAMETERS_U1 | UNIQUE | APPS_TS_TX_IDX |
PLANNING_PARAMETERS_ID
ZD_EDITION_NAME |
CSP_PLANNING_PARAMETERS_U2 | UNIQUE | APPS_TS_TX_IDX |
LEVEL_ID
ZD_EDITION_NAME |
CSP_PLANNING_PARAMETERS_N1 | NONUNIQUE | APPS_TS_TX_IDX | FORECAST_RULE_ID |
CSP_PLANNING_PARAMETERS_N2 | NONUNIQUE | APPS_TS_TX_IDX | EXCESS_RULE_ID |
CSP_PLANNING_PARAMETERS_N3 | NONUNIQUE | APPS_TS_TX_IDX | CALCULATION_RULE_ID |
CSP_PLANNING_PARAMETERS_N4 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SECONDARY_INVENTORY |
CSP_PLANNING_PARAMETERS_N5 | NONUNIQUE | APPS_TS_TX_IDX | NODE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLANNING_PARAMETERS_ID | NUMBER | (35) | Y | Planning Parameter unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
FORECAST_RULE_ID | NUMBER | (35) | Forecast Rule identifier | |
CALCULATION_RULE_ID | NUMBER | (35) | ||
ORGANIZATION_TYPE | VARCHAR2 | (30) | Organization Type | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
SECONDARY_INVENTORY | VARCHAR2 | (10) | Subinventory | |
SERVICE_LEVEL | NUMBER | Service Level | ||
EDQ_FACTOR | NUMBER | Economic Delivery Quantity Factor | ||
PLANNER_CODE | VARCHAR2 | (10) | Planner identifier | |
CONDITION_TYPE | VARCHAR2 | (30) | Subinventory Condition Type | |
ASL_FLAG | VARCHAR2 | (1) | Authorised Stock List Flag | |
SAFETY_STOCK_FLAG | VARCHAR2 | (1) | Safety Stock Flag | |
EXCESS_RULE_ID | NUMBER | (35) | Excess Rule identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments | |
CATEGORY_SET_ID | NUMBER | (35) | Category set identifier | |
CATEGORY_ID | NUMBER | (35) | Category identifier | |
RECOMMEND_METHOD | VARCHAR2 | (80) | Stocklist recommendation method | |
EDQ_MULTIPLE | NUMBER | (35) | EDQ multiple | |
MINIMUM_VALUE | NUMBER | (35) | Minimum value | |
USABLE_ASSIGNMENT_SET_ID | NUMBER | Assignment set identifier for usable parts | ||
DEFECTIVE_ASSIGNMENT_SET_ID | NUMBER | Assignment set identifier for defective parts | ||
PRODUCT_NORM | VARCHAR2 | (150) | Product norm | |
DEFAULT_FORECAST_RULE_ID | VARCHAR2 | (200) | Forecast rule identifier is defaulted from this node | |
DEFAULT_SERVICE_LEVEL | VARCHAR2 | (200) | Service level is defaulted from this node | |
DEFAULT_EDQ_FACTOR | VARCHAR2 | (200) | EDQ factor is defaulted from this node | |
DEFAULT_PLANNER_CODE | VARCHAR2 | (200) | Planner is defaulted from this node | |
DEFAULT_CONDITION_TYPE | VARCHAR2 | (200) | Condition type is defaulted from this node | |
DEFAULT_ASL_FLAG | VARCHAR2 | (200) | Authorized for stocklist is defaulted from this node | |
DEFAULT_SAFETY_STOCK_FLAG | VARCHAR2 | (200) | Safety stock is defaulted from this node | |
DEFAULT_EXCESS_RULE_ID | VARCHAR2 | (200) | Excess rule identifier is defaulted from this node | |
DEFAULT_CATEGORY_SET_ID | VARCHAR2 | (200) | Category set identifier is defaulted from this node | |
DEFAULT_CATEGORY_ID | VARCHAR2 | (200) | Category identifier is defaulted from this node | |
DEFAULT_RECOMMEND_METHOD | VARCHAR2 | (200) | Recommendation methode is defaulted from this node | |
OVERRIDE_FORECAST_RULE_ID | VARCHAR2 | (5) | Flag identifies if forecast rule identifier can be modified | |
OVERRIDE_SERVICE_LEVEL | VARCHAR2 | (5) | Flag identifies if service level can be modified | |
OVERRIDE_EDQ_FACTOR | VARCHAR2 | (5) | Flag indicates if EDQ factor can be modified | |
OVERRIDE_PLANNER_CODE | VARCHAR2 | (5) | Flag indicates if planner can be modified | |
OVERRIDE_CONDITION_TYPE | VARCHAR2 | (5) | Flag indicates if condition type can be modified | |
OVERRIDE_ASL_FLAG | VARCHAR2 | (5) | Flag indicates if ASL flag can be modified | |
OVERRIDE_SAFETY_STOCK_FLAG | VARCHAR2 | (5) | Flag indicates if safety stock flag can be modified | |
OVERRIDE_EXCESS_RULE_ID | VARCHAR2 | (5) | Flag indicates if excess rule identifier can be modified | |
OVERRIDE_CATEGORY_SET_ID | VARCHAR2 | (5) | Flag indicates if category set identifier can be modified | |
OVERRIDE_CATEGORY_ID | VARCHAR2 | (5) | Flag indicates if category identifier can be modified | |
OVERRIDE_RECOMMEND_METHOD | VARCHAR2 | (5) | Flag indicates if recommendation method can be modified | |
NODE_TYPE | VARCHAR2 | (30) | Node type | |
NODE_NAME | VARCHAR2 | (50) | Node name | |
PARENT_NODE_ID | NUMBER | (35) | Parent node identifier | |
LEVEL_ID | VARCHAR2 | (200) | Y | Level identifier |
PRODUCT_NORM_NODE_ID | NUMBER | Product norm node identifier | ||
USAGE_WEIGHT1 | NUMBER | Weight when personal usage > norm | ||
USAGE_WEIGHT2 | NUMBER | Weight when personal usage < Norm | ||
USAGE_WEIGHT3 | NUMBER | Weight when personal usage = 0 | ||
USAGE_WEIGHT4 | NUMBER | Weight when norm = 0 | ||
DEFAULT_USAGE_WEIGHT1 | VARCHAR2 | (200) | Weight is defaulted from this node | |
DEFAULT_USAGE_WEIGHT2 | VARCHAR2 | (200) | Weight is defaulted from this node | |
DEFAULT_USAGE_WEIGHT3 | VARCHAR2 | (200) | Weight is defaulted from this node | |
DEFAULT_USAGE_WEIGHT4 | VARCHAR2 | (200) | Weight is defaulted from this node | |
OVERRIDE_USAGE_WEIGHT1 | VARCHAR2 | (5) | Flag indicates if weight can be modified | |
OVERRIDE_USAGE_WEIGHT2 | VARCHAR2 | (5) | Flag indicates if weight can be modified | |
OVERRIDE_USAGE_WEIGHT3 | VARCHAR2 | (5) | Flag indicates if weight can be modified | |
OVERRIDE_USAGE_WEIGHT4 | VARCHAR2 | (5) | Flag indicates if weight can be modified | |
DEFAULT_PRODUCT_NORM_NODE_ID | VARCHAR2 | (200) | Product norm node identifier is defaulted from this node | |
RECOMMENDATION_RULE_ID | NUMBER | (38) | Recommendation Rule Identifier | |
REPAIR_ASSIGNMENT_SET_ID | NUMBER | Repair supplier assigned for the Warehouse | ||
DEFAULT_REC_RULE_ID | VARCHAR2 | (240) | Default Recommendation Rule Identifier | |
OVERRIDE_REC_RULE_ID | VARCHAR2 | (10) | Flag indicates if recommendation rule can be modified. | |
NOTIFICATION_RULE_ID | NUMBER | (38) | Notification business rule identifier | |
EXCESS_EDQ_FACTOR | VARCHAR2 | (240) | Excess EDQ factor | |
REPAIR_EDQ_FACTOR | VARCHAR2 | (240) | Repair EDQ factor | |
NEWBUY_EDQ_FACTOR | VARCHAR2 | (240) | Newbuy EDQ factor | |
EXCESS_SERVICE_LEVEL | VARCHAR2 | (240) | Excess service level | |
REPAIR_SERVICE_LEVEL | VARCHAR2 | (240) | Repair service level | |
NEWBUY_SERVICE_LEVEL | VARCHAR2 | (240) | Newbuy service level | |
RESCHEDULE_RULE_ID | NUMBER | Reschedule Rule identifier | ||
WRP_RULE_ID | NUMBER | (38) | Order Automation Rule Identifier | |
STOCKING_SITE_TYPE | VARCHAR2 | (30) | Stocking Site Type | |
CALENDAR_ID | NUMBER | (38) | Calendar Identifier | |
TIMEZONE_ID | NUMBER | (38) | Timezone identifier | |
CONTACT_NAME | VARCHAR2 | (150) | Contact Name | |
CONTACT_PHONE | VARCHAR2 | (30) | Contact Phone Number | |
AH_CONTACT_NAME | VARCHAR2 | (150) | After Hours Contact Name | |
AH_CONTACT_PHONE | VARCHAR2 | (30) | After Hours Contact Phone Number | |
STOCKING_SITE_EXCL | VARCHAR2 | (3) | Stocking Site Excluded from Technician Part Search | |
SPECIAL_INSTRUCTIONS | VARCHAR2 | (1996) | Special Instructions | |
MANAGED_BY | VARCHAR2 | (30) | Warehouse Managed By | |
HZ_LOCATION_ID | NUMBER | (38) | Geocoded Address Identifier | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
CSP.CSP_PLANNING_PARAMETERS does not reference any database object
CSP.CSP_PLANNING_PARAMETERS is referenced by following:
Description: | Stores the population of a product. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PRODUCT_POPULATIONS.PLANNING_PARAMETERS_ID | CSP_PLANNING_PARAMETERS |
This table stores the population of a product in a region. It also stores population changes used in the Product Norm planning.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PRODUCT_POPULATIONS_U1 | UNIQUE | APPS_TS_TX_IDX | PRODUCT_POPULATION_ID |
CSP_PRODUCT_POPULATIONS_U2 | UNIQUE | APPS_TS_TX_IDX |
PRODUCT_ID
PLANNING_PARAMETERS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_POPULATION_ID | NUMBER | (38) | Y | Unique identifier for product population |
CREATED_BY | NUMBER | (38) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (38) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who column | |
PLANNING_PARAMETERS_ID | NUMBER | (38) | Y | planning parameter id |
PRODUCT_ID | NUMBER | (38) | Y | Product id |
CURRENT_POPULATION | NUMBER | (38) | Current population | |
POPULATION_CHANGE | NUMBER | (38) | Population Change | |
SECURITY_GROUP_ID | NUMBER | (38) | Used in hosted environments |
CSP.CSP_PRODUCT_POPULATIONS does not reference any database object
CSP.CSP_PRODUCT_POPULATIONS is referenced by following:
Description: | Product Tasks |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_PRODUCT_TASKS.TASK_TEMPLATE_ID | JTF_TASK_TEMPLATES_B |
Foreign Key Column | Foreign Table |
---|---|
CSP_TASK_PARTS.PRODUCT_TASK_ID | CSP_PRODUCT_TASKS |
CSP_PRODUCT_TASKS stores the information about Product and Task template used
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_PRODUCT_TASKS_U1 | UNIQUE | APPS_TS_TX_IDX | PRODUCT_TASK_ID |
CSP_PRODUCT_TASKS_U2 | UNIQUE | APPS_TS_TX_IDX |
PRODUCT_ID
TASK_TEMPLATE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRODUCT_TASK_ID | NUMBER | (35) | Y | Product task unique identifier |
PRODUCT_ID | NUMBER | (35) | Y | Product identifier |
TASK_TEMPLATE_ID | NUMBER | (35) | Y | Task Template Identifier |
AUTO_MANUAL | VARCHAR2 | (30) | Y | Manual or Generated |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ACTUAL_TIMES_USED | NUMBER | (35) | Actual number of times the task is used for the product | |
TASK_PERCENTAGE | NUMBER | (35) | Task percentage for the product | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments |
CSP.CSP_PRODUCT_TASKS does not reference any database object
CSP.CSP_PRODUCT_TASKS is referenced by following:
Description: | Reporting hierarchies |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_REP_HIERARCHIES.TOP_NODE_ID | CSP_REP_HIERARCHIES |
CSP_REP_HIERARCHIES.PARENT_NODE_ID | CSP_REP_HIERARCHIES |
Foreign Key Column | Foreign Table |
---|---|
CSP_CURR_SUP_DEM_SUMS.HIERARCHY_NODE_ID | CSP_REP_HIERARCHIES |
CSP_REP_HIERARCHIES.TOP_NODE_ID | CSP_REP_HIERARCHIES |
CSP_REP_HIERARCHIES.PARENT_NODE_ID | CSP_REP_HIERARCHIES |
CSP_SEC_INVENTORIES.HIERARCHY_NODE_ID | CSP_REP_HIERARCHIES |
CSP_USAGE_HISTORIES.HIERARCHY_NODE_ID | CSP_REP_HIERARCHIES |
Table CSP_REP_HIERARCHIES stores information about the hierarchies that can be used to search for items in specific geographical areas. PARENT_NODE_ID identifies the parent of a node in the hierarchy. TOP_NODE_ID identifies the top node in the hierarchy. There is no restriction to how many hierarchies that can be defined.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_REP_HIERARCHIES_U1 | UNIQUE | APPS_TS_TX_IDX | HIERARCHY_NODE_ID |
CSP_REP_HIERARCHIES_U2 | UNIQUE | APPS_TS_TX_IDX | NODE_NAME |
CSP_REP_HIERARCHIES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
NODE_NAME |
CSP_REP_HIERARCHIES_N2 | NONUNIQUE | APPS_TS_TX_IDX | PARENT_NODE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HIERARCHY_NODE_ID | NUMBER | (35) | Y | Reporting hierarchy node unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
NODE_TYPE | VARCHAR2 | (30) | Y | Node type. "RH" is only value used. |
NODE_NAME | VARCHAR2 | (30) | Y | Name of reporting hierarchy node |
TOP_NODE_ID | NUMBER | (35) | Y | Top node identifier |
PARENT_NODE_ID | NUMBER | (35) | Parent node identifier | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
CSP.CSP_REP_HIERARCHIES does not reference any database object
CSP.CSP_REP_HIERARCHIES is referenced by following:
Description: |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | |||
REVISION | VARCHAR2 | (3) | ||
ALTERNATE_ITEM_ID | NUMBER | |||
QUANTITY | NUMBER | |||
ITEM_TYPE | VARCHAR2 | (30) |
CSP.CSP_REQUIRED_PARTS_TEMP does not reference any database object
CSP.CSP_REQUIRED_PARTS_TEMP is referenced by following:
Description: | Stores information regarding parts requirements. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_REQUIREMENT_HEADERS.TASK_ASSIGNMENT_ID | JTF_TASK_ASSIGNMENTS |
CSP_REQUIREMENT_HEADERS.TASK_ID | JTF_TASKS_B |
CSP_REQUIREMENT_HEADERS.DESTINATION_ORGANIZATION_ID | MTL_PARAMETERS |
Foreign Key Column | Foreign Table |
---|---|
CSP_REQUIREMENT_LINES.REQUIREMENT_HEADER_ID | CSP_REQUIREMENT_HEADERS |
Stores information regarding parts requirements.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_REQUIREMENT_HEADERS_U1 | UNIQUE | APPS_TS_TX_IDX | REQUIREMENT_HEADER_ID |
CSP_REQUIREMENT_HEADERS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SHIP_TO_LOCATION_ID |
CSP_REQUIREMENT_HEADERS_N2 | NONUNIQUE | APPS_TS_TX_IDX | TIMEZONE_ID |
CSP_REQUIREMENT_HEADERS_N3 | NONUNIQUE | APPS_TS_TX_IDX | TASK_ASSIGNMENT_ID |
CSP_REQUIREMENT_HEADERS_N4 | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_TYPE
RESOURCE_ID |
CSP_REQUIREMENT_HEADERS_N5 | NONUNIQUE | APPS_TS_TX_IDX | SHIPPING_METHOD_CODE |
CSP_REQUIREMENT_HEADERS_N6 | NONUNIQUE | APPS_TS_TX_IDX | DESTINATION_ORGANIZATION_ID |
CSP_REQUIREMENT_HEADERS_N7 | NONUNIQUE | APPS_TS_TX_IDX | ORDER_TYPE_ID |
CSP_REQUIREMENT_HEADERS_N8 | NONUNIQUE | APPS_TS_TX_IDX | TASK_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUIREMENT_HEADER_ID | NUMBER | (35) | Y | Parts order header identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
OPEN_REQUIREMENT | VARCHAR2 | (240) | Flag indicating if requirement is open or closed | |
ADDRESS_TYPE | VARCHAR2 | (30) | Address Type. Values are R - Resource Address, C - Customer Address, S - Special Address | |
SHIP_TO_LOCATION_ID | NUMBER | (35) | Ship to Location Identifier | |
TIMEZONE_ID | NUMBER | (35) | Timezone Identifier | |
TASK_ID | NUMBER | (35) | Task identifier | |
TASK_ASSIGNMENT_ID | NUMBER | (35) | Task Assignment Identifier | |
RESOURCE_TYPE | VARCHAR2 | (240) | Resource Type | |
RESOURCE_ID | NUMBER | (35) | Resource Identifier | |
SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Shipping Method for the order | |
NEED_BY_DATE | DATE | Need by date for the parts | ||
DESTINATION_ORGANIZATION_ID | NUMBER | (35) | Destination organization Identifier | |
DESTINATION_SUBINVENTORY | VARCHAR2 | (30) | Destination subinventory | |
ORDER_TYPE_ID | NUMBER | (35) | Order Type Identifier | |
PARTS_DEFINED | VARCHAR2 | (30) | Flag to specify if required parts are already defined for this requirement or not | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Security group Identifier | ||
SHIP_TO_CONTACT_ID | NUMBER |
CSP.CSP_REQUIREMENT_HEADERS does not reference any database object
CSP.CSP_REQUIREMENT_HEADERS is referenced by following:
Description: | Parts requirement details. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_REQUIREMENT_LINES.REQUIREMENT_HEADER_ID | CSP_REQUIREMENT_HEADERS |
CSP_REQUIREMENT_LINES.RESERVATION_ID | MTL_RESERVATIONS |
CSP_REQUIREMENT_LINES.LOCAL_RESERVATION_ID | MTL_RESERVATIONS |
CSP_REQUIREMENT_LINES.ORDER_LINE_ID | OE_ORDER_LINES_ALL |
CSP_REQUIREMENT_LINES.SOURCE_ORGANIZATION_ID | MTL_PARAMETERS |
CSP_REQUIREMENT_LINES.SOURCE_SUBINVENTORY
CSP_REQUIREMENT_LINES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
Parts requirement details.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_REQUIREMENT_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | REQUIREMENT_LINE_ID |
CSP_REQUIREMENT_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX | REQUIREMENT_HEADER_ID |
CSP_REQUIREMENT_LINES_N2 | NONUNIQUE | APPS_TS_TX_IDX | INVENTORY_ITEM_ID |
CSP_REQUIREMENT_LINES_N3 | NONUNIQUE | APPS_TS_TX_IDX |
SOURCE_ORGANIZATION_ID
SOURCE_SUBINVENTORY |
CSP_REQUIREMENT_LINES_N4 | NONUNIQUE | APPS_TS_TX_IDX | ORDER_LINE_ID |
CSP_REQUIREMENT_LINES_N5 | NONUNIQUE | APPS_TS_TX_IDX | RESERVATION_ID |
CSP_REQUIREMENT_LINES_N6 | NONUNIQUE | APPS_TS_TX_IDX | LOCAL_RESERVATION_ID |
CSP_REQUIREMENT_LINES_N7 | NONUNIQUE | APPS_TS_TX_IDX | SHIPPING_METHOD_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUIREMENT_LINE_ID | NUMBER | (35) | Y | Unique Requirement Line Identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
REQUIREMENT_HEADER_ID | NUMBER | (35) | Y | Requirement header Identifier |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Item identifier |
UOM_CODE | VARCHAR2 | (3) | Y | Unit of measure code for the item |
REQUIRED_QUANTITY | NUMBER | Y | Quantity required | |
SHIP_COMPLETE_FLAG | VARCHAR2 | (3) | Flag to specify if two or more lines should be shipped together. All lines with the same shipset will be shipped together. | |
LIKELIHOOD | NUMBER | (35) | Likelihood in percent of the part being used for the task | |
REVISION | VARCHAR2 | (3) | Revision of the item if item is revision controlled | |
SOURCE_ORGANIZATION_ID | NUMBER | (35) | Source Organization Identifier | |
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Source Subinventory | |
ORDERED_QUANTITY | NUMBER | (35) | Quantity ordered | |
ORDER_LINE_ID | NUMBER | (35) | Not used. Order line identifier is stored in csp_req_line_details.source_id column where source_code = 'IO' | |
RESERVATION_ID | NUMBER | (35) | Not used. Reservation identifier is stored in csp_req_line_details.source_id column where source_code = 'RES' | |
LOCAL_RESERVATION_ID | VARCHAR2 | (240) | Not used. | |
ORDER_BY_DATE | DATE | Order by date | ||
ARRIVAL_DATE | DATE | Arrival date of the parts | ||
ITEM_SCRATCHPAD | VARCHAR2 | (1996) | Item scratchpad for unknown item numbers | |
SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Shipping method used for the order | |
SOURCED_FROM | VARCHAR2 | (30) | From where the requirement is sourced | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Security group Identifier |
CSP.CSP_REQUIREMENT_LINES does not reference any database object
CSP.CSP_REQUIREMENT_LINES is referenced by following:
Description: |
---|
This table stores the detailed sourcing information for a parts requirement.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_REQ_LINE_DETAILS_N1 | NONUNIQUE | APPS_TS_TX_IDX | REQUIREMENT_LINE_ID |
CSP_REQ_LINE_DETAILS_U1 | NONUNIQUE | APPS_TS_TX_IDX | REQ_LINE_DETAIL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQ_LINE_DETAIL_ID | NUMBER | (38) | Y | Requirement line detail identifier |
REQUIREMENT_LINE_ID | NUMBER | (38) | Requirement line identifier | |
SOURCE_TYPE | VARCHAR2 | (30) | Source type | |
SOURCE_ID | NUMBER | (38) | Source identifier | |
CREATED_BY | NUMBER | (38) | Standard Who column - with the user id from FND_USER | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (38) | Standard Who column - with the user id from FND_USER | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who column |
CSP.CSP_REQ_LINE_DETAILS does not reference any database object
CSP.CSP_REQ_LINE_DETAILS is referenced by following:
Description: | Resource with ship to address and subinventory assigned |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_RS_CUST_RELATIONS.CUSTOMER_ID | HZ_CUST_ACCOUNTS |
Resource with ship to address and subinventory assigned
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_RS_CUST_RELATIONS_U1 | UNIQUE | APPS_TS_TX_IDX | RS_CUST_RELATION_ID |
CSP_RS_CUST_RELATIONS_U2 | UNIQUE | APPS_TS_TX_IDX |
RESOURCE_TYPE
RESOURCE_ID |
CSP_RS_CUST_RELATIONS_N1 | NONUNIQUE | APPS_TS_TX_IDX | CUSTOMER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RS_CUST_RELATION_ID | NUMBER | (35) | Y | Resource customer relation unique identifier |
RESOURCE_TYPE | VARCHAR2 | (30) | Y | Resource type |
RESOURCE_ID | NUMBER | (35) | Y | Resource identifier |
CUSTOMER_ID | NUMBER | (35) | Customer identifier | |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments | |
REQUEST_ID | NUMBER | Standard Who Column | ||
PROGRAM_ID | NUMBER | Standard Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
DEFAULT_TRIP_START | NUMBER | (38) | Start address for the trip. |
CSP.CSP_RS_CUST_RELATIONS does not reference any database object
CSP.CSP_RS_CUST_RELATIONS is referenced by following:
Description: | Safety Factors Lookup |
---|
CSP_SAFETY_FACTORS stores information about the Safety factor lookup values based on Service Level and exposures. SERVICE_LEVEL identifies the Service Level value. EXPOSURES identify the exposures value calculated from Economic Delivery Quantity (EDQ). SAFETY_FACTOR identifies the Safety factor value based on Service Level and Exposures.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_SAFETY_FACTORS_U1 | UNIQUE | APPS_TS_SEED |
SAFETY_FACTOR_ID
ZD_EDITION_NAME |
CSP_SAFETY_FACTORS_N1 | NONUNIQUE | APPS_TS_SEED |
SERVICE_LEVEL
EXPOSURES |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SAFETY_FACTOR_ID | NUMBER | (35) | Y | Safety Factor unique identifier |
SERVICE_LEVEL | NUMBER | Y | Service Level value | |
EXPOSURES | NUMBER | Y | Exposures calculated from Economic Delivery Quantity (EDQ) | |
SAFETY_FACTOR | NUMBER | Y | Safety Factor Value | |
CREATION_DATE | DATE | Y | Standard WHO column | |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard WHO column | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Y |
CSP.CSP_SAFETY_FACTORS does not reference any database object
CSP.CSP_SAFETY_FACTORS is referenced by following:
Description: | Holds extra subinventory information |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_SEC_INVENTORIES.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
CSP_SEC_INVENTORIES.HIERARCHY_NODE_ID | CSP_REP_HIERARCHIES |
CSP_SEC_INVENTORIES.SECONDARY_INVENTORY_NAME
CSP_SEC_INVENTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_SEC_INVENTORIES identifies the subinventories that are related to parts loops and reporting hierarhies. LOCATION_ID identifies the address for this subinventory. CONDITION_TYPE identifies the condition of parts being stored in this subinventory. AUTORECEIPT_FLAG shows if this subinventory will allow ordered parts to be received automatically or not. SPARES_LOCATION_FLAG shows if this subinventory stores spares parts or not.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_SEC_INVENTORIES_U1 | UNIQUE | APPS_TS_TX_IDX | SECONDARY_INVENTORY_ID |
CSP_SEC_INVENTORIES_N1 | NONUNIQUE | APPS_TS_TX_IDX | SECONDARY_INVENTORY_NAME |
CSP_SEC_INVENTORIES_N2 | NONUNIQUE | APPS_TS_TX_IDX | PARTS_LOOP_ID |
CSP_SEC_INVENTORIES_N3 | NONUNIQUE | APPS_TS_TX_IDX | HIERARCHY_NODE_ID |
CSP_SEC_INVENTORIES_N4 | NONUNIQUE | APPS_TS_TX_IDX | LOCATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SECONDARY_INVENTORY_ID | NUMBER | (35) | Y | Secondary inventory unique identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
HIERARCHY_NODE_ID | NUMBER | (35) | Rerpoting hierarchy node identifier | |
SECONDARY_INVENTORY_NAME | VARCHAR2 | (10) | Y | Subinventory identifier |
LOCATION_ID | NUMBER | (35) | Location identifier | |
CONDITION_TYPE | VARCHAR2 | (30) | Y | Condition type. G=Good parts B=Bad parts |
AUTORECEIPT_FLAG | VARCHAR2 | (30) | Y | Autoreceipt. Y=Autoreceipt N=Manual receipt |
SPARES_LOCATION_FLAG | VARCHAR2 | (30) | Y | Subinventory carries spare parts Y/N |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OWNER_RESOURCE_TYPE | VARCHAR2 | (30) | Subinventory owner resource type | |
OWNER_RESOURCE_ID | NUMBER | (35) | Subinventory owner resource identifier | |
RETURN_ORGANIZATION_ID | NUMBER | (35) | Organization identifier for spare parts return | |
RETURN_SUBINVENTORY_NAME | VARCHAR2 | (10) | Subinventory name for spares parts return | |
GROUP_ID | NUMBER | (35) | Group Id to identify the district | |
LAST_EXCESS_RUN_DATE | DATE | Last Excess Run Date |
CSP.CSP_SEC_INVENTORIES does not reference any database object
CSP.CSP_SEC_INVENTORIES is referenced by following:
Description: | Stores information about how the stock list item was created. |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_STOCK_LISTS.INVENTORY_ITEM_ID
CSP_STOCK_LISTS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
This table stores additional information for a stocklist item defining how the item was put on the stocklist and why.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_STOCK_LISTS_U1 | UNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
SUBINVENTORY_CODE ORGANIZATION_ID |
CSP_STOCK_LISTS_U2 | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SUBINVENTORY_CODE INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | (38) | Y | Organization identifier |
CREATED_BY | NUMBER | (38) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (38) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who column | |
INVENTORY_ITEM_ID | NUMBER | (38) | Y | Inventory item identifier |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Subinventory code | |
MANUAL_AUTO | VARCHAR2 | (30) | Manually entered or not | |
REASON_CODE | VARCHAR2 | (30) | Reason for entering a manual stocklist item | |
SECURITY_GROUP_ID | NUMBER | (38) | Used in hosted environments |
CSP.CSP_STOCK_LISTS does not reference any database object
CSP.CSP_STOCK_LISTS is referenced by following:
Description: | This table stores Item planned for warehouses and item supplied for subinventories |
---|
This table stores Item planned for supersede items
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_SUPERSEDE_ITEMS_U1 | UNIQUE | APPS_TS_TX_IDX | SUPERSEDE_ID |
CSP_SUPERSEDE_ITEMS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPERSEDE_ID | NUMBER | (38) | Y | Unique id for super session |
CREATED_BY | NUMBER | (38) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (38) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who column | |
INVENTORY_ITEM_ID | NUMBER | (38) | Y | Inventory item identifier |
ORGANIZATION_ID | NUMBER | (38) | Organization identifier | |
SUB_INVENTORY_CODE | VARCHAR2 | (30) | Subinventory code | |
ITEM_SUPPLIED | NUMBER | (38) | Supplied item identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
CSP.CSP_SUPERSEDE_ITEMS does not reference any database object
CSP.CSP_SUPERSEDE_ITEMS is referenced by following:
Description: | Supply Chain details |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_SUPPLY_CHAIN.INVENTORY_ITEM_ID
CSP_SUPPLY_CHAIN.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_SUPPLY_CHAIN.PARENT_SUPPLY_CHAIN_ID | CSP_SUPPLY_CHAIN |
CSP_SUPPLY_CHAIN.SECONDARY_INVENTORY
CSP_SUPPLY_CHAIN.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
Foreign Key Column | Foreign Table |
---|---|
CSP_SUPPLY_CHAIN.PARENT_SUPPLY_CHAIN_ID | CSP_SUPPLY_CHAIN |
CSP_SUPPLY_CHAIN stores information about the Supply chain generated by "Create ASL Recommendations" concurrent program. Each levl in the Supply Chain has a Parent Supply Chain identifier which identifies the source of Supply for that level. INVENTORY_ITEM_ID identifies the Item. ORGANIZATION_ID identifies the Organization. SECONDARY_INVENTORY identifies the Subinventory. PARENT_SUPPLY_CHAIN_ID identifies the parent in the Supply Chain tree.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_SUPPLY_CHAIN_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SOURCE_TYPE
SOURCE_ORGANIZATION_ID SOURCE_SUBINVENTORY |
CSP_SUPPLY_CHAIN_N2 | NONUNIQUE | APPS_TS_TX_IDX | SUPPLY_LEVEL |
CSP_SUPPLY_CHAIN_N3 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SECONDARY_INVENTORY INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLY_CHAIN_ID | VARCHAR2 | (240) | Supply Chain unique identifier | |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Item identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
SECONDARY_INVENTORY | VARCHAR2 | (10) | Y | Subinventory identifier |
PARENT_SUPPLY_CHAIN_ID | NUMBER | (35) | Parent identifier in the Supply Chain tree. | |
SOURCE_TYPE | NUMBER | (35) | Source type | |
SOURCE_ORGANIZATION_ID | NUMBER | (35) | Source organization identifier | |
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Source subinventory | |
LEAD_TIME | NUMBER | (35) | Lead time | |
SUPPLY_LEVEL | NUMBER | (35) | Supply level | |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard WHO column | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments |
CSP.CSP_SUPPLY_CHAIN does not reference any database object
CSP.CSP_SUPPLY_CHAIN is referenced by following:
Description: | Task Parts |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_TASK_PARTS.PRODUCT_TASK_ID | CSP_PRODUCT_TASKS |
CSP_TASK_PARTS stores the information about items associated with task
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_TASK_PARTS_U1 | UNIQUE | APPS_TS_TX_IDX | TASK_PART_ID |
CSP_TASK_PARTS_U2 | UNIQUE | APPS_TS_TX_IDX |
PRODUCT_TASK_ID
INVENTORY_ITEM_ID REVISION |
CSP_TASK_PARTS_N1 | NONUNIQUE | APPS_TS_TX_IDX | SUBSTITUTE_ITEM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_PART_ID | NUMBER | (35) | Y | Task Part unique Identifier |
PRODUCT_TASK_ID | NUMBER | (35) | Y | Product Task identifier |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory Item Identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
MANUAL_QUANTITY | NUMBER | Manual Quantity | ||
MANUAL_PERCENTAGE | NUMBER | Manaual Percentage | ||
QUANTITY_USED | NUMBER | Quantity Used | ||
ACTUAL_TIMES_USED | NUMBER | Actual Times Used | ||
ROLLUP_QUANTITY_USED | NUMBER | Rollup Quantity Used | ||
ROLLUP_TIMES_USED | NUMBER | Rollup Times Used | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit Of Measurement Code | |
REVISION | VARCHAR2 | (30) | Revision | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
SUBSTITUTE_ITEM | NUMBER | (35) | Substitute Item | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments |
CSP.CSP_TASK_PARTS does not reference any database object
CSP.CSP_TASK_PARTS is referenced by following:
Description: | Planning recommendations summary |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_USAGE_HEADERS.PLANNING_PARAMETERS_ID | CSP_PLANNING_PARAMETERS |
CSP_USAGE_HEADERS.SECONDARY_INVENTORY
CSP_USAGE_HEADERS.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_USAGE_HEADERS.INVENTORY_ITEM_ID
CSP_USAGE_HEADERS.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_USAGE_HEADERS stores information about the summary data generated by "Create ASL Recommendations" concurrent program. INVENTORY_ITEM_ID identifies the Item. PLANNING_PARAMETERS_ID identify the Planning Parameters used. SECONDARY_INVENTORY identifies the recommendations Subinventory. ORGANIZATION_ID identifies the recommendations Organization. HEADER_DATA_TYPE identifies the summary level viz., 1 - Subinventory, 3 -Planning Top Node, 4 - Organization. PROCESS_STATUS identifies the recommedations status like Open, Completed or Rejected. RAW_AWU and AWU identify the Average Weekly Usage calculated. STANDARD_DEVIATION identify the Standard Deviation calculated. RECOMMENDED_MIN and RECOMMENDED_MAX identify the Minimum and Maximum recommeded values respectively. EXTERNAL_DATA Yes/No identify Automatic generation or Manual load of recommendations data. ITEM_COST identify the Standard cost of the item. LEAD_TIME identify the Lead time between Organizations in the Supply Chain.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_USAGE_HEADERS_U1 | UNIQUE | APPS_TS_TX_IDX | USAGE_HEADER_ID |
CSP_USAGE_HEADERS_N1 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID |
CSP_USAGE_HEADERS_N2 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SECONDARY_INVENTORY |
CSP_USAGE_HEADERS_N3 | NONUNIQUE | APPS_TS_TX_IDX | PLANNING_PARAMETERS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USAGE_HEADER_ID | NUMBER | (35) | Usage Header unique identifier | |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory Item identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
SECONDARY_INVENTORY | VARCHAR2 | (10) | Subinventory identifier | |
RAW_AWU | NUMBER | Raw Average Weekly Usage | ||
AWU | NUMBER | Average Weekly Usage | ||
HEADER_DATA_TYPE | VARCHAR2 | (30) | Header Data Type identifier | |
STANDARD_DEVIATION | NUMBER | (35) | Standard Deviation value | |
PLANNING_PARAMETERS_ID | NUMBER | (35) | Planning Parameters identifier | |
ITEM_COST | NUMBER | Standard Cost of the Item | ||
LEAD_TIME | NUMBER | Lead time value | ||
PROCESS_STATUS | VARCHAR2 | (30) | Recoomendations Status Open, Completed or Rejected | |
RECOMMENDED_MIN_QUANTITY | NUMBER | (35) | Recommended Minimum Value | |
RECOMMENDED_MAX_QUANTITY | NUMBER | (35) | Recommended Maximum value | |
EXTERNAL_DATA | VARCHAR2 | (30) | Automatic recommendations generation or Manual Load | |
COMMENTS | VARCHAR2 | (240) | Comments | |
SECURITY_GROUP_ID | NUMBER | (35) | Used in hosted environments | |
TRACKING_SIGNAL | VARCHAR2 | (240) | Tracking signal |
CSP.CSP_USAGE_HEADERS does not reference any database object
CSP.CSP_USAGE_HEADERS is referenced by following:
Description: | Summarized usage history information |
---|
Foreign Key Column | Foreign Table |
---|---|
CSP_USAGE_HISTORIES.PARTS_LOOP_ID | CSP_PARTS_LOOPS_B |
CSP_USAGE_HISTORIES.HIERARCHY_NODE_ID | CSP_REP_HIERARCHIES |
CSP_USAGE_HISTORIES.INVENTORY_ITEM_ID
CSP_USAGE_HISTORIES.ORGANIZATION_ID |
MTL_SYSTEM_ITEMS_B |
CSP_USAGE_HISTORIES.SUBINVENTORY_CODE
CSP_USAGE_HISTORIES.ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES |
CSP_USAGE_HISTORIES.TRANSACTION_TYPE_ID | MTL_TRANSACTION_TYPES |
CSP_USAGE_HISTORIES stores the information generated by the concurrent program "Create Usage History". This is summarized information for usage transactions and sales order transactions. Information for all service parts in all levels of reporting hierarchies and parts loops is stored. The information is also generated for the 2 period types supported. TRANSACTION_TYPE_ID identifies the transaction type.
CSP_USAGE_HISTORIES also stores the Usage History and Forecast generated by "Create ASL recommendations" concurrent program. The Usage Data generated by this concurrent program is identified by unique value for each level in the column HEADER_DATA_TYPE viz., 1 - Subinventory level Usage Data, 2 -Organization and Subinventory level Forecast Data, 3 - Top Node level Usage Data, 4 - Organization Level Usage Data, 5 - Subinventory Level Usage data for the number of History periods specified for the subinventory other than the Actual Usage periods for the Subinventory , 6 - Organization Level Usage data for the number of History periods specified for the Organization other than the Actual Usage periods for the Organization. USAGE_HEADER_ID identifies the recommendations summary for the Usage.
Index | Type | Tablespace | Column |
---|---|---|---|
CSP_USAGE_HISTORIES_U1 | UNIQUE | APPS_TS_TX_IDX | USAGE_ID |
CSP_USAGE_HISTORIES_N1 | NONUNIQUE | APPS_TS_TX_IDX | PARTS_LOOP_ID |
CSP_USAGE_HISTORIES_N2 | NONUNIQUE | APPS_TS_TX_IDX | HIERARCHY_NODE_ID |
CSP_USAGE_HISTORIES_N3 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SUBINVENTORY_CODE INVENTORY_ITEM_ID HISTORY_DATA_TYPE PERIOD_START_DATE HIERARCHY_NODE_ID PARTS_LOOP_ID PERIOD_TYPE TRANSACTION_TYPE_ID |
CSP_USAGE_HISTORIES_N4 | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
INVENTORY_ITEM_ID HISTORY_DATA_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USAGE_ID | NUMBER | (35) | Usage history unique identifier | |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
REQUEST_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_ID | NUMBER | (35) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
HIERARCHY_NODE_ID | NUMBER | (35) | Reporting hierarchy node identifier | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Y | Subinventory identifier |
PERIOD_TYPE | VARCHAR2 | (30) | Y | Period type. 1=Weekly 2=Periodic |
PERIOD_START_DATE | DATE | Y | Period start date | |
TRANSACTION_TYPE_ID | NUMBER | (35) | Transaction type identifier | |
QUANTITY | NUMBER | (35) | Y | Quantity |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
USAGE_HEADER_ID | VARCHAR2 | (240) | CSP_USAGE_HEADERS Foreign Key. | |
HISTORY_DATA_TYPE | VARCHAR2 | (240) | Y | Usage History Data Type |
CSP.CSP_USAGE_HISTORIES does not reference any database object
CSP.CSP_USAGE_HISTORIES is referenced by following:
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 |
---|---|---|---|---|
TASK_ID | NUMBER | (35) | Task identifier | |
TASK_ASSIGNMENT_ID | NUMBER | (35) | Task assignment identifier | |
LATEST_ARRIVAL_DATE | DATE | Latest arrival date |
APPS.CSP_ARRIVAL_DATES_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) | ||
INVENTORY_ITEM_ID | NUMBER | Y | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ORGANIZATION_ID | NUMBER | Y | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | Y | ||
LAST_UPDATE_LOGIN | NUMBER | |||
MIN_MINMAX_QUANTITY | NUMBER | |||
MAX_MINMAX_QUANTITY | NUMBER | |||
INVENTORY_PLANNING_CODE | NUMBER | |||
FIXED_LOT_MULTIPLE | NUMBER | |||
MINIMUM_ORDER_QUANTITY | NUMBER | |||
MAXIMUM_ORDER_QUANTITY | NUMBER | |||
SOURCE_TYPE | NUMBER | |||
SOURCE_TYPE_NAME | VARCHAR2 | (12) | ||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
ENCUMBRANCE_ACCOUNT | NUMBER | |||
PREPROCESSING_LEAD_TIME | NUMBER | |||
POSTPROCESSING_LEAD_TIME | NUMBER | |||
MANUAL_AUTO | VARCHAR2 | (30) | ||
REASON_CODE | VARCHAR2 | (30) | ||
REASON_CODE_MEANING | VARCHAR2 | (80) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (240) | ||
ATTRIBUTE2 | VARCHAR2 | (240) | ||
ATTRIBUTE3 | VARCHAR2 | (240) | ||
ATTRIBUTE4 | VARCHAR2 | (240) | ||
ATTRIBUTE5 | VARCHAR2 | (240) | ||
ATRIBUTE6 | VARCHAR2 | (240) | ||
ATTRIBUTE7 | VARCHAR2 | (240) | ||
ATTRIBUTE8 | VARCHAR2 | (240) | ||
ATTRIBUTE9 | VARCHAR2 | (240) | ||
ATTRIBUTE10 | VARCHAR2 | (240) | ||
ATTRIBUTE11 | VARCHAR2 | (240) | ||
ATTRIBUTE12 | VARCHAR2 | (240) | ||
ATTRIBUTE13 | VARCHAR2 | (240) | ||
ATTRIBUTE14 | VARCHAR2 | (240) | ||
ATTRIBUTE15 | VARCHAR2 | (240) |
A public view which may be useful for custom reporting or other data requirements.
The view is used to list the availability of a part in a loop at different subinventories.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTS_LOOP_ID | NUMBER | (35) | Y | Parts loop identifier |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Y | Subinventory name |
CONDITION_TYPE | VARCHAR2 | (30) | Y | Subinventory condition type |
AVAILABLE_QUANTITY | NUMBER | Available quantity | ||
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
REVISION | VARCHAR2 | (3) | Item revision |
APPS.CSP_AVAILABLE_PARTS_IN_LOOP_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Frieght Code | |
LOCATION_ID | NUMBER | (15) | ||
SHIP_METHOD_CODE | VARCHAR2 | (30) | Shipping methode code | |
ROW_ID | ROWID | (10) | Row identifier | |
RELATION_SHIP_ID | NUMBER | (35) | Relation ship identifier | |
CREATED_BY | NUMBER | (35) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (35) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
LEAD_TIME | NUMBER | Lead time | ||
LEAD_TIME_UOM | VARCHAR2 | (3) | UOM Code | |
DELIVERY_TIME | DATE | Delivery time | ||
CUTOFF_TIME | DATE | Cut off time | ||
TIMEZONE_ID | NUMBER | (35) | Time zone identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
COMFORT_ZONE | NUMBER | Comfort zone | ||
TIMEZONE | VARCHAR2 | (80) | Time zone Name | |
SHIP_METHOD_CODE_MEANING | VARCHAR2 | (80) | ||
DISTANCE | NUMBER | |||
DISTANCE_UOM | VARCHAR2 | (10) |
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 |
---|---|---|---|---|
PLANNING_PARAMETERS_ID | NUMBER | (35) | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
SUPPLY_DEMAND_ID | NUMBER | (35) | Supply demand identifier | |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
ITEM_NUMBER | VARCHAR2 | (40) | Item number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
HIERARCHY_NODE_ID | NUMBER | (35) | Hierarchy node identifier | |
PARENT_NODE_ID | NUMBER | Parent node identifier | ||
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column - with the user id from FND_USER | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure | |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Subinventory name | |
NODE_TYPE | VARCHAR2 | (2) | Type of node | |
SECONDARY_INVENTORY_ID | NUMBER | (35) | Subinventory identifier | |
ONHAND_BAD | NUMBER | (35) | Onhand quantity for bad parts | |
ONHAND_GOOD | NUMBER | (35) | Onhand quantity for good parts | |
INTRANSIT_MOVE_ORDERS | NUMBER | (35) | Quantity on move orders being intransit | |
OPEN_PURCHASE_ORDERS | NUMBER | (35) | Quantity on open purchase orders | |
OPEN_SALES_ORDERS | NUMBER | (35) | Quantity on open sales orders | |
OPEN_WORK_ORDERS | NUMBER | (35) | Quantity on open work orders | |
OPEN_REQUISITIONS | NUMBER | (35) | Quantity on open requisitions | |
OPEN_MOVE_ORDERS_IN | NUMBER | (35) | Quantity on open move orders inbound | |
OPEN_MOVE_ORDERS_OUT | NUMBER | (35) | Quantity on open move orders outbound | |
OPEN_INTERORG_TRANSF_IN | NUMBER | (35) | Quantity on open interorg transfers inbound | |
OPEN_INTERORG_TRANSF_OUT | NUMBER | (35) | Quantity on open interorg transfers outbound | |
TRANSFER_IN | NUMBER | Sum transfers inbound | ||
TRANSFER_OUT | NUMBER | Sum transfers outbound | ||
EXCESS_QUANTITY | NUMBER | (35) | Excess quantity of item | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_CURR_SUP_DEM_SUMS_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 |
---|---|---|---|---|
NODE_NAME | VARCHAR2 | (60) | ||
PLANNING_PARAMETERS_ID | NUMBER | (38) | ||
ORGANIZATION_ID | NUMBER | |||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
PARENT_NODE_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
ONHAND_GOOD | NUMBER | (38) | ||
ONHAND_BAD | NUMBER | (38) | ||
INTRANSIT_MOVE_ORDERS | NUMBER | (38) | ||
OPEN_PURCHASE_ORDERS | NUMBER | (38) | ||
OPEN_SALES_ORDERS | NUMBER | (38) | ||
OPEN_WORK_ORDERS | NUMBER | (38) | ||
OPEN_REQUISITIONS | NUMBER | (38) | ||
OPEN_MOVE_ORDERS_IN | NUMBER | (38) | ||
OPEN_MOVE_ORDERS_OUT | NUMBER | (38) | ||
OPEN_INTERORG_TRANSF_IN | NUMBER | (38) | ||
OPEN_INTERORG_TRANSF_OUT | NUMBER | (38) | ||
TRANSFER_IN | NUMBER | |||
TRANSFER_OUT | NUMBER | |||
CREATION_DATE | DATE | Standard Who Column | ||
EXCESS_QUANTITY | NUMBER | Excess Quantity of item |
APPS.CSP_CURR_SUP_DEM_SUMS_V2 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 |
---|---|---|---|---|
REQUIREMENT_NUMBER | NUMBER | (35) | ||
REQUIREMENT_LINE_ID | NUMBER | (35) | ||
REQ_LINE_DETAIL_ID | NUMBER | |||
SOURCED_FROM | VARCHAR2 | (80) | ||
ORDER_NUMBER | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | (35) | ||
ITEM_NUMBER | VARCHAR2 | (40) | ||
CATEGORY | VARCHAR2 | (80) | ||
STATUS | VARCHAR2 | (4000) | ||
STATUS_MEANING | VARCHAR2 | (4000) | ||
ITEM_SUPPLIED | VARCHAR2 | (40) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SOURCE_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
REQUIRED_QUANTITY | NUMBER | |||
ORDERED_QUANTITY | NUMBER | |||
ORDERED_QUANTITY_UOM | VARCHAR2 | (3) | ||
NEED_BY_DATE | DATE | |||
ORDER_BY_DATE | DATE | |||
SCHEDULE_ARRIVAL_DATE | DATE | |||
TASK_ID | NUMBER | (35) | ||
TASK_ASSIGNMENT_ID | NUMBER | (35) | ||
SHIPPING_METHOD | VARCHAR2 | (80) | ||
DISTANCE | VARCHAR2 | (4000) | ||
SHIP_COST | NUMBER |
APPS.CSP_DC_PARTS_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 |
---|---|---|---|---|
PLANNING_PARAMETERS_ID | NUMBER | (35) | Y | Planning parameter identifier |
HISTORY_DAYS | NUMBER | The number of days to use in the usage history | ||
ENGINEER_DAYS | NUMBER | The number of days an engineer has been working in the current region. |
APPS.CSP_ENGINEER_DAYS_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 |
---|---|---|---|---|
EXPECTED_DELIVERY | DATE | Expected Delivery Date | ||
QUANTITY | NUMBER | |||
UOM | VARCHAR2 | (25) | Unit Of Measure | |
ITEM_ID | NUMBER | |||
ITEM_NUMBER | VARCHAR2 | (40) | Item Number | |
ORGANIZATION_ID | NUMBER | |||
DEST_SUBINV | VARCHAR2 | (10) | Destination Subinventory | |
SOURCE_NAME_ID | NUMBER | Source Name Identifier | ||
SOURCE_NAME | VARCHAR2 | (240) | Source Name | |
ORDER_TYPE | VARCHAR2 | (80) | Order Type | |
ORDER_NUMBER | VARCHAR2 | (240) | Order Number | |
STATUS | VARCHAR2 | (4000) | ||
LINE_TYPE | VARCHAR2 | (25) |
APPS.CSP_EOO_CANCEL_RECOMM_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 |
---|---|---|---|---|
EXCESS_LINE_ID | NUMBER | (35) | Y | Excess Line Identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization Identifier |
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | Organization Name |
EXCESS_STATUS | VARCHAR2 | (30) | Excess Status | |
EXCESS_STATUS_MEANING | VARCHAR2 | (80) | Y | Excess Status Meaning |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory Code | |
CONDITION_CODE | VARCHAR2 | (30) | Y | Condition Code |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory Item Identifier |
ITEM_NUMBER | VARCHAR2 | (40) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
ITEM_REVISION | VARCHAR2 | (3) | Item Revision | |
PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | Primary Unit Of Measure | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit Of Measure Code | |
EXCESS_QUANTITY | NUMBER | (35) | Y | Excess Quantity |
REQUISITION_HEADER_ID | NUMBER | Requisition Header Identifier | ||
REQUISITION_NUMBER | VARCHAR2 | (20) | Requisition Number | |
REQUISITION_LINE_ID | NUMBER | (35) | Requisition Line Identifier | |
RETURNED_QUANTITY | NUMBER | Returned Quantity | ||
CURRENT_RETURN_QTY | NUMBER | Current Return Quantity | ||
CURRENT_EXCESS_QUANTITY | NUMBER | Current Excess Quantity | ||
MAX_QUANTITY | NUMBER | Maximum Quantity | ||
NEED_BY_DATE | DATE | Need BY Date | ||
DELIVER_TO_LOCATION_ID | NUMBER | Deliver To Location Identifier | ||
RESOURCE_TYPE | VARCHAR2 | (30) | Resource Type | |
RESOURCE_ID | NUMBER | (35) | Resource Identifier | |
RETURN_ORGANIZATION_ID | NUMBER | (35) | Return Organization Identifier | |
RETURN_SUBINVENTORY_NAME | VARCHAR2 | (10) | Return Subinventory Name | |
CONDITION_TYPE_MEANING | VARCHAR2 | (80) | Y | Condition Type Meaning |
INTRANSIT_TYPE | NUMBER | Intransit Type | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_EXCESS_LISTS_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 | |
EXCESS_RULE_ID | NUMBER | (35) | Y | Excess Rule Identifier |
CREATED_BY | NUMBER | (35) | Y | standard Who Column |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | standard who column |
LAST_UPDATE_DATE | DATE | Y | standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard who column | |
EXCESS_RULE_NAME | VARCHAR2 | (30) | Y | Name of the excess rule |
DESCRIPTION | VARCHAR2 | (240) | Description of the excess rule | |
TOTAL_MAX_EXCESS | NUMBER | |||
LINE_MAX_EXCESS | NUMBER | |||
DAYS_SINCE_RECEIPT | NUMBER | (35) | ||
TOTAL_EXCESS_VALUE | NUMBER | |||
TOP_EXCESS_LINES | NUMBER | (35) | ||
CATEGORY_SET_ID | NUMBER | (35) | Category identifier | |
CATEGORY_ID | NUMBER | (35) | category identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_EXCESS_RULES_VL 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 |
---|---|---|---|---|
FAILURE_RATE_ID | NUMBER | (38) | Y | |
PRODUCT_ID | NUMBER | (38) | Y | |
INVENTORY_ITEM_ID | NUMBER | (38) | Y | |
CALCULATED_FAILURE_RATE | NUMBER | |||
MANUAL_FAILURE_RATE | NUMBER | |||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (38) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (38) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (38) | ||
SECURITY_GROUP_ID | NUMBER | (38) | ||
PLANNING_PARAMETERS_ID | NUMBER | (38) | Y |
APPS.CSP_FAILURE_RATES_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 | |
FORECAST_RULE_ID | NUMBER | (35) | Y | Forecast rule identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
FORECAST_RULE_NAME | VARCHAR2 | (240) | Y | Name of forecast rule |
PERIOD_TYPE | VARCHAR2 | (30) | Y | Period type |
PERIOD_SIZE | NUMBER | (35) | ||
FORECAST_PERIODS | NUMBER | (35) | Y | Number of forecast periods |
FORECAST_METHOD | VARCHAR2 | (30) | Y | Forecast method |
FORECAST_METHOD_DESCRIPTION | VARCHAR2 | (80) | Y | Description of forecast method |
HISTORY_PERIODS | NUMBER | (35) | Y | Number of history periods |
ALPHA | NUMBER | (35) | Alpha factor | |
BETA | NUMBER | (35) | Beta factor | |
TRACKING_SIGNAL_CYCLE | NUMBER | (35) | ||
WEIGHTED_AVG_PERIOD1 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD2 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD3 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD4 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD5 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD6 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD7 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD8 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD9 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD10 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD11 | NUMBER | Weighted average factor | ||
WEIGHTED_AVG_PERIOD12 | NUMBER | Weighted average factor | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
DESCRIPTION | VARCHAR2 | (240) | Forecast rule description |
APPS.CSP_FORECAST_RULES_B_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 | |
FORECAST_RULE_ID | NUMBER | (35) | Y | Forecast rule identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
FORECAST_RULE_NAME | VARCHAR2 | (240) | Y | Forecast rule name |
DESCRIPTION | VARCHAR2 | (240) | Forecast rule description | |
PERIOD_TYPE | VARCHAR2 | (30) | Y | Period type |
PERIOD_SIZE | NUMBER | (35) | ||
FORECAST_PERIODS | NUMBER | (35) | Y | Number of forecast periods |
FORECAST_METHOD | VARCHAR2 | (30) | Y | Forecast method |
HISTORY_PERIODS | NUMBER | (35) | Y | Number of history periods |
ALPHA | NUMBER | (35) | Alpha factor used by Exponential Smoothing and Trend Enhanced | |
BETA | NUMBER | (35) | Beta factor used by Trend Enhanced | |
TRACKING_SIGNAL_CYCLE | NUMBER | (35) | ||
WEIGHTED_AVG_PERIOD1 | NUMBER | Weigh to put on history period 1 for Weighted Average | ||
WEIGHTED_AVG_PERIOD2 | NUMBER | Weigh to put on history period 2 for Weighted Average | ||
WEIGHTED_AVG_PERIOD3 | NUMBER | Weigh to put on history period 3 for Weighted Average | ||
WEIGHTED_AVG_PERIOD4 | NUMBER | Weigh to put on history period 4 for Weighted Average | ||
WEIGHTED_AVG_PERIOD5 | NUMBER | Weigh to put on history period 5 for Weighted Average | ||
WEIGHTED_AVG_PERIOD6 | NUMBER | Weigh to put on history period 6 for Weighted Average | ||
WEIGHTED_AVG_PERIOD7 | NUMBER | Weigh to put on history period 7 for Weighted Average | ||
WEIGHTED_AVG_PERIOD8 | NUMBER | Weigh to put on history period 8 for Weighted Average | ||
WEIGHTED_AVG_PERIOD9 | NUMBER | Weigh to put on history period 9 for Weighted Average | ||
WEIGHTED_AVG_PERIOD10 | NUMBER | Weigh to put on history period 10 for Weighted Average | ||
WEIGHTED_AVG_PERIOD11 | NUMBER | Weigh to put on history period 11 for Weighted Average | ||
WEIGHTED_AVG_PERIOD12 | NUMBER | Weigh to put on history period 12 for Weighted Average | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_FORECAST_RULES_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
The view is used for getting lot numbers for an item at the locator, subinventory or organization as per the level specified. This view should be called with a WHERE clause specifying the organization, subinventory or the locator for which the lot numbers for the item should be fetched.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
REVISION | VARCHAR2 | (3) | Item revision | |
LOT_NUMBER | VARCHAR2 | (80) | Y | Lot number |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Y | Subinventory name |
LOCATOR_ID | NUMBER | Locator identifier |
APPS.CSP_GET_LOT_NUMBERS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
The view is used for getting serial numbers of an item at the locator, subinventory or organization as per the level specified. This view should be called with a WHERE clause specifying the organization, subinventory or the locator for which the serial numbers for the item should be fetched.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
REVISION | VARCHAR2 | (3) | Item revision | |
SERIAL_NUMBER | VARCHAR2 | (30) | Y | Serial number |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory name | |
LOCATOR_ID | NUMBER | Locator identifier | ||
LOT_NUMBER | VARCHAR2 | (80) | Lot number | |
CURRENT_STATUS | NUMBER | Serial number status |
APPS.CSP_GET_SERIAL_NUMBERS_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 |
---|---|---|---|---|
CSP_INV_LOC_ASSIGNMENT_ID | NUMBER | (35) | Y | Location assignment identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
RESOURCE_ID | NUMBER | (35) | Y | Resource identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Y | Subinventory name |
LOCATOR_ID | NUMBER | (35) | Locator identifier | |
RESOURCE_TYPE | VARCHAR2 | (30) | Y | Resrouce type |
EFFECTIVE_DATE_START | DATE | Start date | ||
EFFECTIVE_DATE_END | DATE | End date | ||
DEFAULT_CODE | VARCHAR2 | (30) | Default code | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_INV_LOC_ASSIGNMENTS_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 | |
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
SECONDARY_INVENTORY | VARCHAR2 | (10) | Y | Subinventory name |
SUB_DESCRIPTION | VARCHAR2 | (50) | Subinventory description | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column - with the user id from FND_USER | |
CREATION_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | Y | Standard Who Column - with the user id from FND_USER | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
PRIMARY_SUBINVENTORY_FLAG | NUMBER | Primary subinventory flag | ||
PICKING_ORDER | NUMBER | Picking order | ||
MIN_MINMAX_QUANTITY | NUMBER | Subinventory-level minmax planning minimum quantity | ||
MAX_MINMAX_QUANTITY | NUMBER | Subinventory-level minmax planning maximum quantity | ||
INVENTORY_PLANNING_CODE | NUMBER | Y | Item planning method | |
FIXED_LOT_MULTIPLE | NUMBER | Subinventory-level fixed lot multiple | ||
MINIMUM_ORDER_QUANTITY | NUMBER | Subinventory-level minimum order quantity | ||
MAXIMUM_ORDER_QUANTITY | NUMBER | Subinventory-level maximum order quantity | ||
SOURCE_TYPE | NUMBER | Inventory or supplier source type | ||
SOURCE_TYPE_NAME | VARCHAR2 | (12) | ||
SOURCE_ORGANIZATION_ID | NUMBER | Organization identifier to source items from | ||
SOURCE_ORGANIZATION | VARCHAR2 | (3) | Organization code to source items from | |
SOURCE_ORG_NAME | VARCHAR2 | (240) | Organization name to source items from | |
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | Subinventory to source items from | |
ENCUMBRANCE_ACCOUNT | NUMBER | Encumbrance account | ||
PREPROCESSING_LEAD_TIME | NUMBER | Pre-processing lead time | ||
PROCESSING_LEAD_TIME | NUMBER | Processing lead time | ||
POSTPROCESSING_LEAD_TIME | NUMBER | Post-processing lead time | ||
MANUAL_AUTO | VARCHAR2 | (30) | ||
REASON_CODE | VARCHAR2 | (30) | ||
REASON_CODE_MEANING | VARCHAR2 | (80) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
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 |
---|---|---|---|---|
DESCRIPTION | VARCHAR2 | (2000) | ||
ADDRESS1 | VARCHAR2 | (240) | ||
ADDRESS2 | VARCHAR2 | (240) | ||
ADDRESS3 | VARCHAR2 | (240) | ||
ADDRESS4 | VARCHAR2 | (240) | ||
CITY | VARCHAR2 | (60) | ||
POSTAL_CODE | VARCHAR2 | (60) | ||
STATE | VARCHAR2 | (60) | ||
PROVINCE | VARCHAR2 | (60) | ||
COUNTY | VARCHAR2 | (60) | ||
ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | ||
COUNTRY | VARCHAR2 | (60) | ||
LOCATION_ID | NUMBER | |||
PARTY_SITE_ID | NUMBER |
APPS.CSP_LOCATION_ADDRESS_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 | |
CALCULATION_RULE_ID | NUMBER | (35) | Y | Calculation rule identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
CALCULATION_RULE_NAME | VARCHAR2 | (150) | Y | Name of calculation rule |
DESCRIPTION | VARCHAR2 | (240) | Description of calculation rule | |
INCLUDE_SALES_ORDERS | VARCHAR2 | (30) | Y | Include sales orders |
INCLUDE_MOVE_ORDERS | VARCHAR2 | (30) | Include move orders | |
INCLUDE_REPAIR_ORDERS | VARCHAR2 | (30) | Y | Not used |
INCLUDE_WORK_ORDERS | VARCHAR2 | (30) | Y | Include work orders |
INCLUDE_PURCHASE_ORDERS | VARCHAR2 | (30) | Y | Include purchase orders |
INCLUDE_REQUISITIONS | VARCHAR2 | (30) | Y | Include requisitions |
INCLUDE_INTERORG_TRANSFERS | VARCHAR2 | (30) | Y | Include interorganization transfers |
INCLUDE_ONHAND_GOOD | VARCHAR2 | (30) | Y | Include onhand good quantity |
INCLUDE_ONHAND_BAD | VARCHAR2 | (30) | Y | Include onhand bad quantity |
INCLUDE_INTRANSIT_MOVE_ORDERS | VARCHAR2 | (30) | Include move orders intransit | |
INCLUDE_DOA | VARCHAR2 | (30) | ||
ROLLUP_SUPERCESSION | VARCHAR2 | (30) | ||
FORECAST_LOWER_SUPERCESSION | VARCHAR2 | (30) | ||
TOLERANCE_PERCENT | NUMBER | (35) | Y | Tolerance percentage |
TIME_FENCE | NUMBER | (35) | Y | Number of days in time fence |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_LOOP_CALC_RULES_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 | |
CALCULATION_RULE_ID | NUMBER | (35) | Y | Calculation rule identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
CALCULATION_RULE_NAME | VARCHAR2 | (150) | Y | Calculation rule name |
DESCRIPTION | VARCHAR2 | (240) | Calculation rule description | |
INCLUDE_SALES_ORDERS | VARCHAR2 | (30) | Y | Include sales orders Y/N |
INCLUDE_MOVE_ORDERS | VARCHAR2 | (30) | Include move orders Y/N | |
INCLUDE_REPAIR_ORDERS | VARCHAR2 | (30) | Y | Include repair orders Y/N |
INCLUDE_WORK_ORDERS | VARCHAR2 | (30) | Y | Include work orders Y/N |
INCLUDE_PURCHASE_ORDERS | VARCHAR2 | (30) | Y | Include purchase orders Y/N |
INCLUDE_REQUISITIONS | VARCHAR2 | (30) | Y | Include requisitions Y/N |
INCLUDE_INTERORG_TRANSFERS | VARCHAR2 | (30) | Y | Include interorg transfers |
INCLUDE_ONHAND_GOOD | VARCHAR2 | (30) | Y | Include onhand useable |
INCLUDE_ONHAND_BAD | VARCHAR2 | (30) | Y | Include onhand defective |
INCLUDE_INTRANSIT_MOVE_ORDERS | VARCHAR2 | (30) | Include intransit move orders | |
INCLUDE_DOA | VARCHAR2 | (30) | ||
ROLLUP_SUPERCESSION | VARCHAR2 | (30) | ||
FORECAST_LOWER_SUPERCESSION | VARCHAR2 | (30) | ||
TOLERANCE_PERCENT | NUMBER | (35) | Y | Tolerance percent |
TIME_FENCE | NUMBER | (35) | Y | Time fence |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment column |
APPS.CSP_LOOP_CALC_RULES_VL 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 |
---|---|---|---|---|
TXN_DATE | DATE | Y | Transaction date | |
ORGID | NUMBER | Y | Organization identifier | |
ITEM_ID | NUMBER | Y | Inventory item identifier | |
SUBINV | VARCHAR2 | (10) | Subinventory name | |
LOCATOR | CHAR | (1) | Concatenated locator segments | |
QUANTITY | NUMBER | Transaction quantity | ||
USER_NAME | VARCHAR2 | (100) | Y | User name |
TXNTYPEID | NUMBER | Y | Transaction type identifier | |
ERR | VARCHAR2 | (240) | Transaction error |
APPS.CSP_MATERIAL_TRANSACTIONS_V1 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 |
---|---|---|---|---|
NOTIFICATION_ID | NUMBER | (35) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ITEM_COST | NUMBER | Item Cost | ||
PLANNER_CODE | VARCHAR2 | (10) | ||
NOTIFICATION_TYPE | VARCHAR2 | (30) | ||
NOTIFICATION_TYPE_MEANING | VARCHAR2 | (80) | Y | |
NOTIFICATION_QTY | NUMBER | (35) | ||
NOTIFICATION_DATE | DATE | Y | ||
EXCESS_QTY | NUMBER | |||
REPAIR_QTY | NUMBER | |||
NEED_DATE | DATE | |||
ORDER_BY_DATE | DATE | Order by date | ||
STATUS | VARCHAR2 | (30) | Y | Notification status |
STATUS_DESC | VARCHAR2 | (80) | Y | Notification status meaning |
APPS.CSP_MINMAX_NOTIFS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
The view gives the status of a moveorder.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Move order header identifier | ||
REQUEST_NUMBER | VARCHAR2 | (30) | Move order request number | |
ORGANIZATION_ID | NUMBER | Organization identifier | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization Code | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Organization Name | |
DATE_REQUIRED | DATE | Date required | ||
LINE_ID | NUMBER | Move order line identifier | ||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
FROM_SUBINVENTORY_CODE | VARCHAR2 | (10) | Name of source subinventory | |
FROM_LOCATOR_ID | NUMBER | Source locator identifier | ||
TO_SUBINVENTORY_CODE | VARCHAR2 | (10) | Name of destination subinventory | |
TO_LOCATOR_ID | NUMBER | Destination locator identifier | ||
REVISION | VARCHAR2 | (3) | Item revision | |
QUANTITY | NUMBER | Quantity ordered | ||
LINE_STATUS_ID | VARCHAR2 | (40) | Line status identifier | |
LINE_STATUS | VARCHAR2 | (80) | Line status | |
STATUS_DATE | DATE | Line status date | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Item number | |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
DATE_ORDERED | DATE | Date ordered | ||
INCIDENT_ID | NUMBER | Service request identifier | ||
TASK_ID | NUMBER | Task identifier | ||
WAYBILL | VARCHAR2 | (60) | Waybill number | |
CARRIER | VARCHAR2 | (60) | Name of carrier | |
SHIPMENT_METHOD | VARCHAR2 | (60) | Shipment method | |
PICKLIST_HEADER_ID | NUMBER | Picklist header identifier | ||
PICKLIST_NUMBER | VARCHAR2 | (30) | Picklist number | |
DATE_PICKED | DATE | Date picked | ||
QUANTITY_PICKED | NUMBER | Quantity picked | ||
PACKLIST_HEADER_ID | NUMBER | Packlist header identifier | ||
PACKLIST_NUMBER | VARCHAR2 | (10) | Packlist number | |
DATE_PACKED | DATE | Date packed | ||
DATE_SHIPPED | DATE | Date shipped | ||
DATE_RECEIVED | DATE | Date received | ||
QUANTITY_PACKED | NUMBER | Quantity packed | ||
QUANTITY_SHIPPED | NUMBER | Quantity shipped | ||
QUANTITY_RECEIVED | NUMBER | Quantity received |
APPS.CSP_MOVEORDERS_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 |
---|---|---|---|---|
HEADER_ID | NUMBER | (35) | Y | Move order header identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
CARRIER | VARCHAR2 | (30) | Name of carrier | |
SHIPMENT_METHOD | VARCHAR2 | (30) | Shipment method | |
AUTORECEIPT_FLAG | VARCHAR2 | (30) | Autoreceipt flag | |
PARTY_SITE_ID | NUMBER | (35) | ||
LOCATION_ID | NUMBER | (35) | Location identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_MOVEORDER_HEADERS_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 |
---|---|---|---|---|
LINE_ID | NUMBER | (35) | Y | Move order line identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_LOGIN | NUMBER | (35) | Standard Who Column | |
HEADER_ID | NUMBER | (35) | Y | Move order header identifier |
CUSTOMER_PO | VARCHAR2 | (30) | Customer's purchase order number | |
INCIDENT_ID | NUMBER | (35) | Service request identifier | |
TASK_ID | NUMBER | (35) | Task identifier | |
TASK_ASSIBNMENT_ID | NUMBER | (35) | Task assignment identifier | |
COMMENTS | VARCHAR2 | (240) | Comments | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_MOVEORDER_LINES_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 | |
LINE_ID | NUMBER | Y | Move order line identifier | |
REQUEST_NUMBER | VARCHAR2 | (30) | Y | Move order number |
MOVE_ORDER_TYPE | NUMBER | Move order type | ||
MOVE_ORDER_TYPE_NAME | VARCHAR2 | (80) | Y | Name of move order type |
DESCRIPTION | VARCHAR2 | (240) | Description | |
HEADER_ID | NUMBER | Y | Move order header identifier | |
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Y | Transaction source type identifier | |
TRANSACTION_TYPE_ID | NUMBER | Y | Transaction type identifier | |
TRANSACTION_TYPE_NAME | VARCHAR2 | (80) | Y | Transaction type name |
TRANSACTION_ACTION_ID | NUMBER | Y | Transaction action identifier | |
LINE_NUMBER | NUMBER | Y | Move order line number | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
REVISION | VARCHAR2 | (3) | Item revision | |
FROM_SUBINVENTORY_ID | NUMBER | Source subinventory identifier | ||
FROM_SUBINVENTORY_CODE | VARCHAR2 | (10) | Source subinventory name | |
FROM_SUB_LOCATOR_TYPE | NUMBER | Source subinventory locator type | ||
FROM_SUB_ASSET | NUMBER | Source subinventory asset | ||
FROM_SUB_QUANTITY_TRACKED | NUMBER | Quantity tracked source subinventory | ||
FROM_SUB_MATERIAL_ACCOUNT | NUMBER | Source subinventory material account | ||
FROM_LOCATOR_ID | NUMBER | Source locator identifier | ||
TO_SUBINVENTORY_CODE | VARCHAR2 | (10) | Destination subinventory name | |
TO_SUB_LOCATOR_TYPE | NUMBER | Destination subinventory locator type | ||
TO_SUB_ASSET | NUMBER | Destination subinventory asset | ||
TO_SUB_QUANTITY_TRACKED | NUMBER | Quantity tracked destination subinventory | ||
TO_SUB_MATERIAL_ACCOUNT | NUMBER | Destination subinventory material account | ||
TO_SUBINVENTORY_ID | NUMBER | Destination subinventory identifier | ||
TO_LOCATOR_ID | NUMBER | Destination locator identifier | ||
TO_ACCOUNT_ID | NUMBER | Destination account identifier | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship to location identifier | ||
LOT_NUMBER | VARCHAR2 | (80) | Lot number | |
SERIAL_NUMBER_START | VARCHAR2 | (30) | Beginning serial number | |
SERIAL_NUMBER_END | VARCHAR2 | (30) | Ending serial number | |
UNIT_NUMBER | VARCHAR2 | (30) | Unit number | |
UOM_CODE | VARCHAR2 | (3) | Y | Uni of measure |
QUANTITY | NUMBER | Y | Quantity | |
QUANTITY_DELIVERED | NUMBER | Quantity delivered | ||
QUANTITY_DETAILED | NUMBER | Quantity detailed | ||
DATE_REQUIRED | DATE | Y | Date required | |
REASON_ID | NUMBER | Reason identifier | ||
REFERENCE | VARCHAR2 | (240) | Reference | |
REFERENCE_TYPE_CODE | NUMBER | Reference type code | ||
REFERENCE_ID | NUMBER | Reference identifier | ||
PROJECT_ID | NUMBER | Project identifier | ||
TASK_ID | NUMBER | Task identifier | ||
TRANSACTION_HEADER_ID | NUMBER | Transaction header identifier | ||
LINE_STATUS | NUMBER | Y | Line status | |
STATUS_DATE | DATE | Y | Line status date | |
LAST_UPDATED_BY | NUMBER | Y | Standard Who Column - with the user id from FND_USER | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
CREATED_BY | NUMBER | Standard Who Column - with the user id from FND_USER | ||
CREATION_DATE | DATE | Y | Standard Who Column | |
REQUEST_ID | NUMBER | Standard Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who Column | ||
PROGRAM_ID | NUMBER | Standard Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
TXN_SOURCE_ID | NUMBER | Transaction source identifier | ||
TXN_SOURCE_LINE_ID | NUMBER | Transaction source line identifier | ||
TXN_SOURCE_LINE_DETAIL_ID | NUMBER | Transaction source line detail identifier | ||
PRIMARY_QUANTITY | NUMBER | Primary quantity | ||
TO_ORGANIZATION_ID | NUMBER | Destination organization identifier | ||
PICK_STRATEGY_ID | NUMBER | Pick strategy identifier | ||
PUT_AWAY_STRATEGY_ID | NUMBER | Put away strategy identifier | ||
FROM_COST_GROUP_ID | NUMBER | From cost group identifier | ||
FROM_COST_GROUP_NAME | VARCHAR2 | (10) | From cost group name | |
TO_COST_GROUP_ID | NUMBER | To cost group identifier | ||
TO_COST_GROUP_NAME | VARCHAR2 | (10) | To cost group name | |
LPN_ID | NUMBER | LPN identifier | ||
TO_LPN_ID | NUMBER | To LPN identifier | ||
REFERENCE_DETAIL_ID | NUMBER | Reference detail identifier | ||
ASSIGNMENT_ID | NUMBER | Assignment identifier | ||
LPN_NUMBER | VARCHAR2 | (30) | LPN number | |
TO_LPN_NUMBER | VARCHAR2 | (30) | To LPN number | |
SERVICE_REQUEST_ID | NUMBER | (35) | Service request identifier | |
SERVICE_REQUEST_NUMBER | VARCHAR2 | (64) | Service request number | |
SERVICE_TASK_ID | NUMBER | (35) | Service task identifier | |
SERVICE_TASK_NUMBER | VARCHAR2 | (30) | Service task number | |
TASK_ASSIGNMENT_ID | NUMBER | (35) | Service task assignment identifier | |
CUSTOMER_PO | VARCHAR2 | (30) | Customer's purchase order number | |
SERVICE_COMMENTS | VARCHAR2 | (240) | Service comments |
APPS.CSP_MO_LINES_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 | |
MSL_ID | NUMBER | (35) | Y | Master stock list identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
PLANNING_TYPE_CODE | VARCHAR2 | (30) | Planning type code | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
REVISION | VARCHAR2 | (3) | Item revision | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
PLANNER_CODE | VARCHAR2 | (10) | Y | Planner code |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
TOTAL_LOOP_QUANTITY | NUMBER | (35) | Y | Total quantity in loop |
TOTAL_LOOP_MIN_GOOD_QUANTITY | NUMBER | Mininum quantity of good parts in loop | ||
LAST_UPDATED_LOGIN | NUMBER | (35) | Standard Who Column | |
PARTS_LOOPS_ID | NUMBER | (35) | Y | Parts loop identifier |
MEANING | VARCHAR2 | (80) | Y | Planning type |
APPS.CSP_MSTRSTCK_LISTS_ITMS_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 |
---|---|---|---|---|
TREE_ROOT_ID | NUMBER | (15) | Y | Tree root identifier |
NODE_TYPE_ID | NUMBER | (15) | Y | Node type identifier |
ROOT_KEY | VARCHAR2 | (240) | Y | Name of root node |
NODE_TYPE | VARCHAR2 | (240) | Y | Node type |
AK_FLOW_NAME | VARCHAR2 | (30) | Name of the flow associated with the tree | |
AK_PARENT_PAGE_NAME | VARCHAR2 | (30) | Parent page name in the flow | |
AK_PK_NAME | VARCHAR2 | (30) | Primary key of the object | |
AK_WHERE_CLAUSE | VARCHAR2 | (2000) | Optional where clause for the flow | |
AK_WHERE_BINDS | VARCHAR2 | (2000) | Bind variables for the where clause | |
ICON_NAME | VARCHAR2 | (30) | Icon name for the node | |
FORM_NAME | VARCHAR2 | (30) | Name of the form to be called when node is activated | |
FORM_PARAM_LIST | VARCHAR2 | (2000) | Parameters to be passed to the calling form | |
STATIC_CHILD_FLAG | VARCHAR2 | (1) | Static child flag | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column - with the user id from FND_USER | |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column |
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 | |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column - with the user id from FND_USER | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column - with the user id from FND_USER | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column - with the user id from FND_USER | |
NOTIFICATION_ID | NUMBER | (35) | Y | Notification identifier |
PLANNER_CODE | VARCHAR2 | (10) | Planner code | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
NOTIFICATION_DATE | DATE | Y | Notification date | |
REASON | VARCHAR2 | (240) | Y | Reason for the notification |
REASON_MEANING | VARCHAR2 | (80) | Y | Reason for the notification |
STATUS | VARCHAR2 | (30) | Y | Status of the notification |
STATUS_MEANING | VARCHAR2 | (80) | Y | Status of the notification |
QUANTITY | NUMBER | (35) | Quantity | |
ITEM_NUMBER | VARCHAR2 | (40) | Item number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary unit of measure | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_NOTIFICATIONS_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 |
---|---|---|---|---|
NOTIFICATION_DETAIL_ID | NUMBER | (38) | Y | |
NOTIFICATION_ID | NUMBER | (38) | Y | |
INVENTORY_ITEM_ID | NUMBER | (38) | Y | |
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
AVAILABLE_QUANTITY | NUMBER | (38) | Y | |
ORDER_BY_DATE | DATE | Y | ||
SOURCE_TYPE | VARCHAR2 | (30) | Y | |
SOURCE_TYPE_MEANING | VARCHAR2 | (80) | Y | |
SOURCE_ORGANIZATION_ID | NUMBER | (38) | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | (38) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (38) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who Column - with the user id from FND_USER | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
REPAIR_SUPPLIER_ID | NUMBER | (38) | Repair Supplier Idnetifier | |
ORDER_NUMBER | NUMBER | Order Number |
APPS.CSP_NOTIFICATION_DETAILS_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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (30) | Y | Parts loop name |
NODE_TYPE | VARCHAR2 | (240) | Y | Parts loop |
NODE_KEY | NUMBER | (35) | Y | Parts loop identifier |
ICON_NAME | VARCHAR2 | (30) | Icon name | |
LEAF_FLAG | CHAR | (1) | Leaf node or not | |
PARENT_NODE_TYPE | CHAR | (4) | Node type of parent node | |
PARENT_NODE_KEY | VARCHAR2 | (240) | Y | Node key for the parent node |
APPS.CSP_NOT_PLOOP_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (80) | Y | Notification type description |
NODE_TYPE | VARCHAR2 | (240) | Y | Notification type |
NODE_KEY | VARCHAR2 | (75) | Combination of Notification type code and Parts Loop identifier | |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (16) | Parts Loop | |
PARENT_NODE_KEY | NUMBER | (35) | Y | Parts Loop identifier |
APPS.CSP_NOT_PLTYPES_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (40) | Item Name | |
NODE_TYPE | VARCHAR2 | (240) | Y | Notification Items |
NODE_KEY | VARCHAR2 | (42) | Inventory Item Identifier | |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (12) | Notification Status | |
PARENT_NODE_KEY | VARCHAR2 | (318) | Combination of Notification status,reason code and Parts Loop Identifier |
APPS.CSP_NOT_STAT_ITEMS_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (80) | Y | Status Description |
NODE_TYPE | VARCHAR2 | (240) | Y | Notification Status |
NODE_KEY | VARCHAR2 | (108) | Combination of Notification status code,Notification type code and Parts Loop identifier | |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (11) | Notification type | |
PARENT_NODE_KEY | VARCHAR2 | (75) | Notification type code and Parts Loop Identifier |
APPS.CSP_NOT_TYSTAT_NAV 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 |
---|---|---|---|---|
TASK_ID | NUMBER | (35) | ||
TASK_ASSIGNMENT_ID | NUMBER | (35) | ||
ORDER_BY_DATE | DATE |
APPS.CSP_ORDERS_DUE_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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | (38) | Y | |
PERIOD_START_DATE | DATE | |||
QUANTITY | NUMBER |
APPS.CSP_ORG_USAGE_DETAILS_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 | |
BOX_ID | NUMBER | (35) | Y | Box identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
BOX_NAME | VARCHAR2 | (30) | Y | Box name |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PACKLIST_HEADER_ID | NUMBER | (35) | Y | Packlist header identifier |
WEIGHT | NUMBER | (35) | Weight of box | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_PACKLIST_BOXES_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 | |
PACKLIST_HEADER_ID | NUMBER | (35) | Y | Packlist header identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PACKLIST_NUMBER | VARCHAR2 | (10) | Y | Packlist number |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory name | |
PACKLIST_STATUS | VARCHAR2 | (30) | Y | Packlist status |
DATE_CREATED | DATE | Y | Date when packlist was created | |
DATE_PACKED | DATE | Date when packlist was packed | ||
DATE_SHIPPED | DATE | Date when packlist was shipped | ||
DATE_RECEIVED | DATE | Date when shipment was received | ||
CARRIER | VARCHAR2 | (60) | Name of carrier | |
SHIPMENT_METHOD | VARCHAR2 | (60) | Shipment method | |
WAYBILL | VARCHAR2 | (60) | Waybill number | |
COMMENTS | VARCHAR2 | (240) | Packlist comments | |
LOCATION_ID | NUMBER | (35) | Location identifier | |
PARTY_SITE_ID | NUMBER | (35) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_PACKLIST_HEADERS_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 |
---|---|---|---|---|
PACKLIST_LINE_ID | NUMBER | (35) | Y | Packlist line identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PACKLIST_LINE_NUMBER | NUMBER | (35) | Y | Packlist line number |
PACKLIST_HEADER_ID | NUMBER | (35) | Y | Packlist header identifier |
BOX_ID | NUMBER | (35) | Y | Box identifier |
PICKLIST_LINE_ID | NUMBER | (35) | Picklist line identifier | |
PACKLIST_LINE_STATUS | VARCHAR2 | (30) | Y | Packlist line status |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
QUANTITY_PACKED | NUMBER | (35) | Y | Quantity packed |
QUANTITY_SHIPPED | NUMBER | (35) | Quantity shipped | |
QUANTITY_RECEIVED | NUMBER | (35) | Quantity received | |
UOM_CODE | VARCHAR2 | (3) | Y | Unit of measure |
LINE_ID | NUMBER | (35) | Y | Move order line identifier |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_PACKLIST_LINES_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 |
---|---|---|---|---|
PACKLIST_LINE_ID | NUMBER | (35) | Packlist line identifier | |
QUANTITY | NUMBER | Quantity | ||
SERIAL_NUMBER | VARCHAR2 | (240) | Serial number | |
LOT_NUMBER | VARCHAR2 | (80) | Lot number |
APPS.CSP_PACKLIST_SERIAL_LOTS_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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (10) | Y | Packlist Number |
NODE_TYPE | VARCHAR2 | (240) | Y | Packlist Node |
NODE_KEY | NUMBER | (35) | Y | Packlist header identifier |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (12) | Packlist Status | |
PARENT_NODE_KEY | VARCHAR2 | (30) | Y | Packlist status identifier |
APPS.CSP_PACK_LIST_NAV 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 | |
PARTS_LOOP_ID | NUMBER | (35) | Y | Parts loop identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
PLANNER_CODE | VARCHAR2 | (10) | Y | Planner code |
CALCULATION_RULE_ID | NUMBER | (35) | Y | Calculation rule identifier |
FORECAST_RULE_ID | NUMBER | (35) | Y | Forecast rule identifier |
PARTS_LOOP_NAME | VARCHAR2 | (30) | Y | Parts loop name |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
DESCRIPTION | VARCHAR2 | (240) | Parts loop description | |
FORECAST_RULE_NAME | VARCHAR2 | (240) | Y | Forecast rule name |
CALCULATION_RULE_NAME | VARCHAR2 | (150) | Y | Calculation rule name |
APPS.CSP_PARTS_LOOPS_B_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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (30) | Y | Parts Loop Name |
NODE_TYPE | VARCHAR2 | (240) | Y | Parts Loop Node |
NODE_KEY | NUMBER | (35) | Y | Parts Loop Identifier |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (4) | Root Node | |
PARENT_NODE_KEY | VARCHAR2 | (240) | Y | Root Node Name |
APPS.CSP_PARTS_LOOPS_NAV 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 | |
PARTS_LOOP_ID | NUMBER | (35) | Y | Parts loop identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
DESCRIPTION | VARCHAR2 | (240) | Parts loop description | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
PLANNER_CODE | VARCHAR2 | (10) | Y | Planner code |
CALCULATION_RULE_ID | NUMBER | (35) | Y | Calculation rule identifier |
FORECAST_RULE_ID | NUMBER | (35) | Y | Forecast rule identifier |
PARTS_LOOP_NAME | VARCHAR2 | (30) | Y | Parts loop name |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment column |
APPS.CSP_PARTS_LOOPS_VL is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
Shows the spare part categories.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CATEGORY | VARCHAR2 | (80) | Part category | |
LOW | NUMBER | Low limit | ||
HIGH | NUMBER | High limit |
APPS.CSP_PART_CATEGORIES_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 | |
PICKLIST_HEADER_ID | NUMBER | Y | Picklist header identifier | |
CREATED_BY | NUMBER | (15) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
PICKLIST_NUMBER | VARCHAR2 | (30) | Y | Picklist number |
PICKLIST_STATUS | VARCHAR2 | (30) | Y | Picklist status |
DATE_CREATED | DATE | Date when picklist was created | ||
DATE_CONFIRMED | DATE | Date when picklist was confirmed | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column | |
PICKLIST_STATUS_NAME | VARCHAR2 | (80) | Picklist status meaning |
APPS.CSP_PICKLIST_HEADERS_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 |
---|---|---|---|---|
PICKLIST_LINE_ID | NUMBER | (35) | Y | Picklist line identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
PICKLIST_LINE_NUMBER | NUMBER | (35) | Y | Picklist line number |
PICKLIST_HEADER_ID | NUMBER | (35) | Y | Picklist header identifier |
LINE_ID | NUMBER | (35) | Y | Mover order line identifier |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
UOM_CODE | VARCHAR2 | (3) | Y | Unit of measure |
REVISION | VARCHAR2 | (3) | Item revision | |
QUANTITY_PICKED | NUMBER | (35) | Y | Quantity picked |
TRANSACTION_TEMP_ID | NUMBER | (35) | Y | Temporary transaction identifier |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_PICKLIST_LINES_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 | |
PICKLIST_NUMBER | VARCHAR2 | (30) | Y | Picklist number |
PICKLIST_HEADER_ID | NUMBER | Y | Picklist header identifier | |
ITEM_NUMBER | VARCHAR2 | (40) | Item number | |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
REVISION | VARCHAR2 | (3) | Item revision | |
REQUEST_NUMBER | VARCHAR2 | (30) | Y | Move order request number |
HEADER_ID | NUMBER | Y | Move order header id | |
LINE_NUMBER | NUMBER | Y | Move order line number | |
LINE_ID | NUMBER | Y | Mover order line identifier | |
ORGANIZATION_ID | NUMBER | Y | Organization Identifier | |
QUANTITY_PICKED | NUMBER | Quantity picked | ||
PICKLIST_LINE_NUMBER | NUMBER | (35) | Y | Picklist line number |
PICKLIST_LINE_ID | NUMBER | (35) | Y | Picklist line identifier |
UOM_CODE | VARCHAR2 | (3) | Y | Unit of measure |
SERVICE_REQUEST_NUMBER | VARCHAR2 | (64) | Service request number | |
DATE_REQUIRED | DATE | Y | Date required | |
LOCATION_ID | NUMBER | (35) | Location identifier | |
PARTY_SITE_ID | NUMBER | (35) | ||
SUBINVENTORY_CODE | VARCHAR2 | (10) | Y | |
CARRIER | VARCHAR2 | (30) | Carrier | |
SHIPMENT_METHOD | VARCHAR2 | (30) | Shipment method |
APPS.CSP_PICKLIST_LINES_V1 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 |
---|---|---|---|---|
PICKLIST_LINE_ID | NUMBER | (35) | Y | Picklist line identifier |
SERIAL_NUMBER | VARCHAR2 | (30) | Serial number | |
LOT_NUMBER | VARCHAR2 | (240) | Lot number | |
QUANTITY | NUMBER | Quantity |
APPS.CSP_PICKLIST_SERIAL_LOTS_V1 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_HEADER_ID | NUMBER | Transaction group identifier | ||
TRANSACTION_TEMP_ID | NUMBER | Transaction line identifier used to join to lot or serial table when under these controls | ||
SOURCE_CODE | VARCHAR2 | (30) | Source identifier | |
SOURCE_LINE_ID | NUMBER | Source line identifier | ||
TRANSACTION_MODE | NUMBER | Process mode code | ||
LOCK_FLAG | VARCHAR2 | (1) | Row lock flag used by transaction manager | |
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 | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
REVISION | VARCHAR2 | (3) | Inventory item revision code | |
ORGANIZATION_ID | NUMBER | Y | Organization identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory name | |
LOCATOR_ID | NUMBER | Locator identifier | ||
TRANSACTION_QUANTITY | NUMBER | Y | Quantity entered at transaction time | |
PRIMARY_QUANTITY | NUMBER | Y | Transaction quantity in terms of the primary uom of the item | |
TRANSACTION_UOM | VARCHAR2 | (3) | Y | UOM used at the time of transaction |
TRANSACTION_COST | NUMBER | Transaction cost | ||
TRANSACTION_TYPE_ID | NUMBER | Y | Transaction type identifier | |
TRANSACTION_ACTION_ID | NUMBER | Y | Transaction action identifier | |
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Y | Transaction source type identifier | |
TRANSACTION_SOURCE_ID | NUMBER | Transaction source identifier | ||
TRANSACTION_SOURCE_NAME | VARCHAR2 | (80) | Transaction source name | |
TRANSACTION_DATE | DATE | Y | Transaction date | |
ACCT_PERIOD_ID | NUMBER | Y | Accounting period identifier | |
DISTRIBUTION_ACCOUNT_ID | NUMBER | Account identifier the transaction charged to | ||
TRANSACTION_REFERENCE | VARCHAR2 | (240) | Transaction reference | |
REQUISITION_LINE_ID | NUMBER | Requisition line identifier | ||
REQUISITION_DISTRIBUTION_ID | NUMBER | Requisition distribution identifier | ||
REASON_ID | NUMBER | Transaction reason identifier | ||
LOT_NUMBER | VARCHAR2 | (80) | Lot number | |
LOT_EXPIRATION_DATE | DATE | Lot expiration date | ||
SERIAL_NUMBER | VARCHAR2 | (30) | Serial number | |
RECEIVING_DOCUMENT | VARCHAR2 | (10) | Receiving document | |
DEMAND_ID | NUMBER | Demand identifier | ||
RCV_TRANSACTION_ID | NUMBER | Receiving transaction identifier | ||
MOVE_TRANSACTION_ID | NUMBER | Move transaction identifier | ||
COMPLETION_TRANSACTION_ID | NUMBER | Completion transaction identifier | ||
WIP_ENTITY_TYPE | NUMBER | WIP entity type code | ||
SCHEDULE_ID | NUMBER | WIP repetitive schedule identifier | ||
REPETITIVE_LINE_ID | NUMBER | Repetitive line identifier | ||
EMPLOYEE_CODE | VARCHAR2 | (10) | Employee code | |
PRIMARY_SWITCH | NUMBER | Primary assembly identifier | ||
SCHEDULE_UPDATE_CODE | NUMBER | Schedule update code | ||
SETUP_TEARDOWN_CODE | NUMBER | Setup teardown code | ||
ITEM_ORDERING | NUMBER | Item ordering | ||
NEGATIVE_REQ_FLAG | NUMBER | Negative requirement flag | ||
OPERATION_SEQ_NUM | NUMBER | Operation sequence number within a routing | ||
PICKING_LINE_ID | NUMBER | Picking line id | ||
TRX_SOURCE_LINE_ID | NUMBER | Line level transaction source identifier | ||
TRX_SOURCE_DELIVERY_ID | NUMBER | Delivery level transaction source identifier | ||
PHYSICAL_ADJUSTMENT_ID | NUMBER | Physical adjustment identifier | ||
CYCLE_COUNT_ID | NUMBER | Cycle count identifier | ||
RMA_LINE_ID | NUMBER | RMA line identifier | ||
CUSTOMER_SHIP_ID | NUMBER | Customer shipping identifier | ||
CURRENCY_CODE | VARCHAR2 | (10) | Currency code | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | USSGL transaction date | |
VENDOR_LOT_NUMBER | VARCHAR2 | (30) | Supplier lot number | |
ENCUMBRANCE_ACCOUNT | NUMBER | Encumbrance account identifier | ||
ENCUMBRANCE_AMOUNT | NUMBER | Encumbrance amount | ||
SHIP_TO_LOCATION | NUMBER | Ship to location identifier | ||
SHIPMENT_NUMBER | VARCHAR2 | (30) | Intransit shipment identifier | |
TRANSFER_COST | NUMBER | Transfer cost | ||
TRANSPORTATION_COST | NUMBER | Transportation cost | ||
TRANSPORTATION_ACCOUNT | NUMBER | Transportation account | ||
FREIGHT_CODE | VARCHAR2 | (30) | Freight identifier | |
CONTAINERS | NUMBER | Containers | ||
WAYBILL_AIRBILL | VARCHAR2 | (30) | Waybill / Airbill | |
EXPECTED_ARRIVAL_DATE | DATE | Expected arrival date | ||
TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | Opposing subinventory identifier in transfer transactions | |
TRANSFER_ORGANIZATION | NUMBER | Opposing organization identifier in transfer transactions | ||
TRANSFER_TO_LOCATION | NUMBER | Opposing locator identifier in transfer transactions | ||
NEW_AVERAGE_COST | NUMBER | New average cost used for average cost update | ||
VALUE_CHANGE | NUMBER | Value change used for average cost update | ||
PERCENTAGE_CHANGE | NUMBER | Percent change used for average cost update | ||
MATERIAL_ALLOCATION_TEMP_ID | NUMBER | Material allocation temporary identifier | ||
DEMAND_SOURCE_HEADER_ID | NUMBER | Demand source header identifier | ||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Demand source line identifier | |
DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | Demand source delivery | |
ITEM_SEGMENTS | VARCHAR2 | (240) | Inventory item segments | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory item description | |
ITEM_TRX_ENABLED_FLAG | VARCHAR2 | (1) | Inventory item transaction enabled flag | |
ITEM_LOCATION_CONTROL_CODE | NUMBER | Inventory item locator control code | ||
ITEM_RESTRICT_SUBINV_CODE | NUMBER | Inventory item restrict subinventory code | ||
ITEM_RESTRICT_LOCATORS_CODE | NUMBER | Inventory item restrict locators code | ||
ITEM_REVISION_QTY_CONTROL_CODE | NUMBER | Inventory item revision control code | ||
ITEM_PRIMARY_UOM_CODE | VARCHAR2 | (3) | Inventory item primary uom | |
ITEM_UOM_CLASS | VARCHAR2 | (10) | Inventory item uom class | |
ITEM_SHELF_LIFE_CODE | NUMBER | Inventory item shelf life code | ||
ITEM_SHELF_LIFE_DAYS | NUMBER | Inventory item shelf life days | ||
ITEM_LOT_CONTROL_CODE | NUMBER | Inventory item lot control code | ||
ITEM_SERIAL_CONTROL_CODE | NUMBER | Inventory item serial control code | ||
ITEM_INVENTORY_ASSET_FLAG | VARCHAR2 | (1) | Inventory item asset flag | |
ALLOWED_UNITS_LOOKUP_CODE | NUMBER | Inventory item uom conversions type | ||
DEPARTMENT_ID | NUMBER | Department identifier | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Department code | |
WIP_SUPPLY_TYPE | NUMBER | WIP supply type | ||
SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Supply subinventory | |
SUPPLY_LOCATOR_ID | NUMBER | Supply locator identifier | ||
VALID_SUBINVENTORY_FLAG | VARCHAR2 | (1) | Valid subinventory flag | |
VALID_LOCATOR_FLAG | VARCHAR2 | (1) | Valid locator flag | |
LOCATOR_SEGMENTS | VARCHAR2 | (240) | Locator segments | |
CURRENT_LOCATOR_CONTROL_CODE | NUMBER | Inventory item locator control code | ||
NUMBER_OF_LOTS_ENTERED | NUMBER | Total lot records entered | ||
WIP_COMMIT_FLAG | VARCHAR2 | (1) | WIP commit flag | |
NEXT_LOT_NUMBER | VARCHAR2 | (30) | Inventory item next lot number | |
LOT_ALPHA_PREFIX | VARCHAR2 | (30) | Inventory item lot prefix | |
NEXT_SERIAL_NUMBER | VARCHAR2 | (30) | Inventory item next valid serial number | |
SERIAL_ALPHA_PREFIX | VARCHAR2 | (30) | Inventory item serial prefix | |
SHIPPABLE_FLAG | VARCHAR2 | (1) | Inventory item shippable flag | |
POSTING_FLAG | VARCHAR2 | (1) | Posting flag | |
REQUIRED_FLAG | VARCHAR2 | (1) | Required flag | |
PROCESS_FLAG | VARCHAR2 | (1) | Row process flag used by Transaction Manager | |
ERROR_CODE | VARCHAR2 | (240) | Error code | |
ERROR_EXPLANATION | VARCHAR2 | (240) | Error explanation | |
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 | |
MOVEMENT_ID | NUMBER | Movement statistics cross reference | ||
RESERVATION_QUANTITY | NUMBER | Reservation quantity | ||
SHIPPED_QUANTITY | NUMBER | Shipped quantity | ||
TRANSACTION_LINE_NUMBER | NUMBER | Transaction line number | ||
TASK_ID | NUMBER | (15) | Task identifier | |
TO_TASK_ID | NUMBER | (15) | "To" task identifier | |
SOURCE_TASK_ID | NUMBER | Source task identifier | ||
PROJECT_ID | NUMBER | (15) | Project identifier | |
SOURCE_PROJECT_ID | NUMBER | Source project identifier | ||
PA_EXPENDITURE_ORG_ID | NUMBER | Oracle projects related expenditure organization identifier | ||
TO_PROJECT_ID | NUMBER | (15) | "To" project identifier | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Oracle projects related expenditure type | |
FINAL_COMPLETION_FLAG | VARCHAR2 | (1) | Indicates if job costs must be flushed out for this job completion | |
TRANSFER_PERCENTAGE | NUMBER | Percentage of value to attribute to transfer costs in an inter-org transfer | ||
TRANSACTION_SEQUENCE_ID | NUMBER | Transaction sequence identifie | ||
MATERIAL_ACCOUNT | NUMBER | Specifies the material account | ||
MATERIAL_OVERHEAD_ACCOUNT | NUMBER | Specifies the material overhead account | ||
RESOURCE_ACCOUNT | NUMBER | Specifies the resource account | ||
OUTSIDE_PROCESSING_ACCOUNT | NUMBER | Specifies the account to be charged for outside processing | ||
OVERHEAD_ACCOUNT | NUMBER | Specifies the overhead account | ||
FLOW_SCHEDULE | VARCHAR2 | (1) | Specifies whether the WIP transaction is a flow or schedule type transaction | |
COST_GROUP_ID | NUMBER | Cost group identifier | ||
DEMAND_CLASS | VARCHAR2 | (30) | The class to which the demand is tied | |
QA_COLLECTION_ID | NUMBER | Quality results identifier | ||
KANBAN_CARD_ID | NUMBER | Kanban card identifier | ||
OVERCOMPLETION_TRANSACTION_ID | NUMBER | Overcompletion transaction identifier | ||
OVERCOMPLETION_PRIMARY_QTY | NUMBER | Overcompletion primary quantity | ||
OVERCOMPLETION_TRANSACTION_QTY | NUMBER | Overcompletion transaction quantity | ||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (60) | End item unit number | |
SCHEDULED_PAYBACK_DATE | DATE | Standard Who column | ||
LINE_TYPE_CODE | NUMBER | Line type code | ||
PARENT_TRANSACTION_TEMP_ID | NUMBER | Parent transaction identifier | ||
PUT_AWAY_STRATEGY_ID | NUMBER | Put away strategy identifier | ||
PUT_AWAY_RULE_ID | NUMBER | Put away rule identifier | ||
PICK_STRATEGY_ID | NUMBER | Pick strategy identifier | ||
PICK_RULE_ID | NUMBER | Pick rule identifier | ||
COMMON_BOM_SEQ_ID | NUMBER | Bill identifier for the common BOM used | ||
COMMON_ROUTING_SEQ_ID | NUMBER | Routing identifier for the common routing used | ||
COST_TYPE_ID | NUMBER | Cost type | ||
ORG_COST_GROUP_ID | NUMBER | Organization's cost group identifier | ||
MOVE_ORDER_LINE_ID | NUMBER | Move order line identifier that this transaction line is tied to | ||
TASK_GROUP_ID | NUMBER | Task group identifier for this task | ||
PICK_SLIP_NUMBER | NUMBER | Pick slip number for the transaction line | ||
RESERVATION_ID | NUMBER | Reservation identifier | ||
TRANSACTION_STATUS | NUMBER | Indicates if the transaction has to be processed or just saved. NULL or 1 is default behavior. 2 is save only. 3 is ready to process | ||
FROM_SUBINV_LOC_TYPE | NUMBER | Locator type for source subinventory | ||
TO_SUBINV_LOC_TYPE | NUMBER | Locator type for the destination subinventory | ||
PICKLIST_LINE_ID | NUMBER | (35) | Y | Picklist line identifier |
PICKLIST_LINE_NUMBER | NUMBER | (35) | Y | Picklist line number |
PICKLIST_HEADER_ID | NUMBER | (35) | Y | Picklist header identifier |
PICK_UOM_CODE | VARCHAR2 | (3) | Y | Uom code used for the pick |
QUANTITY_PICKED | NUMBER | (35) | Y | Quantity picked |
STANDARD_OPERATION_ID | NUMBER | Standard operation identifier | ||
TASK_PRIORITY | NUMBER | Task priority | ||
WMS_TASK_TYPE | NUMBER | (for future use only) | ||
PARENT_LINE_ID | NUMBER | (for future use only) |
APPS.CSP_PICK_TRANSACTIONS_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 |
---|---|---|---|---|
USAGE_ID | NUMBER | (35) | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ORGANIZATION_ID | NUMBER | (35) | Y | |
HIERARCHY_NODE_ID | NUMBER | (35) | ||
PARTS_LOOP_ID | NUMBER | (35) | ||
PERIOD_TYPE | VARCHAR2 | (30) | Y | |
PERIOD_START_DATE | DATE | Y | ||
QUANTITY | NUMBER | (35) | Y | |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Y | |
TRANSACTION_TYPE_ID | NUMBER | (35) | ||
HISTORY_DATA_TYPE | VARCHAR2 | (240) | Y | |
USAGE_HEADER_ID | VARCHAR2 | (240) | ||
CREATED_BY | NUMBER | (35) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (35) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (35) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) |
APPS.CSP_PLANNING_DETAILS_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 |
---|---|---|---|---|
FUNC_CALL | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | ||
HEADER_DATA_TYPE | VARCHAR2 | (30) | ||
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
ACTUAL_COST | NUMBER | |||
RECOMMENDED_COST | NUMBER | |||
DELTA_COST | NUMBER |
APPS.CSP_PLANNING_DRILLDOWN_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 |
---|---|---|---|---|
USAGE_HEADER_ID | NUMBER | (35) | ||
HEADER_DATA_TYPE | VARCHAR2 | (30) | ||
PLANNING_PARAMETERS_ID | NUMBER | (35) | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
SECONDARY_INVENTORY | VARCHAR2 | (10) | ||
PROCESS_STATUS | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (240) | ||
PROCESS_STATUS_MEANING | VARCHAR2 | (80) | Y | |
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
RAW_AWU | NUMBER | |||
AWU | NUMBER | |||
FUNC_CALL | NUMBER | |||
SAFETY_FACTOR | NUMBER | |||
RECOMMENDED_MIN_QTY | NUMBER | |||
RECOMMENDED_MAX_QTY | NUMBER | |||
EDQ_FACTOR | NUMBER | |||
SERVICE_LEVEL | NUMBER | |||
ASL_FLAG | VARCHAR2 | (1) | ||
SAFETY_STOCK_FLAG | VARCHAR2 | (1) | ||
MIN_QUANTITY | NUMBER | |||
MAX_QUANTITY | NUMBER | |||
ACTUAL_COST | NUMBER | |||
RECOMMENDED_COST | NUMBER | |||
DELTA_COST | NUMBER | |||
DELTA_MIN | NUMBER | |||
DELTA_MAX | NUMBER | |||
DELTA_MIN_PERC | NUMBER | |||
DELTA_MAX_PERC | NUMBER | |||
CREATED_BY | NUMBER | (35) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (35) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (35) |
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 |
---|---|---|---|---|
FUNC_CALL | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ACTUAL_COST | NUMBER | |||
RECOMMENDED_COST | NUMBER | |||
DELTA_COST | NUMBER |
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) | ||
PLANNING_PARAMETERS_ID | NUMBER | (35) | Y | |
ORGANIZATION_TYPE | VARCHAR2 | (30) | ||
ORGANIZATION_ID | NUMBER | (35) | ||
FORECAST_RULE_ID | NUMBER | (35) | ||
FORECAST_RULE_NAME | VARCHAR2 | (240) | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | ||
SERVICE_LEVEL | NUMBER | |||
EDQ_FACTOR | NUMBER | |||
PLANNER_CODE | VARCHAR2 | (10) | ||
CONDITION_TYPE | VARCHAR2 | (30) | ||
CONDITION_TYPE_MEANING | VARCHAR2 | (80) | ||
ASL_FLAG | VARCHAR2 | (1) | ||
SAFETY_STOCK_FLAG | VARCHAR2 | (1) | ||
EXCESS_RULE_ID | NUMBER | (35) | ||
EXCESS_RULE_NAME | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | (35) | Y | |
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (35) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATE_LOGIN | NUMBER | (35) | ||
CATEGORY_SET_ID | NUMBER | (35) | ||
CATEGORY_ID | NUMBER | (35) | ||
RECOMMEND_METHOD | VARCHAR2 | (80) | ||
RECOMMEND_METHOD_MEANING | VARCHAR2 | (80) | ||
EDQ_MULTIPLE | NUMBER | (35) | ||
MINIMUM_VALUE | NUMBER | (35) | ||
USABLE_ASSIGNMENT_SET_ID | NUMBER | |||
DEFECTIVE_ASSIGNMENT_SET_ID | NUMBER | |||
REPAIR_ASSIGNMENT_SET_ID | NUMBER | Repair supplier assigned to a warehouse | ||
PRODUCT_NORM | VARCHAR2 | (150) | ||
NOTIFICATION_RULE_ID | NUMBER | (38) | ||
NOTIFICATION_RULE_NAME | VARCHAR2 | (240) | ||
RECOMMENDATION_RULE_ID | NUMBER | (38) | ||
RECOMMENDATION_RULE_NAME | VARCHAR2 | (240) | ||
DEFAULT_FORECAST_RULE_ID | VARCHAR2 | (200) | ||
DEFAULT_SERVICE_LEVEL | VARCHAR2 | (200) | ||
DEFAULT_EDQ_FACTOR | VARCHAR2 | (200) | ||
DEFAULT_PLANNER_CODE | VARCHAR2 | (200) | ||
DEFAULT_CONDITION_TYPE | VARCHAR2 | (200) | ||
DEFAULT_ASL_FLAG | VARCHAR2 | (200) | ||
DEFAULT_SAFETY_STOCK_FLAG | VARCHAR2 | (200) | ||
DEFAULT_EXCESS_RULE_ID | VARCHAR2 | (200) | ||
DEFAULT_CATEGORY_SET_ID | VARCHAR2 | (200) | ||
DEFAULT_CATEGORY_ID | VARCHAR2 | (200) | ||
DEFAULT_RECOMMEND_METHOD | VARCHAR2 | (200) | ||
DEFAULT_REC_RULE_ID | VARCHAR2 | (240) | ||
OVERRIDE_FORECAST_RULE_ID | VARCHAR2 | (5) | ||
OVERRIDE_SERVICE_LEVEL | VARCHAR2 | (5) | ||
OVERRIDE_EDQ_FACTOR | VARCHAR2 | (5) | ||
OVERRIDE_PLANNER_CODE | VARCHAR2 | (5) | ||
OVERRIDE_CONDITION_TYPE | VARCHAR2 | (5) | ||
OVERRIDE_ASL_FLAG | VARCHAR2 | (5) | ||
OVERRIDE_SAFETY_STOCK_FLAG | VARCHAR2 | (5) | ||
OVERRIDE_EXCESS_RULE_ID | VARCHAR2 | (5) | ||
OVERRIDE_CATEGORY_SET_ID | VARCHAR2 | (5) | ||
OVERRIDE_CATEGORY_ID | VARCHAR2 | (5) | ||
OVERRIDE_RECOMMEND_METHOD | VARCHAR2 | (5) | ||
OVERRIDE_REC_RULE_ID | VARCHAR2 | (10) | ||
NODE_TYPE | VARCHAR2 | (30) | ||
NODE_NAME | VARCHAR2 | (240) | ||
PARENT_NODE_ID | NUMBER | (35) | ||
LEVEL_ID | VARCHAR2 | (200) | Y | |
PRODUCT_NORM_NODE_ID | NUMBER | |||
DEFAULT_PRODUCT_NORM_NODE_ID | VARCHAR2 | (200) | ||
USAGE_WEIGHT1 | NUMBER | |||
USAGE_WEIGHT2 | NUMBER | |||
USAGE_WEIGHT3 | NUMBER | |||
USAGE_WEIGHT4 | NUMBER | |||
DEFAULT_USAGE_WEIGHT1 | VARCHAR2 | (200) | ||
DEFAULT_USAGE_WEIGHT2 | VARCHAR2 | (200) | ||
DEFAULT_USAGE_WEIGHT3 | VARCHAR2 | (200) | ||
DEFAULT_USAGE_WEIGHT4 | VARCHAR2 | (200) | ||
OVERRIDE_USAGE_WEIGHT1 | VARCHAR2 | (5) | ||
OVERRIDE_USAGE_WEIGHT2 | VARCHAR2 | (5) | ||
OVERRIDE_USAGE_WEIGHT3 | VARCHAR2 | (5) | ||
OVERRIDE_USAGE_WEIGHT4 | VARCHAR2 | (5) | ||
EXCESS_SERVICE_LEVEL | VARCHAR2 | (240) | Excess Service Level | |
REPAIR_SERVICE_LEVEL | VARCHAR2 | (240) | Repair Service Level | |
NEWBUY_SERVICE_LEVEL | VARCHAR2 | (240) | NewBuy Service Level | |
EXCESS_EDQ_FACTOR | VARCHAR2 | (240) | Excess EDQ Factor | |
REPAIR_EDQ_FACTOR | VARCHAR2 | (240) | Repair EDQ Factor | |
NEWBUY_EDQ_FACTOR | VARCHAR2 | (240) | NewBuy EDQ Factor | |
RESCHEDULE_RULE_ID | NUMBER | Reschedule Rule Identifier | ||
RESCHEDULE_RULE_NAME | VARCHAR2 | (240) | Reschedule Rule Name | |
WRP_RULE_ID | NUMBER | (38) | Order Automation Rule Identifier | |
WRP_RULE_NAME | VARCHAR2 | (240) | Order Automation Rule Name | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
STOCKING_SITE_TYPE | VARCHAR2 | (30) | ||
STOCKING_SITE_TYPE_MEANING | VARCHAR2 | (80) | ||
CALENDAR_ID | NUMBER | (38) | ||
CALENDAR_NAME | VARCHAR2 | (50) | ||
TIMEZONE_ID | NUMBER | (38) | ||
TIMEZONE_NAME | VARCHAR2 | (80) | ||
MANAGED_BY | VARCHAR2 | (30) | ||
MANAGED_BY_MEANING | VARCHAR2 | (80) | ||
CONTACT_NAME | VARCHAR2 | (150) | ||
CONTACT_PHONE | VARCHAR2 | (30) | ||
AH_CONTACT_NAME | VARCHAR2 | (150) | ||
AH_CONTACT_PHONE | VARCHAR2 | (30) | ||
STOCKING_SITE_EXCL | VARCHAR2 | (3) | ||
AUTORECEIPT_FLAG | VARCHAR2 | (30) | ||
SPECIAL_INSTRUCTIONS | VARCHAR2 | (1996) | ||
HZ_LOCATION_ID | NUMBER | (38) |
APPS.CSP_PLANNING_PARAMETERS_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 |
---|---|---|---|---|
USAGE_HEADER_ID | NUMBER | (35) | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | ||
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
MIN_QUANTITY | NUMBER | |||
MAX_QUANTITY | NUMBER |
APPS.CSP_PLANNING_SUBINV_HDR_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 |
---|---|---|---|---|
FUNC_CALL | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ACTUAL_COST | NUMBER | |||
RECOMMENDED_COST | NUMBER | |||
DELTA_COST | NUMBER |
APPS.CSP_PLANNING_TOPNODE_HDR_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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (30) | Y | Box Name |
NODE_TYPE | VARCHAR2 | (240) | Y | Box node |
NODE_KEY | NUMBER | (35) | Y | Box identifier |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (9) | Pack List Node | |
PARENT_NODE_KEY | NUMBER | (35) | Y | Pack List Header identifier |
APPS.CSP_PLIST_BOXES_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (83) | Combination of Item Quantity and Item Name | |
NODE_TYPE | VARCHAR2 | (240) | Y | Packlist Items |
NODE_KEY | NUMBER | (35) | Y | Combination of Inventory Item identifier, Box identifier and Packlist Line identifier |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (9) | Box Node | |
PARENT_NODE_KEY | NUMBER | (35) | Y | Box Node identifier |
APPS.CSP_PLIST_BOXITEMS_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (481) | Serial Number/Lot Number | |
NODE_TYPE | VARCHAR2 | (240) | Y | Packlist Serial/Lot |
NODE_KEY | NUMBER | (35) | Y | Packlist Serial/Lot Identifier |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (11) | Packlist items | |
PARENT_NODE_KEY | NUMBER | (35) | Y | Combination of Inventory Item identifier and Box identifier |
APPS.CSP_PLIST_ITMSLNO_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (80) | Y | Status Description |
NODE_TYPE | VARCHAR2 | (240) | Y | Packlist Status |
NODE_KEY | VARCHAR2 | (30) | Y | Packlist Status Identifier |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (4) | Root Node | |
PARENT_NODE_KEY | VARCHAR2 | (240) | Y | Root Node Name |
APPS.CSP_PLIST_STATUS_NAV 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 |
---|---|---|---|---|
FUNC_CALL | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | (35) | ||
ORGANIZATION_ID | NUMBER | (35) | ||
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
ACTUAL_COST | NUMBER | |||
RECOMMENDED_COST | NUMBER | |||
DELTA_COST | NUMBER |
APPS.CSP_PLN_DRILLDOWN_ORG_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 |
---|---|---|---|---|
FUNC_CALL | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | ||
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ACTUAL_COST | NUMBER | |||
RECOMMENDED_COST | NUMBER | |||
DELTA_COST | NUMBER |
APPS.CSP_PLN_DRILLDOWN_SUBINV_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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | (35) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) |
APPS.CSP_PLN_DRILLDOWN_SUBINV_WH_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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (240) | Y | |
NODE_TYPE | VARCHAR2 | (240) | Y | |
NODE_KEY | NUMBER | Y | ||
ICON_NAME | VARCHAR2 | (30) | ||
LEAF_FLAG | CHAR | (1) | ||
PARENT_NODE_TYPE | CHAR | (4) | ||
PARENT_NODE_KEY | VARCHAR2 | (240) | Y |
APPS.CSP_PLN_ORG_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (50) | ||
NODE_TYPE | VARCHAR2 | (240) | Y | |
NODE_KEY | NUMBER | (35) | Y | |
ICON_NAME | VARCHAR2 | (30) | ||
LEAF_FLAG | CHAR | (1) | ||
PARENT_NODE_TYPE | CHAR | (4) | ||
PARENT_NODE_KEY | VARCHAR2 | (240) | Y |
APPS.CSP_PLN_REGIONS_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (240) | ||
NODE_TYPE | VARCHAR2 | (12) | ||
NODE_KEY | VARCHAR2 | (40) | ||
ICON_NAME | VARCHAR2 | (30) | ||
LEAF_FLAG | VARCHAR2 | (1) | ||
PARENT_NODE_TYPE | CHAR | (6) | ||
PARENT_NODE_KEY | NUMBER | (35) |
APPS.CSP_PLN_REGION_ORG_NAV 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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (14) | ||
NODE_TYPE | CHAR | (12) | ||
NODE_KEY | NUMBER | (35) | Y | |
ICON_NAME | VARCHAR2 | (8) | ||
LEAF_FLAG | CHAR | (1) | ||
PARENT_NODE_TYPE | CHAR | (12) | ||
PARENT_NODE_KEY | NUMBER | (35) |
APPS.CSP_PLN_SUBINV_NAV 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 |
---|---|---|---|---|
PRODUCT_ID | NUMBER | (38) | Y | |
CURRENT_POPULATION | NUMBER | (38) | ||
POPULATION_CHANGE | NUMBER | (38) | ||
INVENTORY_ITEM_ID | NUMBER | (38) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | ||
CALCULATED_FAILURE_RATE | NUMBER | |||
MANUAL_FAILURE_RATE | NUMBER | |||
PLANNING_PARAMETERS_ID | NUMBER | (35) | Y | |
NODE_TYPE | VARCHAR2 | (30) | ||
LEVEL_ID | VARCHAR2 | (200) | Y |
APPS.CSP_PRODUCT_POPULATIONS_FR_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 |
---|---|---|---|---|
PRODUCT_POPULATION_ID | NUMBER | (38) | Y | |
PLANNING_PARAMETERS_ID | NUMBER | (38) | Y | |
PRODUCT_ID | NUMBER | (38) | Y | |
CURRENT_POPULATION | NUMBER | (38) | ||
POPULATION_CHANGE | NUMBER | (38) | ||
LAST_UPDATE_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | (38) | Y | |
CREATION_DATE | DATE | Y | ||
CREATED_BY | NUMBER | (38) | Y | |
LAST_UPDATE_LOGIN | NUMBER | (38) | ||
SECURITY_GROUP_ID | NUMBER | (38) |
APPS.CSP_PRODUCT_POPULATIONS_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 |
---|---|---|---|---|
PRODUCT_TASK_ID | NUMBER | (35) | Y | Product task unique identifier |
PRODUCT_ID | NUMBER | (35) | Y | Product Identifier |
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Item Number | |
ORGANIZATION_ID | NUMBER | Y | Organization Identifier | |
TASK_TEMPLATE_ID | NUMBER | (35) | Y | Task Template Identifier |
AUTO_MANUAL | VARCHAR2 | (30) | Y | Manual or Generated M/A |
ACTUAL_TIMES_USED | NUMBER | (35) | Actual number of times the task is used for the product | |
TASK_PERCENTAGE | NUMBER | (35) | Task percentage for the product | |
TASK_NAME | VARCHAR2 | (80) | Y | Task Name |
DESCRIPTION | VARCHAR2 | (4000) | Task Description | |
MEANING | VARCHAR2 | (80) | Y | Description for Manual or Generated |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column |
APPS.CSP_PRODUCT_TASKS_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 | |
PACKLIST_HEADER_ID | NUMBER | (35) | Y | Packlist header identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PACKLIST_NUMBER | VARCHAR2 | (10) | Y | Packlist number |
PACKLIST_STATUS | VARCHAR2 | (30) | Y | Packlist status |
PACKLIST_LINE_ID | NUMBER | (35) | Y | Packlist line identifier |
PACKLIST_LINE_NUMBER | NUMBER | (35) | Y | Packlist line number |
BOX_ID | NUMBER | (35) | Y | Box identifier |
QUANTITY_SHIPPED | NUMBER | (35) | Quantity shipped | |
QUANTITY_DUE | NUMBER | Quantity received | ||
QUANTITY_RECEIVED | NUMBER | (35) | Quantity received | |
UOM_CODE | VARCHAR2 | (3) | Y | Unit of measure |
BOX_NAME | VARCHAR2 | (30) | Y | Box name |
LINE_ID | NUMBER | Y | Move order line identifier | |
LINE_NUMBER | NUMBER | Y | Move order line number | |
INVENTORY_ITEM_ID | NUMBER | Y | Inventory item identifier | |
ITEM | VARCHAR2 | (40) | Item number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
REVISION | VARCHAR2 | (3) | Item revision | |
FROM_SUBINVENTORY_CODE | VARCHAR2 | (10) | Source subinventory name | |
FROM_LOCATOR_ID | NUMBER | Source locator identifier | ||
FROM_LOCATOR | CHAR | (1) | Concatenated source locator segments | |
TRANSFER_SUBINVENTORY | VARCHAR2 | (10) | Destination subinventory | |
TRANSFER_TO_LOCATION | NUMBER | Destination locator identifier | ||
TO_LOCATOR | CHAR | (1) | Concatenated destination locator segments | |
HEADER_ID | NUMBER | Y | Move order header identifier | |
REQUEST_NUMBER | VARCHAR2 | (30) | Y | Mover order request number |
TRANSACTION_TEMP_ID | NUMBER | Temporary transaction identifier | ||
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
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 |
---|---|---|---|---|
PLANNING_PARAMETERS_ID | NUMBER | (38) | ||
INVENTORY_ITEM_ID | NUMBER | (38) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | ||
LEVEL_ID | VARCHAR2 | (1996) |
APPS.CSP_REGION_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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | (38) | Y | |
PLANNING_PARAMETERS_ID | NUMBER | (35) | Y | |
PERIOD_START_DATE | DATE | |||
QUANTITY | NUMBER |
APPS.CSP_REG_USAGE_DETAILS_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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (30) | Y | Reporting Hierarchy Name |
NODE_TYPE | VARCHAR2 | (240) | Y | Reporting Hierarchy |
NODE_KEY | NUMBER | (35) | Y | Reporting Hierarchy Identifier |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (4) | Root Node | |
PARENT_NODE_KEY | VARCHAR2 | (240) | Y | Root Node Name |
APPS.CSP_REP_HIERARCHIES_NAV 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 | |
HIERARCHY_NODE_ID | NUMBER | (35) | Y | Hierarchy node identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
NODE_TYPE | VARCHAR2 | (30) | Y | Node type |
NODE_NAME | VARCHAR2 | (30) | Y | Node name |
TOP_NODE_ID | NUMBER | (35) | Y | Top node identifier |
PARENT_NODE_ID | NUMBER | (35) | Parent node identifier | |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_REP_HIERARCHIES_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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (30) | Subinventory Name | |
NODE_TYPE | VARCHAR2 | (240) | Subinventory Node | |
NODE_KEY | NUMBER | (35) | Subinventory Identifier | |
ICON_NAME | VARCHAR2 | (30) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or not | |
PARENT_NODE_TYPE | VARCHAR2 | (240) | Reporting Hierarchy Node | |
PARENT_NODE_KEY | NUMBER | (35) | Reporting Hierarchy identifier |
APPS.CSP_REP_HIER_SECINV_NAV is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
View which gives you the complete status of spare part requirements
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUIREMENT_NUMBER | NUMBER | (35) | Requirement Number | |
REQUIREMENT_LINE_ID | NUMBER | (35) | Requirement Line Identifier | |
REQ_LINE_DETAIL_ID | NUMBER | Requirement line detail identifier | ||
SOURCED_FROM | VARCHAR2 | (80) | The requirement will be sourced from this source type | |
PO_REQUISITION_LINE_ID | NUMBER | Purchase order requisition line id | ||
PO_REQUISITION_HEADER_ID | NUMBER | Purchase requisition header id | ||
PO_REQUISITION_NUMBER | VARCHAR2 | (20) | Purchase requisition number | |
PO_LINE_LOCATION_ID | NUMBER | Purchase order line location id | ||
ORDER_HEADER_ID | NUMBER | Order Header Identifier | ||
ORDER_LINE_ID | NUMBER | Order Line Identifier | ||
ORDER_NUMBER | NUMBER | Order Number | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Inventory Item Identifier | |
ITEM_NUMBER | VARCHAR2 | (40) | Item Number | |
CATEGORY | VARCHAR2 | (80) | Category | |
STATUS | VARCHAR2 | (4000) | Status | |
STATUS_MEANING | VARCHAR2 | (4000) | Status Meaning | |
ITEM_SUPPLIED | VARCHAR2 | (40) | Item supplied | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
SOURCE_ORGANIZATION_ID | NUMBER | Source Organization Identifier | ||
SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | Source Organization Code | |
DESTINATION_ORGANIZATION_ID | NUMBER | (35) | Destination Organization Identifier | |
DESTINATION_ORGANIZATION_CODE | VARCHAR2 | (3) | Destination Organization Code | |
SHIP_TO_LOCATION_ID | NUMBER | (35) | Ship To Location Identifier | |
FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Freight Carrier Code | |
FREIGHT_CARRIER | VARCHAR2 | (80) | Freight Carrier | |
REQUIRED_QUANTITY | NUMBER | Required Quantity | ||
ORDERED_QUANTITY | NUMBER | Ordered Quantity | ||
ORDER_QUANTITY_UOM | VARCHAR2 | (3) | Order Quantity Unit Of Measure | |
FULFILLED_QUANTITY | NUMBER | Fulfilled Quantity | ||
SHIPPING_QUANTITY | NUMBER | Shipping Quantity | ||
SHIPPING_QUANTITY_UOM | VARCHAR2 | (3) | Shipping Quantity Unit Of Measure | |
SHIPPED_QUANTITY | NUMBER | Shipped Quantity | ||
RECEIVED_QUANTITY | NUMBER | Received Quantity | ||
RECEIVED_QUANTITY_UOM | VARCHAR2 | (4000) | Received Quantity Unit Of Measurre | |
CANCELLED_QUANTITY | NUMBER | Cancelled Quantity | ||
DELIVERY_NUMBER | VARCHAR2 | (4000) | Delivery number | |
WAYBILL_NUM | VARCHAR2 | (4000) | Waybill Number | |
NEED_BY_DATE | DATE | Need By Date | ||
ORDER_BY_DATE | DATE | Order By Date | ||
REQUEST_DATE | DATE | Request Date | ||
PROMISE_DATE | DATE | Promise Date | ||
SCHEDULE_SHIP_DATE | DATE | Schedule Ship Date | ||
ACTUAL_SHIPMENT_DATE | DATE | Actual Shipment Date | ||
SCHEDULE_ARRIVAL_DATE | DATE | Schedule Arrival Date | ||
ACTUAL_ARRIVAL_DATE | DATE | Actual Arrival Date | ||
SERVICE_REQUEST | VARCHAR2 | (80) | Service Request | |
INCIDENT_ID | NUMBER | Incident Identifier | ||
TASK_ID | NUMBER | (35) | Task Identifier | |
TASK_NUMBER | VARCHAR2 | (30) | Task Number | |
TASK_ASSIGNMENT_ID | NUMBER | (35) | Task Assignment Identifier | |
RESOURCE_TYPE | VARCHAR2 | (240) | Resource Type | |
RESOURCE_TYPE_MEANING | VARCHAR2 | (30) | Resource Type Meaning | |
RESOURCE_ID | NUMBER | Resource Identifier | ||
RESOURCE_NAME | VARCHAR2 | (4000) | Resource Name | |
ADDRESS_TYPE | VARCHAR2 | (30) | Address type |
APPS.CSP_REQUIRED_PARTS_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 |
---|---|---|---|---|
REQUIREMENT_HEADER_ID | NUMBER | (35) | Y | Requirement Header Identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who column |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
OPEN_REQUIREMENT | VARCHAR2 | (240) | Flag to specify if the requirement is open or closed | |
ADDRESS_TYPE | VARCHAR2 | (30) | Address Type, Valid values are R-Resource, C-Customer, S-Special Address | |
SHIP_TO_LOCATION_ID | NUMBER | (35) | Ship to Location Identifier | |
SERVICE_REQUEST | VARCHAR2 | (80) | Service Request | |
INCIDENT_ID | NUMBER | |||
TASK_ID | NUMBER | (35) | Task Identifier | |
TASK_NUMBER | VARCHAR2 | (30) | Task number | |
TASK_ASSIGNMENT_ID | NUMBER | (35) | Task Assignment Identifier | |
RESOURCE_TYPE_CODE | VARCHAR2 | (240) | Resource Type Code | |
RESOURCE_ID | NUMBER | Resource Identifier | ||
NEED_BY_DATE | DATE | Need by date | ||
DESTINATION_ORGANIZATION_ID | NUMBER | (35) | Destination Organization Identifier | |
DESTINATION_ORGANIZATION | VARCHAR2 | (3) | Destination Organization name | |
DESTINATION_SUBINVENTORY | VARCHAR2 | (30) | Destination subinventory | |
PARTS_DEFINED | VARCHAR2 | (30) | Flag to specify if required parts are already defined or not | |
ORDER_TYPE_ID | NUMBER | (35) | Order Type Identifier | |
ORDER_TYPE_NAME | VARCHAR2 | (30) | Order Type Name | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_REQUIREMENT_HEADERS_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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | (35) | ||
INVENTORY_ITEM | VARCHAR2 | (40) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
ITEM_SCRATCHPAD | VARCHAR2 | (1996) | ||
UOM_CODE | VARCHAR2 | (3) | ||
REVISION | VARCHAR2 | (3) | ||
REQUIRED_QUANTITY | NUMBER | |||
SUPPLIED_ITEM_ID | NUMBER | |||
SUPPLIED_ITEM | VARCHAR2 | (40) | ||
SUPPLIED_ITEM_DESC | VARCHAR2 | (240) | ||
SUPPLIED_QUANTITY | NUMBER | |||
SHIP_COMPLETE_FLAG | VARCHAR2 | (3) | ||
SOURCED_FROM | VARCHAR2 | (30) | ||
SOURCED_FROM_DISP | VARCHAR2 | (80) | ||
SOURCE_ID | NUMBER | |||
SOURCE_NUMBER | VARCHAR2 | (40) | ||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORGANIZATION | VARCHAR2 | (3) | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
ARRIVAL_DATE | DATE | |||
SHIPPING_METHOD_CODE | VARCHAR2 | (30) | ||
LIKELIHOOD | NUMBER | (35) | ||
STATUS_CODE | VARCHAR2 | (4000) | ||
REQ_STATUS | VARCHAR2 | (4000) | ||
CREATED_BY | NUMBER | (35) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (35) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (35) | ||
REQUIREMENT_HEADER_ID | NUMBER | (35) | ||
REQUIREMENT_LINE_ID | NUMBER | (35) | ||
REQ_LINE_DETAIL_ID | NUMBER | (38) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
WAYBILL_NUMBER | VARCHAR2 | (4000) | ||
FREIGHT_CODE | VARCHAR2 | (30) | ||
SHIP_DATE | DATE | |||
SHIPPING_METHOD_MEANING | VARCHAR2 | (80) |
APPS.CSP_REQ_LINE_DETAILS_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
The view is used to retrieve the Part In or Part Out subinventories assigned to a Resource in a loop. The Where clause must specify whether the view should return Part In default subinventory or the Part Out default subinventory.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | (35) | Y | Resource identifier |
RESOURCE_TYPE | VARCHAR2 | (30) | Y | Resource type |
SUBINVENOTRY_CODE | VARCHAR2 | (10) | Y | Subinventory name |
DEFAULT_CODE | VARCHAR2 | (30) | Default code | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
EFFECTIVE_DATE_START | DATE | Effective from this date | ||
EFFECTIVE_DATE_END | DATE | Effective through this date |
APPS.CSP_RESOURCE_DEFAULT_INV_LOC_V is not referenced by any database object
A public view which may be useful for custom reporting or other data requirements.
The view is used to view all the move orders and their statuses for a given Service Request and/or Task Id.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ID | NUMBER | (35) | Y | Resource identifier |
RESOURCE_TYPE | VARCHAR2 | (30) | Y | Resrouce type |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Y | Subinventory name |
INV_LOC_TYPE | VARCHAR2 | (30) | Y | Condition type of subinventory |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
EFFECTIVE_DATE_START | DATE | Effective from this date | ||
EFFECTIVE_DATE_END | DATE | Effective through this date |
APPS.CSP_RESOURCE_INV_LOC_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 |
---|---|---|---|---|
RS_CUST_RELATION_ID | NUMBER | (35) | Y | Resource customer relation unique identifier |
RESOURCE_TYPE | VARCHAR2 | (30) | Y | Resource type |
RESOURCE_TYPE_MEANING | VARCHAR2 | (30) | Y | Resource type meaning |
RESOURCE_ID | NUMBER | (35) | Y | Resource identifier |
RESOURCE_NAME | VARCHAR2 | (4000) | Resource name | |
CUSTOMER_ID | NUMBER | (35) | Customer identifier | |
DEFAULT_TRIP_START | NUMBER | (38) | Start address for the trip. | |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_RS_RESOURCES_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 |
---|---|---|---|---|
RESOURCE_TYPE | VARCHAR2 | (30) | Y | Resource type |
RESOURCE_ID | NUMBER | (35) | Y | Resource identifier |
CUSTOMER_ID | NUMBER | (35) | Customer identifier | |
CUST_ACCT_SITE_ID | NUMBER | (15) | Y | Customer account site identifier |
PARTY_SITE_ID | NUMBER | (15) | Y | Party site identifier |
SITE_USE_ID | NUMBER | (15) | Site use identifier | |
SITE_USE_CODE | VARCHAR2 | (30) | Site use code | |
PRIMARY_FLAG | VARCHAR2 | (1) | Primary address flag | |
STATUS | VARCHAR2 | (1) | Status (A - Active I-Inactive) | |
INV_LOC_ID | NUMBER | Y | Inventory location identifier | |
ENTERED_BY | NUMBER | (15) | Y | Entered by |
ROW_ID | ROWID | (10) | Row identifier | |
LOCATION_CODE | VARCHAR2 | (60) | Y | Location code |
DESCRIPTION | VARCHAR2 | (240) | Description | |
STYLE | VARCHAR2 | (7) | Address style code | |
ADDRESS_STYLE | VARCHAR2 | (80) | Address style | |
ADDRESS_LINE_1 | VARCHAR2 | (240) | Address line 1 | |
ADDRESS_LINE_2 | VARCHAR2 | (240) | Address line 2 | |
ADDRESS_LINE_3 | VARCHAR2 | (240) | Address line 3 | |
TOWN_OR_CITY | VARCHAR2 | (30) | Town or city | |
COUNTRY | VARCHAR2 | (60) | Country | |
POSTAL_CODE | VARCHAR2 | (30) | Postal code | |
REGION_1 | VARCHAR2 | (120) | Region 1 | |
REGION_2 | VARCHAR2 | (120) | Region 2 | |
REGION_3 | VARCHAR2 | (120) | Region 3 | |
BILL_TO_SITE_FLAG | VARCHAR2 | (30) | Bill to site flag | |
DESIGNATED_RECEIVER_ID | NUMBER | (15) | Designated receiver identifier | |
IN_ORGANIZATION_FLAG | VARCHAR2 | (30) | In organization flag | |
INACTIVE_DATE | DATE | Inactive date | ||
INVENTORY_ORGANIZATION_ID | NUMBER | (15) | Inventory organization identifier | |
OFFICE_SITE_FLAG | VARCHAR2 | (30) | Office site flag | |
RECEIVING_SITE_FLAG | VARCHAR2 | (30) | Receiving site flag | |
SHIP_TO_LOCATION_ID | NUMBER | (15) | Ship to location identifier | |
SHIP_TO_LOCATION | VARCHAR2 | (60) | Ship to location | |
SHIP_TO_SITE_FLAG | VARCHAR2 | (30) | Ship to site flag | |
TAX_NAME | VARCHAR2 | (15) | Tax name | |
TELEPHONE_NUMBER_1 | VARCHAR2 | (60) | Telephone number 1 | |
TELEPHONE_NUMBER_2 | VARCHAR2 | (60) | Telephone number 2 | |
TELEPHONE_NUMBER_3 | VARCHAR2 | (60) | Telephone number 3 | |
LOC_INFORMATION13 | VARCHAR2 | (150) | Location information 13 | |
LOC_INFORMATION14 | VARCHAR2 | (150) | Location information 14 | |
LOC_INFORMATION15 | VARCHAR2 | (150) | Location information 15 | |
LOC_INFORMATION16 | VARCHAR2 | (150) | Location information 16 | |
LOC_INFORMATION17 | VARCHAR2 | (150) | Location information 17 | |
LOC_INFORMATION18 | VARCHAR2 | (150) | Location information 18 | |
LOC_INFORMATION19 | VARCHAR2 | (150) | Location information 19 | |
LOC_INFORMATION20 | VARCHAR2 | (150) | Location information 20 | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column - with the user id from FND_USER | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Standard Who Column - with the user id from FND_USER | |
CREATION_DATE | DATE | Standard Who Column | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object version number | |
TP_HEADER_ID | NUMBER | TP header identifier | ||
ECE_TP_LOCATION_CODE | VARCHAR2 | (35) | ECE TP location code | |
SITE_LOC_ID | NUMBER | (15) | Y | Site location identifier |
TIMEZONE_ID | VARCHAR2 | (50) | Timezone identifier | |
TIMEZONE_NAME | VARCHAR2 | (80) | Timezone name | |
GLOBAL_TIMEZONE_NAME | VARCHAR2 | (50) | Global timezone name | |
ATTRIBUTE1 | VARCHAR2 | (150) | Attribute1 for HR_LOCATIONS flex field | |
ATTRIBUTE2 | VARCHAR2 | (150) | Attribute2 for HR_LOCATIONS flex field | |
ATTRIBUTE3 | VARCHAR2 | (150) | Attribute3 for HR_LOCATIONS flex field | |
ATTRIBUTE4 | VARCHAR2 | (150) | Attribute4 for HR_LOCATIONS flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Attribute5 for HR_LOCATIONS flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Attribute6 for HR_LOCATIONS flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Attribute7 for HR_LOCATIONS flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Attribute8 for HR_LOCATIONS flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Attribute9 for HR_LOCATIONS flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Attribute10 for HR_LOCATIONS flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Attribute11 for HR_LOCATIONS flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Attribute12 for HR_LOCATIONS flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Attribute13 for HR_LOCATIONS flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Attribute14 for HR_LOCATIONS flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Attribute15 for HR_LOCATIONS flexfield | |
ATTRIBUTE16 | VARCHAR2 | (150) | Attribute16 for HR_LOCATIONS flexfield | |
ATTRIBUTE17 | VARCHAR2 | (150) | Attribute17 for HR_LOCATIONS flexfield | |
ATTRIBUTE18 | VARCHAR2 | (150) | Attribute18 for HR_LOCATIONS flexfield | |
ATTRIBUTE19 | VARCHAR2 | (150) | Attribute19 for HR_LOCATIONS flexfield | |
ATTRIBUTE20 | VARCHAR2 | (150) | Attribute20 for HR_LOCATIONS flexfield | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute category |
APPS.CSP_RS_SHIP_TO_ADDRESSES_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 |
---|---|---|---|---|
CSP_INV_LOC_ASSIGNMENT_ID | NUMBER | (35) | Y | Inventory location assignment identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
RESOURCE_TYPE | VARCHAR2 | (30) | Y | Resource type |
RESOURCE_ID | NUMBER | (35) | Y | Resource identifier |
RESOURCE_NAME | VARCHAR2 | (4000) | Resource name | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Y | Subinventory name |
SECONDARY_INVENTORY_ID | NUMBER | (35) | Secondary inventory identifier | |
LOCATION_ID | NUMBER | (35) | Location identifier | |
LOCATOR_ID | NUMBER | (35) | Locator identifier | |
CONDITION_TYPE | VARCHAR2 | (30) | Condition type | |
CONDITION_TYPE_MEANING | VARCHAR2 | (80) | Condition type meaning | |
DEFAULT_FLAG | VARCHAR2 | (1) | Default flag | |
DEFAULT_CODE | VARCHAR2 | (30) | Default code | |
DEFAULT_CODE_MEANING | VARCHAR2 | (80) | Default code meaning | |
EFFECTIVE_DATE_START | DATE | Effective start date | ||
EFFECTIVE_DATE_END | DATE | Effective end date | ||
OWNER_FLAG | VARCHAR2 | (1) | Owner flag | |
GROUP_NAME | VARCHAR2 | (60) | Group Name | |
GROUP_ID | NUMBER | (35) | Group Id | |
OWNER_RESOURCE_TYPE | VARCHAR2 | (30) | Owner resource type | |
OWNER_RESOURCE_ID | NUMBER | (35) | Owner resource identifier | |
OWNER_RESOURCE_NAME | VARCHAR2 | (4000) | Owner resource name | |
RETURN_ORGANIZATION_ID | NUMBER | (35) | Return organizationidentifier | |
RETURN_ORGANIZATION_CODE | VARCHAR2 | (3) | Return organization code | |
RETURN_SUBINVENTORY_NAME | VARCHAR2 | (10) | Return subinventory name | |
RETURN_CONDITION_TYPE | VARCHAR2 | (30) | Return condition type | |
RETURN_CONDITION_TYPE_MEANING | VARCHAR2 | (80) | Return condition type meaning |
APPS.CSP_RS_SUBINVENTORIES_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 |
---|---|---|---|---|
LABEL | VARCHAR2 | (14) | Subinventory Name | |
NODE_TYPE | VARCHAR2 | (240) | Y | Subinventory |
NODE_KEY | NUMBER | (35) | Y | Subinventory Identifier |
ICON_NAME | VARCHAR2 | (8) | Icon Name | |
LEAF_FLAG | CHAR | (1) | Leaf flag or Not | |
PARENT_NODE_TYPE | CHAR | (11) | Node type of parent | |
PARENT_NODE_KEY | NUMBER | (35) | Node key for parent |
APPS.CSP_SEC_INVENTORIES_NAV 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 | |
SECONDARY_INVENTORY_ID | NUMBER | (35) | Y | Subinventory identifier |
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
HIERARCHY_NODE_ID | NUMBER | (35) | Hierarchy node identifier | |
LOCATION_ID | NUMBER | (15) | Location identifier | |
CONDITION_TYPE | VARCHAR2 | (30) | Y | Subinventory condition type |
AUTORECEIPT_FLAG | VARCHAR2 | (30) | Y | Autoreceipt flag |
SPARES_LOCATION_FLAG | VARCHAR2 | (30) | Y | Spares location flag |
LOCATION_CODE | VARCHAR2 | (60) | Location Code | |
STYLE | VARCHAR2 | (7) | Address style | |
ADDRESS_LINE_1 | VARCHAR2 | (240) | Address Line 1 | |
ADDRESS_LINE_2 | VARCHAR2 | (240) | Address Line 2 | |
ADDRESS_LINE_3 | VARCHAR2 | (240) | Address Line 3 | |
COUNTRY | VARCHAR2 | (60) | Country | |
LOC_INFORMATION13 | VARCHAR2 | (150) | ||
LOC_INFORMATION14 | VARCHAR2 | (150) | ||
LOC_INFORMATION15 | VARCHAR2 | (150) | ||
LOC_INFORMATION16 | VARCHAR2 | (150) | ||
LOC_INFORMATION17 | VARCHAR2 | (150) | ||
LOC_INFORMATION18 | VARCHAR2 | (150) | ||
LOC_INFORMATION19 | VARCHAR2 | (150) | ||
LOC_INFORMATION20 | VARCHAR2 | (150) | ||
POSTAL_CODE | VARCHAR2 | (30) | Postal code | |
REGION_1 | VARCHAR2 | (120) | ||
REGION_2 | VARCHAR2 | (120) | ||
REGION_3 | VARCHAR2 | (120) | ||
TELEPHONE_NUMBER_1 | VARCHAR2 | (60) | ||
TELEPHONE_NUMBER_2 | VARCHAR2 | (60) | ||
TELEPHONE_NUMBER_3 | VARCHAR2 | (60) | ||
TOWN_OR_CITY | VARCHAR2 | (30) | City | |
BILL_TO_SITE_FLAG | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
DESIGNATED_RECEIVER_ID | NUMBER | (15) | ||
ECE_TP_LOCATION_CODE | VARCHAR2 | (35) | ||
INACTIVE_DATE | DATE | |||
ENTERED_BY | NUMBER | (15) | ||
INVENTORY_ORGANIZATION_ID | NUMBER | (15) | ||
IN_ORGANIZATION_FLAG | VARCHAR2 | (30) | ||
OFFICE_SITE_FLAG | VARCHAR2 | (30) | ||
RECEIVING_SITE_FLAG | VARCHAR2 | (30) | ||
SHIP_TO_LOCATION_ID | NUMBER | (15) | ||
SHIP_TO_SITE_FLAG | VARCHAR2 | (30) | ||
TAX_NAME | VARCHAR2 | (15) | ||
TP_HEADER_ID | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | escriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECONDARY_INVENTORY_NAME | VARCHAR2 | (10) | Y | Subinventory name |
MEANING | VARCHAR2 | (80) | Y | Subinventory condition type |
RETURN_ORGANIZATION_ID | NUMBER | (35) | Organization identifier for spare parts return | |
RETURN_SUBINVENTORY_NAME | VARCHAR2 | (10) | Subinventory name for spare parts return | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | Organization name |
ORGANIZATION_CODE | VARCHAR2 | (3) | Organization code | |
OWNER_RESOURCE_TYPE | VARCHAR2 | (30) | ||
OWNER_RESOURCE_ID | NUMBER | (35) | ||
TERRITORY_SHORT_NAME | VARCHAR2 | (80) | Territory short name |
APPS.CSP_SEC_INVENTORIES_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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | (35) | Y | |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Y | |
PERIOD_START_DATE | DATE | |||
QUANTITY | NUMBER |
APPS.CSP_SUBINV_USAGE_DETAILS_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 |
---|---|---|---|---|
TASK_PART_ID | NUMBER | (35) | Y | Task Part unique Identifier |
PRODUCT_TASK_ID | NUMBER | (35) | Y | Product Task Identifier |
CONCATENATED_SEGMENTS | VARCHAR2 | (40) | Item Number | |
ORGANIZATION_ID | NUMBER | Y | Organization Identifier | |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory Item Identifier |
MANUAL_QUANTITY | NUMBER | Manual Quantity | ||
MANUAL_PERCENTAGE | NUMBER | Manual Percentage | ||
ROLLUP_QUANTITY_USED | NUMBER | Rollup Quantity used | ||
ROLLUP_TIMES_USED | NUMBER | Rollup Times Used | ||
ROLLUP_QUANTITY | NUMBER | Rollup Quantity | ||
ROLLUP_PERCENTAGE | NUMBER | Rollup Percentage | ||
QUANTITY_USED | NUMBER | Calculated Quantity Used | ||
ACTUAL_TIMES_USED | NUMBER | Actual Times Used | ||
CALCULATED_QUANTITY | NUMBER | Calculated Quantity | ||
PART_PERCENTAGE | NUMBER | Calculated Percentage | ||
QUANTITY | NUMBER | Quantity Required | ||
PERCENTAGE | NUMBER | Percentage of usage | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit Of Measurement Code | |
REVISION | VARCHAR2 | (30) | Revision | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End Date | ||
SUBSTITUTE_ITEM | NUMBER | (35) | Substitute Item | |
INVENTORY_ITEM_FLAG | VARCHAR2 | (1) | Y | |
CREATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who column - with user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who column | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield Segment Column |
APPS.CSP_TASK_PARTS_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 |
---|---|---|---|---|
CREATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Y | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Y | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
USAGE_ID | NUMBER | (35) | Usage identifier | |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
ORGANIZAITON_ID | NUMBER | (35) | Y | Organization identifier |
HIERARCHY_NODE_ID | NUMBER | (35) | Hierarchy node identifier | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
PERIOD_TYPE | VARCHAR2 | (30) | Y | Period type |
PERIOD_START_DATE | DATE | Y | Period start date | |
QUANTITY | NUMBER | (35) | Y | Quantity |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Y | Subinventory name |
TRANSACTION_TYPE_ID | NUMBER | (35) | Transaction type identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column |
APPS.CSP_USAGE_HISTORIES_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 |
---|---|---|---|---|
PERIOD_START_DATE | DATE | Y | Period start date | |
PERIOD_TYPE | VARCHAR2 | (30) | Y | Period type |
INVENTORY_ITEM_ID | NUMBER | (35) | Y | Inventory item identifier |
ORGANIZATION_ID | NUMBER | (35) | Y | Organization identifier |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (30) | Y | Subinventory name |
HIERARCHY_NODE_ID | NUMBER | (35) | Hierarchy node identifier | |
USAGE_QUANTITY | NUMBER | Usage quantity | ||
SO_QUANTITY | NUMBER | Sales order quantity | ||
FORECAST_QUANTITY | NUMBER | Forecast quantity | ||
TOTAL | NUMBER | Usage plus sales order quantities |
APPS.CSP_USAGE_HISTORIES_V1 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 |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | (38) | Y | |
ORGANIZATION_ID | NUMBER | (35) | ||
SECONDARY_INVENTORY | VARCHAR2 | (10) | ||
AWU | NUMBER | |||
LEVEL_ID | VARCHAR2 | (200) | Y |
APPS.CSP_USAGE_REG_ORG_SUBINV_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |