[Home] [Help]
[Dependency Information]
VIEW: APPS.AHL_POSITION_ALTERNATES_V
Object Details
Object Name: | AHL_POSITION_ALTERNATES_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_POSITION_ALTERNATES_V
|
---|
Subobject Name: | |
Status: | VALID |
***** Warning: Oracle Internal Use Only *****
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
View Type
Internal
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
RELATIONSHIP_ID |
NUMBER |
|
Yes |
PK for table AHL_RELATIONSHIPS_B |
INVENTORY_ITEM_ID |
NUMBER |
|
Yes |
Inventory Item ID |
INVENTORY_ORG_ID |
NUMBER |
|
Yes |
Inventory Organization ID |
ACTIVE_START_DATE |
DATE |
|
|
Active Start Date |
ACTIVE_END_DATE |
DATE |
|
|
Active end date |
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT RELATIONSHIP_ID
, INVENTORY_ITEM_ID
, INVENTORY_ORG_ID
, ACTIVE_START_DATE
, ACTIVE_END_DATE
FROM APPS.AHL_POSITION_ALTERNATES_V;
Dependencies
[top of page]
APPS.AHL_POSITION_ALTERNATES_V references the following:
-
APPS
-
AHL_ITEM_ASSOCIATIONS_VL
-
AHL_ITEM_GROUPS_B
-
AHL_MC_CONFIG_RELATIONS
-
AHL_MC_HEADERS_B
-
AHL_MC_PATH_POSITION_NODES
-
AHL_MC_RELATIONSHIPS
APPS.AHL_POSITION_ALTERNATES_V is referenced by following:
-
APPS
-
AHL_FMP_COMMON_PVT
- show dependent code
-
AHL_FMP_EFFECTIVITY_DTL_PVT
- show dependent code
-
AHL_FMP_MR_EFFECTIVITY_PVT
- show dependent code
-
AHL_MR_ITEMS_V
-
AHL_MR_ITEM_DETAILS_V
-
AHL_RM_ROUTE_UTIL
- show dependent code