Results for “item_group_id”
50+ results
-
This table stores translated information about item groups.
-
This table stores translated information about item groups.
-
This table stores information about item groups. Items are grouped so that each group could be used in positions multiple times.
-
This table stores information about item groups. Items are grouped so that each group could be used in positions multiple times.
-
This table is Histrory of the Item Group Assoications
-
View: AHL_ITEM_COMP_DETAIL_V 12.2.2
Item Composition Details V joins Item Groups, UOm Class and MTL table for Name and Description
APPS.AHL_ITEM_COMP_DETAIL_V·↳ AHL_ITEM_COMP_DETAILS·↳ AHL_ITEM_GROUPS_VL·↳ AHL_MTL_ITEMS_NON_OU_V·Explore AHL module →
-
View: AHL_MC_RELATIONSHIPS_V 12.2.2
This view gives Master Configuration node details with respective lookup columns resolved into meanings.
APPS.AHL_MC_RELATIONSHIPS_V·↳ AHL_ITEM_GROUPS_B·↳ AHL_ITEM_GROUPS_TL·↳ AHL_MC_RELATIONSHIPS·Explore AHL module →
-
View: AHL_VISIT_TASK_MATRL_V 12.2.2
This view stores the query to retrieve Work flow nformation
APPS.AHL_VISIT_TASK_MATRL_V·↳ AHL_MC_HEADERS_VL·↳ AHL_MC_PATH_POSITION_PVT·↳ AHL_MC_RELATIONSHIPS·Explore AHL module →
-
APPS.AHL_JOB_OPER_MATERIALS_V·↳ AHL_PP_MATERIALS_PVT·↳ AHL_SCHEDULE_MATERIALS·↳ AHL_VISITS_VL·Explore AHL module →
-
View: AHL_ITEM_GROUPS_VL 12.1.1
View based on the table AHL_ITEM_GROUPS_B and the translated columns from the table AHL_ITEM_GROUPS_TL.
APPS.AHL_ITEM_GROUPS_VL·↳ AHL_ITEM_GROUPS_B·↳ AHL_ITEM_GROUPS_TL·Explore AHL module →
-
APPS.AHL_SCHEDULE_MATERIALS_V·↳ AHL_COMPLETIONS_PVT·↳ AHL_PP_MATERIALS_PVT·↳ AHL_PRD_SERN_CHANGE_PVT·Explore AHL module →
-
This table is an intersection table to store the association between item group and the inventory item.
-
This view is based on item_associations_b + item_associations_tl table.
APPS.AHL_ITEM_ASSOCIATIONS_VL·↳ AHL_ITEM_ASSOCIATIONS_B·↳ AHL_ITEM_ASSOCIATIONS_TL·Explore AHL module →
-
This view is based on item_associations_b + item_associations_tl table.
APPS.AHL_ITEM_ASSOCIATIONS_VL·↳ AHL_ITEM_ASSOCIATIONS_B·↳ AHL_ITEM_ASSOCIATIONS_TL·Explore AHL module →
-
This table stores the material and tool requirements for a Route or an Operation.
-
This table is obsoleted tabled from 11.5.10 .. This table stores the position hierarchy of the master configuration.
-
APPS.AHL_JOB_OPER_MATERIALS_V·↳ AHL_PP_MATERIALS_PVT·↳ AHL_SCHEDULE_MATERIALS·↳ AHL_VISITS_VL·Explore AHL module →
-
View: AHL_ITEM_GROUPS_VL 12.2.2
View based on the table AHL_ITEM_GROUPS_B and the translated columns from the table AHL_ITEM_GROUPS_TL.
APPS.AHL_ITEM_GROUPS_VL·↳ AHL_ITEM_GROUPS_B·↳ AHL_ITEM_GROUPS_TL·Explore AHL module →
-
This table stores History about item groups.
-
Store information about workorders's disposiiton
-
View: AHL_MC_RELATIONSHIPS_V 12.1.1
This view gives Master Configuration node details with respective lookup columns resolved into meanings.
APPS.AHL_MC_RELATIONSHIPS_V·↳ AHL_ITEM_GROUPS_B·↳ AHL_ITEM_GROUPS_TL·↳ AHL_MC_RELATIONSHIPS·Explore AHL module →
-
View: AHL_ITEM_GROUPS_V 12.2.2
Item Groups V joins Lookup meaning and Codes
APPS.AHL_ITEM_GROUPS_V·↳ AHL_ITEM_GROUPS_VL·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
View: AHL_ITEM_COMP_DETAIL_V 12.1.1
Item Composition Details V joins Item Groups, UOm Class and MTL table for Name and Description
APPS.AHL_ITEM_COMP_DETAIL_V·↳ AHL_ITEM_COMP_DETAILS·↳ AHL_ITEM_GROUPS_VL·↳ AHL_MTL_ITEMS_NON_OU_V·Explore AHL module →
-
This table is Histrory of the Item Group Assoications
-
View based on the table AHL_RT_OPER_MATERIALS and two other columns CONCATENATED_SEGMENTS and DESCRIPTION from the view AHL_MTL_ITEMS_OU_V.
APPS.AHL_RT_OPER_MATERIALS_V·↳ AHL_ITEM_GROUPS_VL·↳ AHL_MC_HEADERS_B·↳ AHL_MC_RELATIONSHIPS·Explore AHL module →
-
This table stores information about materials scheduled in MRP
-
This table is obsoleted tabled from 11.5.10 .. This table stores the position hierarchy of the master configuration.
-
View: AHL_RELATIONSHIPS_VL 12.1.1
View based on the table AHL_RELATIONSHIPS_B and the translated columns from the table AHL_RELATIONSHIPS_TL.
APPS.AHL_RELATIONSHIPS_VL·↳ AHL_RELATIONSHIPS_B·↳ AHL_RELATIONSHIPS_TL·Explore AHL module →
-
This table stores information about materials scheduled in MRP
-
Item group association view links Item groups with MTL Items.
APPS.AHL_ITEM_ASSOCIATIONS_V·↳ AHL_ITEM_ASSOCIATIONS_VL·↳ AHL_MTL_ITEMS_NON_OU_V·↳ HR_GENERAL·Explore AHL module →
-
Store disposition history
-
View: AHL_VISIT_TASK_MATRL_V 12.1.1
This view stores the query to retrieve Work flow nformation
APPS.AHL_VISIT_TASK_MATRL_V·↳ AHL_MC_HEADERS_VL·↳ AHL_MC_PATH_POSITION_PVT·↳ AHL_MC_RELATIONSHIPS·Explore AHL module →
-
This table is an intersection table to store the association between item group and the inventory item.
-
View: AHL_ITEM_GROUPS_V 12.1.1
Item Groups V joins Lookup meaning and Codes
APPS.AHL_ITEM_GROUPS_V·↳ AHL_ITEM_GROUPS_VL·↳ FND_LOOKUP_VALUES_VL·Explore AHL module →
-
This table stores the details of Non-Tracked Items/ Item Groups associated with a Item Composition in the header table.
-
This table stores History about item groups.
-
This table stores the details of Non-Tracked Items/ Item Groups associated with a Item Composition in the header table.
-
This table stores MC Node information .It is result of denormalization of AHL_RELATIONSHIP_B and TL.
-
This table stores MC Node information .It is result of denormalization of AHL_RELATIONSHIP_B and TL.
-
APPS.AHL_SCHEDULE_MATERIALS_V·↳ AHL_COMPLETIONS_PVT·↳ AHL_ITEM_GROUPS_B·↳ AHL_MC_HEADERS_B·Explore AHL module →
-
View: AHL_RELATIONSHIPS_VL 12.2.2
View based on the table AHL_RELATIONSHIPS_B and the translated columns from the table AHL_RELATIONSHIPS_TL.
APPS.AHL_RELATIONSHIPS_VL·↳ AHL_RELATIONSHIPS_B·↳ AHL_RELATIONSHIPS_TL·Explore AHL module →
-
This table stores the material and tool requirements for a Route or an Operation.
-
View based on the table AHL_RT_OPER_MATERIALS and two other columns CONCATENATED_SEGMENTS and DESCRIPTION from the view AHL_MTL_ITEMS_OU_V.
APPS.AHL_RT_OPER_MATERIALS_V·↳ AHL_ITEM_GROUPS_VL·↳ AHL_RM_ROUTE_UTIL·↳ AHL_RT_OPER_MATERIALS·Explore AHL module →
-
This view gives all details about the Mater Configuration Header and Nodes, and also some information about the item groups associated with the nodes.
APPS.AHL_MASTER_CONFIG_DETAILS_V·↳ AHL_MC_HEADERS_V·↳ AHL_MC_RELATIONSHIPS_V·Explore AHL module →
-
This view gives all details about the Mater Configuration Header and Nodes, and also some information about the item groups associated with the nodes.
APPS.AHL_MASTER_CONFIG_DETAILS_V·↳ AHL_MC_HEADERS_V·↳ AHL_MC_RELATIONSHIPS_V·Explore AHL module →
-
Item group association view links Item groups with MTL Items.
APPS.AHL_ITEM_ASSOCIATIONS_V·↳ AHL_ITEM_ASSOCIATIONS_VL·↳ AHL_MTL_ITEMS_NON_OU_V·↳ HR_GENERAL·Explore AHL module →