DBA Data[Home] [Help]

APPS.OKC_XPRT_QUOTE_INT_PVT dependencies on FND_PROFILE

Line 731: SELECT nvl(FND_PROFILE.VALUE('ASO_CATEGORY_SET'), sets.category_set_id )

727: lines.inventory_item_id = mic.INVENTORY_ITEM_ID
728: AND mic.category_id = cats.category_id
729: AND mic.organization_id = lines.organization_id
730: AND mic.category_set_id = (
731: SELECT nvl(FND_PROFILE.VALUE('ASO_CATEGORY_SET'), sets.category_set_id )
732: FROM Mtl_Default_Category_Sets sets
733: WHERE functional_area_id = 7
734: )
735: AND lines.LINE_CATEGORY_CODE = 'ORDER'

Line 879: SELECT nvl(FND_PROFILE.VALUE('ASO_CATEGORY_SET'), sets.category_set_id )

875: lines.inventory_item_id = mic.INVENTORY_ITEM_ID
876: AND mic.category_id = cats.category_id
877: AND mic.organization_id = lines.organization_id
878: AND mic.category_set_id = (
879: SELECT nvl(FND_PROFILE.VALUE('ASO_CATEGORY_SET'), sets.category_set_id )
880: FROM Mtl_Default_Category_Sets sets
881: WHERE functional_area_id = 7
882: )
883: AND lines.LINE_CATEGORY_CODE = 'ORDER'