[Home] [Help]
[Dependency Information]
| Object Name: | AHL_PP_RESRC_REQ_ASG_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | AHL.AHL_PP_RESRC_REQ_ASG_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RESOURCE_CODE | VARCHAR2 | (10) | ||
| ALT_PRIM_TYPE | VARCHAR2 | (80) | ||
| PRIORITY | VARCHAR2 | (40) | ||
| RESOURCE_ID | NUMBER | |||
| DESCRIPTION | VARCHAR2 | (240) | ||
| DEPARTMENT_ID | NUMBER | |||
| WORKORDER_ID | NUMBER | |||
| OPERATION_ID | NUMBER | |||
| OPERATION_SEQUENCE_NUM | NUMBER | |||
| RESOURCE_TYPE_CODE | NUMBER | |||
| RESOURCE_TYPE_NAME | VARCHAR2 | (80) | ||
| UOM_CODE | VARCHAR2 | (3) | ||
| UOM_NAME | VARCHAR2 | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_CODE
, ALT_PRIM_TYPE
, PRIORITY
, RESOURCE_ID
, DESCRIPTION
, DEPARTMENT_ID
, WORKORDER_ID
, OPERATION_ID
, OPERATION_SEQUENCE_NUM
, RESOURCE_TYPE_CODE
, RESOURCE_TYPE_NAME
, UOM_CODE
, UOM_NAME
FROM APPS.AHL_PP_RESRC_REQ_ASG_V;
APPS
AHL_ALTERNATE_RESOURCES
AHL_COMPLETIONS_PVT
- show dependent code
AHL_PRD_SERN_CHANGE_PVT
- show dependent code
AHL_RESOURCE_MAPPINGS
AHL_RT_OPER_RESOURCES
AHL_UTILITY_PVT
- show dependent code
AHL_UTIL_UC_PKG
- show dependent code
AHL_WORKORDERS_V
AHL_WORKORDER_OPERATIONS_V
BOM_DEPARTMENT_RESOURCES
BOM_RESOURCES
FND_GLOBAL
- show dependent code
FND_LOOKUP_VALUES_VL
FND_PROFILE
- show dependent code
HR_GENERAL
- show dependent code
HR_SECURITY
- show dependent code
MFG_LOOKUPS
MO_GLOBAL
- show dependent code
MTL_UNITS_OF_MEASURE
APPS.AHL_PP_RESRC_REQ_ASG_V is not referenced by any database object
|
|
|
|