DBA Data[Home] [Help]

VIEW: APPS.POA_REP_DIS_LOST1

Source

View Text - Preformatted

SELECT Organization.Oper_Operating_Unit_PK_Key, Time.Mnth_Month_PK_Key, sum(SPay.Disc_Amt_Lost_G)/sum(SPay.Potential_Disc_G) * 100 from fii_ap_sch_paymts_f SPay, EDW_Organization_M Organization, EDW_Time_M Time WHERE SPay.Org_FK_Key = Organization.Orga_Organization_PK_Key and SPay.Disc_Date_FK_Key = Time.CDay_Cal_Day_PK_Key group by Organization.Oper_Operating_Unit_PK_Key, Time.Mnth_Month_PK_Key
View Text - HTML Formatted

SELECT ORGANIZATION.OPER_OPERATING_UNIT_PK_KEY
, TIME.MNTH_MONTH_PK_KEY
, SUM(SPAY.DISC_AMT_LOST_G)/SUM(SPAY.POTENTIAL_DISC_G) * 100
FROM FII_AP_SCH_PAYMTS_F SPAY
, EDW_ORGANIZATION_M ORGANIZATION
, EDW_TIME_M TIME
WHERE SPAY.ORG_FK_KEY = ORGANIZATION.ORGA_ORGANIZATION_PK_KEY
AND SPAY.DISC_DATE_FK_KEY = TIME.CDAY_CAL_DAY_PK_KEY GROUP BY ORGANIZATION.OPER_OPERATING_UNIT_PK_KEY
, TIME.MNTH_MONTH_PK_KEY