[Home] [Help] [Dependency Information]
Object Name: | WSM_CO_PRODUCTS |
---|---|
Object Type: | TABLE |
Owner: | WSM |
FND Design Data: | WSM.WSM_CO_PRODUCTS |
Subobject Name: | |
Status: | VALID |
Definition of OSFM Co-product relationship
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WSM_CO_PRODUCTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CO_PRODUCT_GROUP_ID
CO_PRODUCT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_PRODUCT_GROUP_ID | NUMBER | Yes | Co-product group identifies the relationships between One Component and Co-Products in a definition. | |
COMPONENT_ID | NUMBER | Yes | Component Identifier. | |
ORGANIZATION_ID | NUMBER | Yes | OSFM Organization Identifier. | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CO_PRODUCT_ID | NUMBER | Co-Product Identifier | ||
BILL_SEQUENCE_ID | NUMBER | Bill Sequence Id in Bill of Materials. | ||
COMPONENT_SEQUENCE_ID | NUMBER | Component sequence Id for the primary Bill created for the primary co-product in a group. | ||
SPLIT | NUMBER | Normally, Primary co-product will have the highest % value. | ||
EFFECTIVITY_DATE | DATE | Yes | Co-product group effective date. | |
DISABLE_DATE | DATE | Co-product group disable date. | ||
PRIMARY_FLAG | VARCHAR2 | (1) | Primary co-product will have 'Y'. Non-primary co-product will have 'N'. Values for component records will be NULL. | |
REVISION | VARCHAR2 | (3) | Co-product revision Identifer. | |
CHANGE_NOTICE | VARCHAR2 | (10) | Co-product Engineering Change Notice. | |
IMPLEMENTATION_DATE | DATE | ECO Implementation date. | ||
USAGE_RATE | NUMBER | Yes | Component Usage rate. | |
DUALITY_FLAG | VARCHAR2 | (1) | Duality Flag (For future use) | |
PLANNING_FACTOR | NUMBER | Planning Factor | ||
COMPONENT_YIELD_FACTOR | NUMBER | Component Yield. | ||
INCLUDE_IN_COST_ROLLUP | NUMBER | Include this component in cost-rollup | ||
WIP_SUPPLY_TYPE | NUMBER | Work In Process Supply Type. | ||
SUPPLY_SUBINVENTORY | VARCHAR2 | (10) | Supply Subinventory for component | |
SUPPLY_LOCATOR_ID | NUMBER | Supply Locator for component, if supply subinventory is locator controlled. | ||
COMPONENT_REMARKS | VARCHAR2 | (240) | Component Remarks | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition 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 | |
COMP_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield definition category | |
COMP_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
COMP_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ALTERNATE_DESIGNATOR | VARCHAR2 | (10) | Alternate Designator for co-products | |
BASIS_TYPE | NUMBER | Component Basis Type |
Cut, paste (and edit) the following text to query this object:
SELECT CO_PRODUCT_GROUP_ID
, COMPONENT_ID
, ORGANIZATION_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CO_PRODUCT_ID
, BILL_SEQUENCE_ID
, COMPONENT_SEQUENCE_ID
, SPLIT
, EFFECTIVITY_DATE
, DISABLE_DATE
, PRIMARY_FLAG
, REVISION
, CHANGE_NOTICE
, IMPLEMENTATION_DATE
, USAGE_RATE
, DUALITY_FLAG
, PLANNING_FACTOR
, COMPONENT_YIELD_FACTOR
, INCLUDE_IN_COST_ROLLUP
, WIP_SUPPLY_TYPE
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, COMPONENT_REMARKS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, COMP_ATTRIBUTE_CATEGORY
, COMP_ATTRIBUTE1
, COMP_ATTRIBUTE2
, COMP_ATTRIBUTE3
, COMP_ATTRIBUTE4
, COMP_ATTRIBUTE5
, COMP_ATTRIBUTE6
, COMP_ATTRIBUTE7
, COMP_ATTRIBUTE8
, COMP_ATTRIBUTE9
, COMP_ATTRIBUTE10
, COMP_ATTRIBUTE11
, COMP_ATTRIBUTE12
, COMP_ATTRIBUTE13
, COMP_ATTRIBUTE14
, COMP_ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ALTERNATE_DESIGNATOR
, BASIS_TYPE
FROM WSM.WSM_CO_PRODUCTS;
WSM.WSM_CO_PRODUCTS does not reference any database object
WSM.WSM_CO_PRODUCTS is referenced by following:
|
|
|