APPS.BOM_ROLLUP_PUB dependencies on FND_LOOKUP_VALUES

Line 1343: FND_LOOKUP_VALUES FL_ITEM_TYPE

1339: )
1340: AND EXISTS (
1341: SELECT MSIVL_PARENT.INVENTORY_ITEM_ID
1342: FROM MTL_SYSTEM_ITEMS_VL MSIVL_PARENT,
1343: FND_LOOKUP_VALUES FL_ITEM_TYPE
1344: WHERE MSIVL_PARENT.INVENTORY_ITEM_ID = IMPL.PARENT_PK1_VALUE
1345: AND MSIVL_PARENT.ORGANIZATION_ID = IMPL.PARENT_PK2_VALUE
1346: AND MSIVL_PARENT.ITEM_TYPE = FL_ITEM_TYPE.LOOKUP_CODE(+)
1347: AND FL_ITEM_TYPE.LOOKUP_TYPE(+) = 'ITEM_TYPE'