DBA Data[Home] [Help]

APPS.AHL_MC_ITEMGROUP_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 149: AHL_ITEM_GROUPS_B IGROUP, MTL_SYSTEM_ITEMS_KFV MTL

145: SOURCE.inventory_org_id inventory_org_id,
146: SOURCE.revision revision,
147: MTL.concatenated_segments concatenated_segments
148: FROM AHL_ITEM_ASSOCIATIONS_B SOURCE, AHL_ITEM_ASSOCIATIONS_B REVISION,
149: AHL_ITEM_GROUPS_B IGROUP, MTL_SYSTEM_ITEMS_KFV MTL
150: WHERE REVISION.item_association_id = p_assoc_id AND
151: IGROUP.item_group_id = REVISION.item_group_id AND
152: SOURCE.item_group_id = IGROUP.source_item_group_id AND
153: SOURCE.inventory_item_id = REVISION.inventory_item_id AND

Line 256: AHL_ITEM_GROUPS_B IGROUP, MTL_SYSTEM_ITEMS_KFV MTL,

252: l_revision_tbl,
253: l_concatenated_segments_tbl,
254: l_interchange_type_tbl
255: FROM AHL_ITEM_ASSOCIATIONS_B SOURCE, AHL_ITEM_ASSOCIATIONS_B REVISION,
256: AHL_ITEM_GROUPS_B IGROUP, MTL_SYSTEM_ITEMS_KFV MTL,
257: FND_LOOKUP_VALUES_VL FL
258: WHERE IGROUP.item_group_id = p_ItemGroup_id AND
259: REVISION.item_group_id = IGROUP.item_group_id AND
260: SOURCE.item_group_id = IGROUP.source_item_group_id AND