DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_ENGINE_PVT dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 840: (select category_id from eni_prod_den_hrchy_parents_v

836: b.selection_type_code = 'INPUT_FILTER' AND
837: asll.sales_lead_id = c_sales_lead_id AND
838: ((b.operator = 'IS_NOT_NULL' AND asll.CATEGORY_ID IS NOT NULL) OR
839: (b.operator = 'EQUALS' AND TO_NUMBER(C.attribute_value) IN
840: (select category_id from eni_prod_den_hrchy_parents_v
841: where category_id in (
842: select category_parent_id from eni_denorm_hrchy_parents
843: start with category_id = ASLL.CATEGORY_ID
844: connect by prior category_parent_id = category_id