APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on FND_COMMON_LOOKUPS

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'

Line 200: FROM FND_COMMON_LOOKUPS LOOKUP,

196: -- dbms_output.put_line('CHILD ITEM TYPE '||l_child_item_type_name);
197: IF (l_parent_item_type IS NOT NULL)
198: THEN
199: SELECT TEMPLATES.CUSTOMIZATION_CODE INTO l_customization_code
200: FROM FND_COMMON_LOOKUPS LOOKUP,
201: EGO_CRITERIA_TEMPLATES_V TEMPLATES
202: WHERE LOOKUP.LOOKUP_TYPE = 'ITEM_TYPE'
203: AND LOOKUP.ENABLED_FLAG = 'Y'
204: AND (LOOKUP.START_DATE_ACTIVE IS NULL OR LOOKUP.START_DATE_ACTIVE < SYSDATE)