[Home] [Help]
[Dependency Information]
VIEW: APPS.JTF_RS_COMPONENTS_V
Object Details
Object Name: | JTF_RS_COMPONENTS_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_RS_COMPONENTS_V
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
Stores all valid components that skills can be assigned to.
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
COMPONENT_ID |
NUMBER |
|
Yes |
Component Identifier. |
PRODUCT_ORG_ID |
NUMBER |
|
Yes |
Product Organization Identifier. |
COMPONENT_NAME |
VARCHAR2 |
(40) |
|
Component Name. |
DESCRIPTION |
VARCHAR2 |
(240) |
|
Description. |
PRODUCT_ID |
NUMBER |
|
Yes |
Product Identifier. |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT COMPONENT_ID
, PRODUCT_ORG_ID
, COMPONENT_NAME
, DESCRIPTION
, PRODUCT_ID
FROM APPS.JTF_RS_COMPONENTS_V;
Dependencies
[top of page]
APPS.JTF_RS_COMPONENTS_V references the following:
-
APPS
-
BOM_BILL_OF_MATERIALS
-
BOM_INVENTORY_COMPONENTS
-
FND_GLOBAL
- show dependent code
-
MTL_SYSTEM_ITEMS
-
MTL_SYSTEM_ITEMS_KFV
APPS.JTF_RS_COMPONENTS_V is referenced by following:
-
APPS
-
JTF_RS_JSP_LOV_RECS_PUB
- show dependent code
-
JTF_RS_RESOURCE_SKILLS_PUB
- show dependent code
-
JTF_RS_RESOURCE_SKILLS_PVT
- show dependent code
-
JTF_RS_SKILLS_REPORT_PUB
- show dependent code