VIEW: APPS.POA_FII_AP_HOLD_DATA_F_V

Source

View Text - Preformatted

SELECT FAF.SUPPLIER_FK_KEY,FAF.HOLD_DATE_FK_KEY,FAF.SIC_CODE_FK_KEY,FAF.DUNS_FK_KEY,FAF.RELEASE_FK_KEY,FAF.ORG_FK_KEY,FAF.INV_FK_KEY,FAF.INV_SOURCE_FK_KEY,FAF.INSTANCE_FK_KEY,FAF.HOLD_BY_EMPLOYEE_FK_KEY,FAF.HOLD_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.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.SUPPLIER_SITE_ID,FAF.INV_AMT_T,FAF.INV_AMT_G,FAF.INV_AMT_B,FAF.HOLD_DATA_PK_KEY,FAF.HOLD_COUNT,FAF.HELD_BY,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.RELEASE_REASON,FAF.RELEASE_LOOKUP_CODE,FAF.INV_TYPE,FAF.INV_SOURCE,FAF.INV_NUM,FAF.INSTANCE,FAF.HOLD_REASON,FAF.HOLD_LOOKUP_CODE,FAF.HOLD_DATA_PK,FAF.LAST_UPDATE_DATE,FAF.CREATION_DATE,FAF.HOLD_DATE,FAF.HOLD_RELEASE_COUNT,FAF.HOLD_RELEASE_DAYS FROM FII_AP_HOLD_DATA_F FAF WHERE (inv_type <> 'EXPENSE REPORT' or inv_type is null)

View Text - HTML Formatted

SELECT FAF.SUPPLIER_FK_KEY
, FAF.HOLD_DATE_FK_KEY
, FAF.SIC_CODE_FK_KEY
, FAF.DUNS_FK_KEY
, FAF.RELEASE_FK_KEY
, FAF.ORG_FK_KEY
, FAF.INV_FK_KEY
, FAF.INV_SOURCE_FK_KEY
, FAF.INSTANCE_FK_KEY
, FAF.HOLD_BY_EMPLOYEE_FK_KEY
, FAF.HOLD_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.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.SUPPLIER_SITE_ID
, FAF.INV_AMT_T
, FAF.INV_AMT_G
, FAF.INV_AMT_B
, FAF.HOLD_DATA_PK_KEY
, FAF.HOLD_COUNT
, FAF.HELD_BY
, 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.RELEASE_REASON
, FAF.RELEASE_LOOKUP_CODE
, FAF.INV_TYPE
, FAF.INV_SOURCE
, FAF.INV_NUM
, FAF.INSTANCE
, FAF.HOLD_REASON
, FAF.HOLD_LOOKUP_CODE
, FAF.HOLD_DATA_PK
, FAF.LAST_UPDATE_DATE
, FAF.CREATION_DATE
, FAF.HOLD_DATE
, FAF.HOLD_RELEASE_COUNT
, FAF.HOLD_RELEASE_DAYS
FROM FII_AP_HOLD_DATA_F FAF
WHERE (INV_TYPE <> 'EXPENSE REPORT' OR INV_TYPE IS NULL)