DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on FND_LOOKUP_VALUES

Line 1063: FROM MTL_SYSTEM_ITEMS_B items, FND_LOOKUP_VALUES FLV

1059: -- Bug 5739175
1060: BEGIN
1061: -- Retrieve Item_type
1062: Select MEANING INTO l_Item_type
1063: FROM MTL_SYSTEM_ITEMS_B items, FND_LOOKUP_VALUES FLV
1064: WHERE items.INVENTORY_ITEM_ID = p_line_rec.inventory_item_id
1065: AND items.ORGANIZATION_ID = p_line_rec.ship_from_org_id --l_organization_code
1066: AND FLV.LOOKUP_CODE = items.ITEM_TYPE AND FLV.LOOKUP_TYPE = 'ITEM_TYPE'
1067: AND FLV.VIEW_APPLICATION_ID = 3