[Home] [Help]
138: org.oper_operating_unit_pk_key,
139: org.oper_name
140: FROM poa_edw_rcv_txns_f rcv,
141: edw_organization_m org,
142: edw_trd_partner_m tp,
143: edw_lookup_m lku,
144: edw_time_m time
145: WHERE rcv.RCV_DEL_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
146: and rcv.Supplier_Site_FK_Key = tp.TPLO_TPARTNER_LOC_PK_KEY
162: org.oper_operating_unit_pk_key,
163: org.oper_name
164: FROM poa_edw_sup_perf_f sp,
165: edw_organization_m org,
166: edw_trd_partner_m tp,
167: edw_time_m time
168: WHERE ((sp.Qty_Ordered_B-sp.Qty_Received_B) > 0)
169: and sp.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
170: and sp.Supplier_Site_FK_Key = tp.TPLO_TPARTNER_LOC_PK_KEY
407: item.IORG_Purchaseable_Flag
408: from poa_edw_po_dist_f pod,
409: edw_items_m item,
410: edw_organization_m org,
411: edw_trd_partner_m tp,
412: edw_time_m time1,
413: edw_time_m time2,
414: edw_time_m time3
415: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
443: item.IORG_Purchaseable_Flag
444: from poa_edw_po_dist_f pod,
445: edw_items_m item,
446: edw_organization_m org,
447: edw_trd_partner_m tp,
448: edw_time_m time1,
449: edw_time_m time2
450: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
451: and pod.SHIP_TO_ORG_FK_KEY = org.ORGA_ORGANIZATION_PK_KEY
566: 1,1,0)),
567: p_quarter,
568: item.IORG_Purchaseable_Flag
569: from poa_edw_po_dist_f pod,
570: edw_trd_partner_m tp,
571: edw_time_m time1,
572: edw_time_m time2,
573: edw_time_m time3,
574: edw_items_m item
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
688: group by Supplier.tprt_trade_partner_pk_key,
689: Supplier.tprt_name;
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
783: group by Supplier.tprt_trade_partner_pk_key,
784: Supplier.tprt_name;
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
878: group by Supplier.tprt_trade_partner_pk_key,
879: Supplier.tprt_name;
1155: avg(NVL(Quality_Score, 25)),
1156: avg(NVL(Survey_Score, 25))
1157: from POA_REP_CSTM_MSR_V Cstm_Msr,
1158: EDW_Organization_M Organization,
1159: EDW_TRD_Partner_M Supplier,
1160: EDW_Time_M Time
1161: where
1162: Cstm_Msr.Ship_To_Org_FK_Key = Organization.Orga_Organization_PK_Key and
1163: Cstm_Msr.Supplier_Site_FK_Key = Supplier.TPLO_TPartner_Loc_PK_Key and