APPS.AS_OPP_LINE_PVT dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 2820: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

2816: )
2817: Is
2818: CURSOR C_Prod_Cat_Exists (X_Product_Category_Id NUMBER, X_Product_Cat_Set_Id NUMBER) IS
2819: SELECT 'X'
2820: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
2821: WHERE Category_Id = X_Product_Category_Id
2822: and Category_Set_Id = X_Product_Cat_Set_Id;
2823:
2824:

Line 2827: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

2823:
2824:
2825: CURSOR C_Prod_Cat_Exists_And_Valid (X_Product_Category_Id NUMBER, X_Product_Cat_Set_Id NUMBER) IS
2826: SELECT 'X'
2827: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
2828: WHERE Category_Id = X_Product_Category_Id
2829: and Category_Set_Id = X_Product_Cat_Set_Id
2830: and Purchase_Interest = 'Y'
2831: and ((Disable_Date is null) or (Disable_Date > SYSDATE));

Line 3553: ENI_PROD_DEN_HRCHY_PARENTS_V P

3549: select 'x'
3550: FROM
3551: MTL_ITEM_CATEGORIES MIC,
3552: MTL_SYSTEM_ITEMS_VL ITEMS,
3553: ENI_PROD_DEN_HRCHY_PARENTS_V P
3554: WHERE
3555: MIC.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID AND
3556: MIC.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID AND
3557: MIC.CATEGORY_ID = P.CATEGORY_ID AND