APPS.ASO_BI_QOT_PC_PVT dependencies on ENI_DENORM_HIERARCHIES

Line 395: FROM ENI_DENORM_HIERARCHIES PCD

391: ,l_main_clause0,l_main_clause1,l_main_clause2,l_res_clause,l_time_clause0,l_time_clause1,l_summ);
392:
393: INSERT INTO ASO_BI_RPT_TMP2(ASO_VALUE1)
394: SELECT PCD.Imm_child_id
395: FROM ENI_DENORM_HIERARCHIES PCD
396: ,MTL_DEFAULT_CATEGORY_SETS MDFT
397: WHERE PCD.Parent_id = p_product_cat
398: AND PCD.Imm_child_id = PCD.Child_id
399: AND (PCD.Leaf_node_flag = 'Y' OR (PCD.Leaf_node_flag = 'N' AND PCD.Parent_id<>PCD.Imm_child_id))

Line 590: FROM ENI_DENORM_HIERARCHIES PCD

586: ,l_main_clause0,l_main_clause1,l_main_clause2,l_res_clause,l_time_clause0,l_time_clause1,l_summ);
587:
588: INSERT INTO ASO_BI_RPT_TMP2(ASO_VALUE1,ASO_VALUE2)
589: SELECT PCD.Child_id,PCD.Imm_child_id
590: FROM ENI_DENORM_HIERARCHIES PCD
591: ,MTL_DEFAULT_CATEGORY_SETS MDFT
592: WHERE PCD.Parent_id = p_product_cat
593: AND (PCD.Leaf_node_flag = 'Y' OR (PCD.Leaf_node_flag = 'N' AND PCD.Parent_id<>PCD.Imm_child_id))
594: AND MDFT.Functional_area_id = 11

Line 771: FROM ENI_DENORM_HIERARCHIES PCD

767: ,l_main_clause0,l_main_clause1,l_main_clause2,l_res_clause,l_time_clause0,l_time_clause1,l_summ);
768:
769: INSERT INTO ASO_BI_RPT_TMP2(ASO_VALUE1)
770: SELECT PCD.Child_id
771: FROM ENI_DENORM_HIERARCHIES PCD
772: ,MTL_DEFAULT_CATEGORY_SETS MDFT
773: WHERE PCD.Parent_id = p_product_cat
774: AND (PCD.Leaf_node_flag = 'Y' OR (PCD.Leaf_node_flag = 'N' AND PCD.Parent_id<>PCD.Imm_child_id))
775: AND MDFT.Functional_area_id = 11

Line 947: FROM ENI_DENORM_HIERARCHIES PCD

943: ,l_main_clause0,l_main_clause1,l_main_clause2,l_res_clause,l_time_clause0,l_time_clause1,l_summ);
944:
945: INSERT INTO ASO_BI_RPT_TMP2(ASO_VALUE1)
946: SELECT PCD.Child_id
947: FROM ENI_DENORM_HIERARCHIES PCD
948: ,MTL_DEFAULT_CATEGORY_SETS MDFT
949: WHERE PCD.Parent_id = p_product_cat
950: AND (PCD.Leaf_node_flag = 'Y' OR (PCD.Leaf_node_flag = 'N' AND PCD.Parent_id<>PCD.Imm_child_id))
951: AND MDFT.Functional_area_id = 11