DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 168: FROM MTL_SYSTEM_ITEMS_KFV MSI ,FND_COMMON_LOOKUPS LOOKUP

164: l_return_status := 'N';
165:
166: SELECT MSI.ITEM_TYPE, LOOKUP.MEANING ,MSI.CONCATENATED_SEGMENTS
167: INTO l_parent_item_type,l_parent_item_type_name,l_parent_name
168: FROM MTL_SYSTEM_ITEMS_KFV MSI ,FND_COMMON_LOOKUPS LOOKUP
169: WHERE
170: INVENTORY_ITEM_ID = p_parent_item_id AND ORGANIZATION_ID = p_organization_id
171: AND MSI.ITEM_TYPE = LOOKUP.LOOKUP_CODE(+)
172: AND LOOKUP.LOOKUP_TYPE(+) = 'ITEM_TYPE'

Line 183: FROM MTL_SYSTEM_ITEMS_KFV MSI ,FND_COMMON_LOOKUPS LOOKUP

179: --dbms_output.put_line('l_parent_item_type '||l_parent_item_type);
180:
181: SELECT MSI.ITEM_TYPE, LOOKUP.MEANING ,MSI.CONCATENATED_SEGMENTS
182: INTO l_child_item_type , l_child_item_type_name,l_child_name
183: FROM MTL_SYSTEM_ITEMS_KFV MSI ,FND_COMMON_LOOKUPS LOOKUP
184: WHERE
185: INVENTORY_ITEM_ID = p_child_item_id AND ORGANIZATION_ID = p_organization_id
186: AND MSI.ITEM_TYPE = LOOKUP.LOOKUP_CODE(+)
187: AND LOOKUP.LOOKUP_TYPE(+) = 'ITEM_TYPE'