VIEW: APPS.POA_PMF_MIN_VIEW_SP

Source

View Text - Preformatted

SELECT Organization.All_All_PK_Key, Time.ECQR_CAL_QTR_PK_KEY, DECODE(Supplier.PTP4_Women_Owned, 'Y',Inv.Match_Line_Amt_G + Inv.Unmatch_Line_Amt_G,0), DECODE(Supplier.PTP4_Minority_Group, 'Y',Inv.Match_Line_Amt_G + Inv.Unmatch_Line_Amt_G,0), DECODE(Supplier.PTP4_Small_Business, 'Y',Inv.Match_Line_Amt_G + Inv.Unmatch_Line_Amt_G,0), DECODE(Supplier.PTP4_Women_Owned, 'Y',Inv.Match_Line_Amt_G + Inv.Unmatch_Line_Amt_G, DECODE(Supplier.PTP4_Minority_Group, 'Y',Inv.Match_Line_Amt_G + Inv.Unmatch_Line_Amt_G, DECODE(Supplier.PTP4_Small_Business, 'Y',Inv.Match_Line_Amt_G + Inv.Unmatch_Line_Amt_G,0))), 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_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.Supplier_FK_Key = Supplier.TPLO_TPartner_Loc_PK_Key

View Text - HTML Formatted

SELECT ORGANIZATION.ALL_ALL_PK_KEY
, TIME.ECQR_CAL_QTR_PK_KEY
, DECODE(SUPPLIER.PTP4_WOMEN_OWNED
, 'Y'
, INV.MATCH_LINE_AMT_G + INV.UNMATCH_LINE_AMT_G
, 0)
, DECODE(SUPPLIER.PTP4_MINORITY_GROUP
, 'Y'
, INV.MATCH_LINE_AMT_G + INV.UNMATCH_LINE_AMT_G
, 0)
, DECODE(SUPPLIER.PTP4_SMALL_BUSINESS
, 'Y'
, INV.MATCH_LINE_AMT_G + INV.UNMATCH_LINE_AMT_G
, 0)
, DECODE(SUPPLIER.PTP4_WOMEN_OWNED
, 'Y'
, INV.MATCH_LINE_AMT_G + INV.UNMATCH_LINE_AMT_G
, DECODE(SUPPLIER.PTP4_MINORITY_GROUP
, 'Y'
, INV.MATCH_LINE_AMT_G + INV.UNMATCH_LINE_AMT_G
, DECODE(SUPPLIER.PTP4_SMALL_BUSINESS
, 'Y'
, INV.MATCH_LINE_AMT_G + INV.UNMATCH_LINE_AMT_G
, 0)))
, 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_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.SUPPLIER_FK_KEY = SUPPLIER.TPLO_TPARTNER_LOC_PK_KEY