VIEW: APPS.POA_REP_PO_PURCHASES_V

Source

View Text - Preformatted

SELECT Organization.All_All_PK_Key, Organization.Oper_Operating_Unit_PK_Key, Organization.Orga_Organization_PK_Key, Item.All_All_PK_Key, Item.Ci11_Category_PK_Key, Item.Item_Item_Number_PK_Key, Supplier.All_All_PK_Key, Supplier.PTP4_TPartner_PK_Key, Supplier.TPRT_Trade_Partner_PK_Key, Supplier.TPLO_TPartner_Loc_PK_Key, Buyer.All_All_PK_Key, Buyer.Asgn_Assignment_PK_Key, Geography.All_All_PK_Key, Geography.Are1_Area1_PK_Key, Geography.Are2_Area2_PK_Key, Geography.Coun_Country_PK_Key, Geography.Regn_Region_PK_Key, Geography.Stat_State_PK_Key, Time.All_All_PK_Key, Time.ECYR_CAL_YEAR_PK_KEY, Time.ECQR_CAL_QTR_PK_KEY, Time.Mnth_Month_PK_Key, DUNS.All_All_PK_Key, DUNS.Glbl_Global_Ult_PK_Key, DUNS.Dome_Domestic_Ult_PK_Key, DUNS.Prnt_Parent_PK_Key, DUNS.Hqtr_HQ_PK_Key, DUNS.DNMR_DUNS_Num_PK_Key, UNSPSC.Sgmt_Segment_PK_Key, UNSPSC. Fmly_Family_PK_Key, UNSPSC.Clas_Class_PK_Key, UNSPSC.Cmdt_Commodity_PK_Key, UNSPSC.Fnct_Function_PK_Key, UNSPSC.All_All_PK_Key, Distribution.Amt_Purchased_G, Distribution.Amt_Contract_G, Distribution.Amt_NonContract_G, Distribution.Amt_Leakage_G, Distribution.Potential_Svg_G, Greatest(Distribution.Potential_Svg_G,0), Least(Distribution.Potential_Svg_G,0), Distribution.Price_G, Distribution.PO_Creation_Cycle_Time from POA_EDW_PO_DIST_F Distribution, EDW_Organization_M Organization, EDW_HR_Person_M Buyer, EDW_TRD_Partner_M Supplier, EDW_Geography_M Geography, EDW_Time_M Time, EDW_Items_M Item, EDW_DUNS_M DUNS, EDW_UNSPSC_M UNSPSC WHERE Distribution.Ship_To_Org_FK_Key =Organization.Orga_Organization_PK_Key and Distribution.Buyer_FK_Key = Buyer.Asgn_Assignment_PK_Key and Distribution.Supplier_Site_FK_Key = Supplier.TPLO_TPartner_Loc_PK_Key and Distribution.Ship_Location_FK_Key = Geography.GLoc_Location_PK_Key and Distribution.PO_App_Date_FK_Key = Time.CDay_Cal_Day_PK_Key and Distribution.Item_FK_Key = Item.Irev_Item_Revision_PK_Key and Distribution.DUNS_FK_Key = DUNS.DNMR_DUNS_NUM_PK_Key and Distribution.UNSPSC_FK_Key = UNSPSC.Fnct_Function_PK_Key

View Text - HTML Formatted

SELECT ORGANIZATION.ALL_ALL_PK_KEY
, ORGANIZATION.OPER_OPERATING_UNIT_PK_KEY
, ORGANIZATION.ORGA_ORGANIZATION_PK_KEY
, ITEM.ALL_ALL_PK_KEY
, ITEM.CI11_CATEGORY_PK_KEY
, ITEM.ITEM_ITEM_NUMBER_PK_KEY
, SUPPLIER.ALL_ALL_PK_KEY
, SUPPLIER.PTP4_TPARTNER_PK_KEY
, SUPPLIER.TPRT_TRADE_PARTNER_PK_KEY
, SUPPLIER.TPLO_TPARTNER_LOC_PK_KEY
, BUYER.ALL_ALL_PK_KEY
, BUYER.ASGN_ASSIGNMENT_PK_KEY
, GEOGRAPHY.ALL_ALL_PK_KEY
, GEOGRAPHY.ARE1_AREA1_PK_KEY
, GEOGRAPHY.ARE2_AREA2_PK_KEY
, GEOGRAPHY.COUN_COUNTRY_PK_KEY
, GEOGRAPHY.REGN_REGION_PK_KEY
, GEOGRAPHY.STAT_STATE_PK_KEY
, TIME.ALL_ALL_PK_KEY
, TIME.ECYR_CAL_YEAR_PK_KEY
, TIME.ECQR_CAL_QTR_PK_KEY
, TIME.MNTH_MONTH_PK_KEY
, DUNS.ALL_ALL_PK_KEY
, DUNS.GLBL_GLOBAL_ULT_PK_KEY
, DUNS.DOME_DOMESTIC_ULT_PK_KEY
, DUNS.PRNT_PARENT_PK_KEY
, DUNS.HQTR_HQ_PK_KEY
, DUNS.DNMR_DUNS_NUM_PK_KEY
, UNSPSC.SGMT_SEGMENT_PK_KEY
, UNSPSC. FMLY_FAMILY_PK_KEY
, UNSPSC.CLAS_CLASS_PK_KEY
, UNSPSC.CMDT_COMMODITY_PK_KEY
, UNSPSC.FNCT_FUNCTION_PK_KEY
, UNSPSC.ALL_ALL_PK_KEY
, DISTRIBUTION.AMT_PURCHASED_G
, DISTRIBUTION.AMT_CONTRACT_G
, DISTRIBUTION.AMT_NONCONTRACT_G
, DISTRIBUTION.AMT_LEAKAGE_G
, DISTRIBUTION.POTENTIAL_SVG_G
, GREATEST(DISTRIBUTION.POTENTIAL_SVG_G
, 0)
, LEAST(DISTRIBUTION.POTENTIAL_SVG_G
, 0)
, DISTRIBUTION.PRICE_G
, DISTRIBUTION.PO_CREATION_CYCLE_TIME
FROM POA_EDW_PO_DIST_F DISTRIBUTION
, EDW_ORGANIZATION_M ORGANIZATION
, EDW_HR_PERSON_M BUYER
, EDW_TRD_PARTNER_M SUPPLIER
, EDW_GEOGRAPHY_M GEOGRAPHY
, EDW_TIME_M TIME
, EDW_ITEMS_M ITEM
, EDW_DUNS_M DUNS
, EDW_UNSPSC_M UNSPSC
WHERE DISTRIBUTION.SHIP_TO_ORG_FK_KEY =ORGANIZATION.ORGA_ORGANIZATION_PK_KEY
AND DISTRIBUTION.BUYER_FK_KEY = BUYER.ASGN_ASSIGNMENT_PK_KEY
AND DISTRIBUTION.SUPPLIER_SITE_FK_KEY = SUPPLIER.TPLO_TPARTNER_LOC_PK_KEY
AND DISTRIBUTION.SHIP_LOCATION_FK_KEY = GEOGRAPHY.GLOC_LOCATION_PK_KEY
AND DISTRIBUTION.PO_APP_DATE_FK_KEY = TIME.CDAY_CAL_DAY_PK_KEY
AND DISTRIBUTION.ITEM_FK_KEY = ITEM.IREV_ITEM_REVISION_PK_KEY
AND DISTRIBUTION.DUNS_FK_KEY = DUNS.DNMR_DUNS_NUM_PK_KEY
AND DISTRIBUTION.UNSPSC_FK_KEY = UNSPSC.FNCT_FUNCTION_PK_KEY