VIEW: APPS.POA_REP_AP_LKG2

Source

View Text - Preformatted

SELECT Organization.All_All_PK_Key, Time.Mnth_Month_PK_Key, sum(Inv.Unmatch_Line_Amt_G)/ (sum(Inv.Unmatch_Line_Amt_G + Inv.Match_Line_Amt_G))* 100 from POA_FII_AP_Inv_Lines_F_V Inv, EDW_Organization_M Organization, EDW_Time_M Time WHERE Inv.Org_FK_Key = Organization.Orga_Organization_PK_Key and Inv.Accounting_Date_FK_Key = Time.CDay_Cal_Day_PK_Key and Inv.Match_Status_Flag = 'A' group by Organization.All_All_PK_Key, Time.Mnth_Month_PK_Key

View Text - HTML Formatted

SELECT ORGANIZATION.ALL_ALL_PK_KEY
, TIME.MNTH_MONTH_PK_KEY
, SUM(INV.UNMATCH_LINE_AMT_G)/ (SUM(INV.UNMATCH_LINE_AMT_G + INV.MATCH_LINE_AMT_G))* 100
FROM POA_FII_AP_INV_LINES_F_V INV
, EDW_ORGANIZATION_M ORGANIZATION
, EDW_TIME_M TIME
WHERE INV.ORG_FK_KEY = ORGANIZATION.ORGA_ORGANIZATION_PK_KEY
AND INV.ACCOUNTING_DATE_FK_KEY = TIME.CDAY_CAL_DAY_PK_KEY
AND INV.MATCH_STATUS_FLAG = 'A' GROUP BY ORGANIZATION.ALL_ALL_PK_KEY
, TIME.MNTH_MONTH_PK_KEY