VIEW: APPS.POA_REP_AP_SPEND_V

Source

View Text - Preformatted

SELECT Organization.All_All_PK_Key, Organization.Oper_Operating_Unit_PK_Key, Organization.Orga_Organization_PK_Key, Supplier.All_All_PK_Key, Supplier.PTP4_TPartner_PK_Key, Supplier.TPRT_Trade_Partner_PK_Key, Supplier.TPLO_TPartner_Loc_PK_Key, Supplier.PTP4_Minority_Group, Supplier.PTP4_Women_Owned, Supplier.PTP4_Small_Business, 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, Inv.Inv_Line_Amt_G, Inv.Match_Line_Amt_G, Inv.Unmatch_Line_Amt_G from POA_FII_AP_Inv_Lines_F_V Inv, EDW_Organization_M Organization, EDW_TRD_Partner_M Supplier, EDW_HR_Person_M Buyer, EDW_Geography_M Geography, EDW_DUNS_M DUNS, EDW_Time_M Time WHERE Inv.Org_FK_Key = Organization.Orga_Organization_PK_Key and Inv.Supplier_FK_Key = Supplier.TPLO_TPartner_Loc_PK_Key and Inv.Employee_FK_Key = Buyer.Asgn_Assignment_PK_Key and Inv.Geography_FK_Key = Geography.GLoc_Location_PK_Key and Inv.Accounting_Date_FK_Key = Time.CDay_Cal_Day_PK_Key and Inv.DUNS_FK_Key = DUNS.DNMR_DUNS_NUM_PK_Key and Inv.Match_Status_Flag = 'A'

View Text - HTML Formatted

SELECT ORGANIZATION.ALL_ALL_PK_KEY
, ORGANIZATION.OPER_OPERATING_UNIT_PK_KEY
, ORGANIZATION.ORGA_ORGANIZATION_PK_KEY
, SUPPLIER.ALL_ALL_PK_KEY
, SUPPLIER.PTP4_TPARTNER_PK_KEY
, SUPPLIER.TPRT_TRADE_PARTNER_PK_KEY
, SUPPLIER.TPLO_TPARTNER_LOC_PK_KEY
, SUPPLIER.PTP4_MINORITY_GROUP
, SUPPLIER.PTP4_WOMEN_OWNED
, SUPPLIER.PTP4_SMALL_BUSINESS
, 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
, INV.INV_LINE_AMT_G
, INV.MATCH_LINE_AMT_G
, INV.UNMATCH_LINE_AMT_G
FROM POA_FII_AP_INV_LINES_F_V INV
, EDW_ORGANIZATION_M ORGANIZATION
, EDW_TRD_PARTNER_M SUPPLIER
, EDW_HR_PERSON_M BUYER
, EDW_GEOGRAPHY_M GEOGRAPHY
, EDW_DUNS_M DUNS
, EDW_TIME_M TIME
WHERE INV.ORG_FK_KEY = ORGANIZATION.ORGA_ORGANIZATION_PK_KEY
AND INV.SUPPLIER_FK_KEY = SUPPLIER.TPLO_TPARTNER_LOC_PK_KEY
AND INV.EMPLOYEE_FK_KEY = BUYER.ASGN_ASSIGNMENT_PK_KEY
AND INV.GEOGRAPHY_FK_KEY = GEOGRAPHY.GLOC_LOCATION_PK_KEY
AND INV.ACCOUNTING_DATE_FK_KEY = TIME.CDAY_CAL_DAY_PK_KEY
AND INV.DUNS_FK_KEY = DUNS.DNMR_DUNS_NUM_PK_KEY
AND INV.MATCH_STATUS_FLAG = 'A'