DBA Data[Home] [Help]

APPS.CSD_RO_BULLETINS_PVT dependencies on FND_PROFILE

Line 1699: OR (dom.category_set_id = fnd_profile.value('CSD_DEFAULT_CATEGORY_SET')

1695: csd_sc_domains_v dom, CSD_REPAIRS dra
1696: WHERE dom.service_code_id = p_service_code_id
1697: AND dra.repair_line_id = p_repair_line_id
1698: AND (dom.inventory_item_id = dra.inventory_item_id
1699: OR (dom.category_set_id = fnd_profile.value('CSD_DEFAULT_CATEGORY_SET')
1700: AND dom.category_id in ( SELECT DISTINCT cat.category_id
1701: FROM mtl_item_categories_v cat
1702: WHERE cat.inventory_item_id = dra.inventory_item_id)
1703: )