APPS.AS_SALES_LEAD_LINES_PVT dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 474: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

470: )
471: IS
472: CURSOR C_category_id_Exists (X_cat_Id NUMBER) IS
473: SELECT distinct 'X'
474: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
475: WHERE category_id = X_cat_Id
476: AND (disable_date IS NULL OR disable_date > SYSDATE)
477: and PURCHASE_interest = 'Y';
478: l_variable VARCHAR2(1);

Line 527: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

523: )
524: IS
525: CURSOR C_category_set_id_Exists (X_cat_set_Id NUMBER) IS
526: SELECT distinct 'X'
527: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
528: WHERE category_set_id = X_cat_set_Id
529: AND (disable_date IS NULL OR disable_date > SYSDATE)
530: and PURCHASE_interest = 'Y';
531: l_variable VARCHAR2(1);

Line 1026: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

1022: WHERE sales_lead_id = c_sales_lead_id;
1023:
1024: CURSOR C_Get_Category_set_ID (X_cat_Id NUMBER) IS
1025: SELECT category_set_id
1026: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
1027: WHERE category_id = X_cat_Id
1028: AND (disable_date IS NULL OR disable_date > SYSDATE)
1029: and PURCHASE_interest = 'Y';
1030:

Line 1034: ENI_PROD_DEN_HRCHY_PARENTS_V P

1030:
1031: CURSOR C_Get_Category_INFO (X_prod_Id NUMBER, X_Org_Id NUMBER) IS
1032: SELECT P.CATEGORY_ID CAT_ID, P.CATEGORY_SET_ID CAT_SET_ID
1033: FROM MTL_SYSTEM_ITEMS_B_KFV B, MTL_ITEM_CATEGORIES MIC,
1034: ENI_PROD_DEN_HRCHY_PARENTS_V P
1035: WHERE (MIC.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID
1036: AND MIC.ORGANIZATION_ID = B.ORGANIZATION_ID
1037: AND B.ORGANIZATION_ID = X_Org_Id
1038: and B.INVENTORY_ITEM_ID = X_prod_Id