APPS.POA_PORTAL_POPULATE_C dependencies on POA_REP_SUP_SCORE_V

Line 683: POA_REP_SUP_SCORE_V

679: avg(NVL(Price_Score,25)) Price_Score,
680: avg(NVL(Quality_Score,25)) Quality_Score,
681: avg(NVL(Delivery_Score,25)) Delivery_Score,
682: avg(NVL(Survey_Score,25)) Survey_Score from
683: POA_REP_SUP_SCORE_V
684: group by Supplier_Site) Cstm_Msr,
685: EDW_TRD_Partner_M Supplier
686: where pod.SUPPLIER_SITE_FK_KEY = Supplier.TPLO_TPartner_Loc_PK_Key
687: and pod.SUPPLIER_SITE_FK_KEY = Cstm_Msr.Supplier_Site

Line 778: POA_REP_SUP_SCORE_V

774: avg(NVL(Price_Score,25)) Price_Score,
775: avg(NVL(Quality_Score,25)) Quality_Score,
776: avg(NVL(Delivery_Score,25)) Delivery_Score,
777: avg(NVL(Survey_Score,25)) Survey_Score from
778: POA_REP_SUP_SCORE_V
779: group by Supplier_Site) Cstm_Msr,
780: EDW_TRD_Partner_M Supplier
781: where pod.SUPPLIER_SITE_FK_KEY = Supplier.TPLO_TPartner_Loc_PK_Key
782: and pod.SUPPLIER_SITE_FK_KEY = Cstm_Msr.Supplier_Site

Line 873: POA_REP_SUP_SCORE_V

869: avg(NVL(Price_Score,25)) Price_Score,
870: avg(NVL(Quality_Score,25)) Quality_Score,
871: avg(NVL(Delivery_Score,25)) Delivery_Score,
872: avg(NVL(Survey_Score,25)) Survey_Score from
873: POA_REP_SUP_SCORE_V
874: group by Supplier_Site) Cstm_Msr,
875: EDW_TRD_Partner_M Supplier
876: where pod.SUPPLIER_SITE_FK_KEY = Supplier.TPLO_TPartner_Loc_PK_Key
877: and pod.SUPPLIER_SITE_FK_KEY = Cstm_Msr.Supplier_Site