VIEW: APPS.POA_PMF_PO_SUPLR_CNT2_V

Source

View Text - Preformatted

SELECT Organization.All_All_PK_Key, Item.Item_Item_Number_PK_Key, Time.ECQR_CAL_QTR_PK_KEY, count(distinct Supplier.TPRT_Name) from POA_EDW_PO_DIST_F Distribution, EDW_Organization_M Organization, EDW_TRD_Partner_M Supplier, EDW_Items_M Item, EDW_Time_M Time WHERE Distribution.Ship_To_Org_FK_Key = Organization.Orga_Organization_PK_Key and Distribution.Supplier_Site_FK_Key = Supplier.TPLO_TPartner_Loc_PK_Key and Distribution.Item_FK_Key = Item.Irev_Item_Revision_PK_Key and Distribution.PO_App_Date_FK_Key = Time.CDay_Cal_Day_PK_Key group by Organization.All_All_PK_Key, Item.Item_Item_Number_PK_Key, Time.ECQR_CAL_QTR_PK_KEY

View Text - HTML Formatted

SELECT ORGANIZATION.ALL_ALL_PK_KEY
, ITEM.ITEM_ITEM_NUMBER_PK_KEY
, TIME.ECQR_CAL_QTR_PK_KEY
, COUNT(DISTINCT SUPPLIER.TPRT_NAME)
FROM POA_EDW_PO_DIST_F DISTRIBUTION
, EDW_ORGANIZATION_M ORGANIZATION
, EDW_TRD_PARTNER_M SUPPLIER
, EDW_ITEMS_M ITEM
, EDW_TIME_M TIME
WHERE DISTRIBUTION.SHIP_TO_ORG_FK_KEY = ORGANIZATION.ORGA_ORGANIZATION_PK_KEY
AND DISTRIBUTION.SUPPLIER_SITE_FK_KEY = SUPPLIER.TPLO_TPARTNER_LOC_PK_KEY
AND DISTRIBUTION.ITEM_FK_KEY = ITEM.IREV_ITEM_REVISION_PK_KEY
AND DISTRIBUTION.PO_APP_DATE_FK_KEY = TIME.CDAY_CAL_DAY_PK_KEY GROUP BY ORGANIZATION.ALL_ALL_PK_KEY
, ITEM.ITEM_ITEM_NUMBER_PK_KEY
, TIME.ECQR_CAL_QTR_PK_KEY