VIEW: APPS.POA_FII_AP_SCH_PAYMTS_F_V

Source

View Text - Preformatted

SELECT FAF.SUPPLIER_FK_KEY,FAF.DUE_DATE_FK_KEY,FAF.DISC_DATE_FK_KEY,FAF.INV_DATE_FK_KEY,FAF.SIC_CODE_FK_KEY,FAF.DUNS_FK_KEY,FAF.ORG_FK_KEY,FAF.INV_FK_KEY,FAF.INV_SOURCE_FK_KEY,FAF.INSTANCE_FK_KEY,FAF.EMPLOYEE_FK_KEY,FAF.GL_ACCT9_FK_KEY,FAF.GL_ACCT8_FK_KEY,FAF.GL_ACCT7_FK_KEY,FAF.GL_ACCT6_FK_KEY,FAF.GL_ACCT5_FK_KEY,FAF.GL_ACCT4_FK_KEY,FAF.GL_ACCT3_FK_KEY,FAF.GL_ACCT2_FK_KEY,FAF.GL_ACCT1_FK_KEY,FAF.GL_ACCT10_FK_KEY,FAF.SOB_FK_KEY,FAF.GEOGRAPHY_FK_KEY,FAF.PAYMENT_CURRENCY_FK_KEY,FAF.INV_CURRENCY_FK_KEY,FAF.PAYMENT_TERM_FK_KEY,FAF.USER_MEASURE5,FAF.USER_MEASURE4,FAF.USER_MEASURE3,FAF.USER_MEASURE2,FAF.USER_MEASURE1,FAF.USER_FK5_KEY,FAF.USER_FK4_KEY,FAF.USER_FK3_KEY,FAF.USER_FK2_KEY,FAF.USER_FK1_KEY,FAF.UNPAID_PAYMENT_COUNT,FAF.THIRD_DISC_AVAILABLE_T,FAF.THIRD_DISC_AVAILABLE_G,FAF.THIRD_DISC_AVAILABLE_B,FAF.SECOND_DISC_AVAILABLE_T,FAF.SECOND_DISC_AVAILABLE_G,FAF.SECOND_DISC_AVAILABLE_B,FAF.SCH_PAYMENT_PK_KEY,FAF.REMAINING_INV_AMT_AT_RISK_T,FAF.REMAINING_INV_AMT_AT_RISK_G,FAF.REMAINING_INV_AMT_AT_RISK_B,FAF.REMAINING_DISC_AMT_AT_RISK_T,FAF.REMAINING_DISC_AMT_AT_RISK_G,FAF.REMAINING_DISC_AMT_AT_RISK_B,FAF.POTENTIAL_DISC_T,FAF.POTENTIAL_DISC_G,FAF.POTENTIAL_DISC_B,FAF.PAYMENT_PRIORITY,FAF.PAYMENT_EXCHANGE_RATE,FAF.PAYMENT_AMT_T,FAF.PAYMENT_AMT_G,FAF.PAYMENT_AMT_B,FAF.PARTIALLY_PAID_PAYMENT_COUNT,FAF.INV_EXCHANGE_RATE,FAF.INV_AMT_NOT_HAVING_DISC_T,FAF.INV_AMT_NOT_HAVING_DISC_G,FAF.INV_AMT_NOT_HAVING_DISC_B,FAF.INV_AMT_HAVING_DISC_T,FAF.INV_AMT_HAVING_DISC_G,FAF.INV_AMT_HAVING_DISC_B,FAF.FIRST_DISC_AVAILABLE_T,FAF.FIRST_DISC_AVAILABLE_G,FAF.FIRST_DISC_AVAILABLE_B,FAF.DISC_AMT_TAKEN_T,FAF.DISC_AMT_TAKEN_G,FAF.DISC_AMT_TAKEN_B,FAF.DISC_AMT_LOST_T,FAF.DISC_AMT_LOST_G,FAF.DISC_AMT_LOST_B,FAF.COMPLETELY_PAID_PAYMENT_COUNT,FAF.CCID,FAF.USER_ATTRIBUTE9,FAF.USER_ATTRIBUTE8,FAF.USER_ATTRIBUTE7,FAF.USER_ATTRIBUTE6,FAF.USER_ATTRIBUTE5,FAF.USER_ATTRIBUTE4,FAF.USER_ATTRIBUTE3,FAF.USER_ATTRIBUTE2,FAF.USER_ATTRIBUTE15,FAF.USER_ATTRIBUTE14,FAF.USER_ATTRIBUTE13,FAF.USER_ATTRIBUTE12,FAF.USER_ATTRIBUTE11,FAF.USER_ATTRIBUTE10,FAF.USER_ATTRIBUTE1,FAF.SCH_PAYMENT_PK,FAF.PAYMENT_STATUS_FLAG,FAF.PAYMENT_METHOD,FAF.PAYMENT_EXCHANGE_RATE_TYPE,FAF.INV_EXCHANGE_RATE_TYPE,FAF.HOLD_FLAG,FAF.THIRD_DISC_DATE,FAF.SECOND_DISC_DATE,FAF.PAYMENT_EXCHANGE_DATE,FAF.LAST_UPDATE_DATE,FAF.INV_EXCHANGE_DATE,FAF.FIRST_DISC_DATE,FAF.DUE_DATE,FAF.CREATION_DATE,FAF.INVOICE_NUM,FAF.INSTANCE,FAF.REMAINING_INV_AMT_B,FAF.REMAINING_INV_AMT_G,FAF.REMAINING_INV_AMT_T FROM EDW_INV_TYPE_M EIM,FII_AP_SCH_PAYMTS_F FAF WHERE faf.inv_fk_key = eim.invc_inv_pk_key and (eim.ivty_inv_type <> 'Expense Report' or eim.ivty_inv_type is null)

View Text - HTML Formatted

SELECT FAF.SUPPLIER_FK_KEY
, FAF.DUE_DATE_FK_KEY
, FAF.DISC_DATE_FK_KEY
, FAF.INV_DATE_FK_KEY
, FAF.SIC_CODE_FK_KEY
, FAF.DUNS_FK_KEY
, FAF.ORG_FK_KEY
, FAF.INV_FK_KEY
, FAF.INV_SOURCE_FK_KEY
, FAF.INSTANCE_FK_KEY
, FAF.EMPLOYEE_FK_KEY
, FAF.GL_ACCT9_FK_KEY
, FAF.GL_ACCT8_FK_KEY
, FAF.GL_ACCT7_FK_KEY
, FAF.GL_ACCT6_FK_KEY
, FAF.GL_ACCT5_FK_KEY
, FAF.GL_ACCT4_FK_KEY
, FAF.GL_ACCT3_FK_KEY
, FAF.GL_ACCT2_FK_KEY
, FAF.GL_ACCT1_FK_KEY
, FAF.GL_ACCT10_FK_KEY
, FAF.SOB_FK_KEY
, FAF.GEOGRAPHY_FK_KEY
, FAF.PAYMENT_CURRENCY_FK_KEY
, FAF.INV_CURRENCY_FK_KEY
, FAF.PAYMENT_TERM_FK_KEY
, FAF.USER_MEASURE5
, FAF.USER_MEASURE4
, FAF.USER_MEASURE3
, FAF.USER_MEASURE2
, FAF.USER_MEASURE1
, FAF.USER_FK5_KEY
, FAF.USER_FK4_KEY
, FAF.USER_FK3_KEY
, FAF.USER_FK2_KEY
, FAF.USER_FK1_KEY
, FAF.UNPAID_PAYMENT_COUNT
, FAF.THIRD_DISC_AVAILABLE_T
, FAF.THIRD_DISC_AVAILABLE_G
, FAF.THIRD_DISC_AVAILABLE_B
, FAF.SECOND_DISC_AVAILABLE_T
, FAF.SECOND_DISC_AVAILABLE_G
, FAF.SECOND_DISC_AVAILABLE_B
, FAF.SCH_PAYMENT_PK_KEY
, FAF.REMAINING_INV_AMT_AT_RISK_T
, FAF.REMAINING_INV_AMT_AT_RISK_G
, FAF.REMAINING_INV_AMT_AT_RISK_B
, FAF.REMAINING_DISC_AMT_AT_RISK_T
, FAF.REMAINING_DISC_AMT_AT_RISK_G
, FAF.REMAINING_DISC_AMT_AT_RISK_B
, FAF.POTENTIAL_DISC_T
, FAF.POTENTIAL_DISC_G
, FAF.POTENTIAL_DISC_B
, FAF.PAYMENT_PRIORITY
, FAF.PAYMENT_EXCHANGE_RATE
, FAF.PAYMENT_AMT_T
, FAF.PAYMENT_AMT_G
, FAF.PAYMENT_AMT_B
, FAF.PARTIALLY_PAID_PAYMENT_COUNT
, FAF.INV_EXCHANGE_RATE
, FAF.INV_AMT_NOT_HAVING_DISC_T
, FAF.INV_AMT_NOT_HAVING_DISC_G
, FAF.INV_AMT_NOT_HAVING_DISC_B
, FAF.INV_AMT_HAVING_DISC_T
, FAF.INV_AMT_HAVING_DISC_G
, FAF.INV_AMT_HAVING_DISC_B
, FAF.FIRST_DISC_AVAILABLE_T
, FAF.FIRST_DISC_AVAILABLE_G
, FAF.FIRST_DISC_AVAILABLE_B
, FAF.DISC_AMT_TAKEN_T
, FAF.DISC_AMT_TAKEN_G
, FAF.DISC_AMT_TAKEN_B
, FAF.DISC_AMT_LOST_T
, FAF.DISC_AMT_LOST_G
, FAF.DISC_AMT_LOST_B
, FAF.COMPLETELY_PAID_PAYMENT_COUNT
, FAF.CCID
, FAF.USER_ATTRIBUTE9
, FAF.USER_ATTRIBUTE8
, FAF.USER_ATTRIBUTE7
, FAF.USER_ATTRIBUTE6
, FAF.USER_ATTRIBUTE5
, FAF.USER_ATTRIBUTE4
, FAF.USER_ATTRIBUTE3
, FAF.USER_ATTRIBUTE2
, FAF.USER_ATTRIBUTE15
, FAF.USER_ATTRIBUTE14
, FAF.USER_ATTRIBUTE13
, FAF.USER_ATTRIBUTE12
, FAF.USER_ATTRIBUTE11
, FAF.USER_ATTRIBUTE10
, FAF.USER_ATTRIBUTE1
, FAF.SCH_PAYMENT_PK
, FAF.PAYMENT_STATUS_FLAG
, FAF.PAYMENT_METHOD
, FAF.PAYMENT_EXCHANGE_RATE_TYPE
, FAF.INV_EXCHANGE_RATE_TYPE
, FAF.HOLD_FLAG
, FAF.THIRD_DISC_DATE
, FAF.SECOND_DISC_DATE
, FAF.PAYMENT_EXCHANGE_DATE
, FAF.LAST_UPDATE_DATE
, FAF.INV_EXCHANGE_DATE
, FAF.FIRST_DISC_DATE
, FAF.DUE_DATE
, FAF.CREATION_DATE
, FAF.INVOICE_NUM
, FAF.INSTANCE
, FAF.REMAINING_INV_AMT_B
, FAF.REMAINING_INV_AMT_G
, FAF.REMAINING_INV_AMT_T
FROM EDW_INV_TYPE_M EIM
, FII_AP_SCH_PAYMTS_F FAF
WHERE FAF.INV_FK_KEY = EIM.INVC_INV_PK_KEY
AND (EIM.IVTY_INV_TYPE <> 'EXPENSE REPORT' OR EIM.IVTY_INV_TYPE IS NULL)