APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on FND_LOOKUPS

Line 343: FROM FND_LOOKUPS F,

339:
340: -- Get Default Product Type
341: CURSOR c_product_type IS
342: SELECT F.LOOKUP_CODE
343: FROM FND_LOOKUPS F,
344: MTL_SYSTEM_ITEMS_B I
345: WHERE F.LOOKUP_TYPE= 'ZX_PRODUCT_TYPE'
346: AND I.INVENTORY_ITEM_ID = p_item_id
347: AND I.ORGANIZATION_ID = p_org_id