DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.WSM_CO_PRODUCT_COMPONENTS_V

Object Details
Object Name: WSM_CO_PRODUCT_COMPONENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSM.WSM_CO_PRODUCT_COMPONENTS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CO_PRODUCT_GROUP_ID NUMBER
Yes
COMPONENT_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
COMPONENT_SEQUENCE_ID NUMBER

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).
EFFECTIVITY_DATE DATE
Yes
DISABLE_DATE DATE

USAGE_RATE NUMBER
Yes
DUALITY_FLAG VARCHAR2 (1)
PLANNING_FACTOR NUMBER

COMPONENT_YIELD_FACTOR NUMBER

INCLUDE_IN_COST_ROLLUP NUMBER

WIP_SUPPLY_TYPE NUMBER

SUPPLY_TYPE VARCHAR2 (80)
SUPPLY_SUBINVENTORY VARCHAR2 (10)
SUPPLY_LOCATOR_ID NUMBER

COMPONENT_REMARKS VARCHAR2 (240)
COMP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
COMP_ATTRIBUTE1 VARCHAR2 (150)
COMP_ATTRIBUTE2 VARCHAR2 (150)
COMP_ATTRIBUTE3 VARCHAR2 (150)
COMP_ATTRIBUTE4 VARCHAR2 (150)
COMP_ATTRIBUTE5 VARCHAR2 (150)
COMP_ATTRIBUTE6 VARCHAR2 (150)
COMP_ATTRIBUTE7 VARCHAR2 (150)
COMP_ATTRIBUTE8 VARCHAR2 (150)
COMP_ATTRIBUTE9 VARCHAR2 (150)
COMP_ATTRIBUTE10 VARCHAR2 (150)
COMP_ATTRIBUTE11 VARCHAR2 (150)
COMP_ATTRIBUTE12 VARCHAR2 (150)
COMP_ATTRIBUTE13 VARCHAR2 (150)
COMP_ATTRIBUTE14 VARCHAR2 (150)
COMP_ATTRIBUTE15 VARCHAR2 (150)
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).
COMPONENT_ITEM_DESC VARCHAR2 (240)
ALTERNATE_DESIGNATOR VARCHAR2 (10)
INVENTORY_ASSET_FLAG VARCHAR2 (1) Yes
ITEM_LOCATOR_CONTROL NUMBER

RESTRICT_LOCATORS_FLAG NUMBER

RESTRICT_SUBINV_FLAG VARCHAR2 (1)
ITEM_TYPE VARCHAR2 (80)
INVENTORY_ITEM_STATUS_CODE VARCHAR2 (10) Yes
BASIS_TYPE NUMBER

Component Basis type
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CO_PRODUCT_GROUP_ID
,      COMPONENT_ID
,      ORGANIZATION_ID
,      COMPONENT_SEQUENCE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      USAGE_RATE
,      DUALITY_FLAG
,      PLANNING_FACTOR
,      COMPONENT_YIELD_FACTOR
,      INCLUDE_IN_COST_ROLLUP
,      WIP_SUPPLY_TYPE
,      SUPPLY_TYPE
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      COMPONENT_REMARKS
,      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
,      COMPONENT_ITEM_DESC
,      ALTERNATE_DESIGNATOR
,      INVENTORY_ASSET_FLAG
,      ITEM_LOCATOR_CONTROL
,      RESTRICT_LOCATORS_FLAG
,      RESTRICT_SUBINV_FLAG
,      ITEM_TYPE
,      INVENTORY_ITEM_STATUS_CODE
,      BASIS_TYPE
FROM APPS.WSM_CO_PRODUCT_COMPONENTS_V;

Dependencies

[top of page]

APPS.WSM_CO_PRODUCT_COMPONENTS_V references the following:

SchemaAPPS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_SYSTEM_ITEMS
PL/SQL PackageWSMPCOGI - show dependent code
SynonymWSM_CO_PRODUCTS

APPS.WSM_CO_PRODUCT_COMPONENTS_V is not referenced by any database object