DBA Data[Home] [Help]

VIEW: APPS.IGF_SE_PAYMENT_V

Source

View Text - Preformatted

SELECT SEP. ROWID ROW_ID, SEP. TRANSACTION_ID, SEP. PAYROLL_ID, SEP. PAYROLL_DATE, SEP. PERSON_ID, SEP. FUND_ID, SEP. AUTH_ID, NULL, NULL, NULL, NULL, NULL, SEP. PAID_AMOUNT, NULL, SEP. ORG_UNIT_CD, SEP.SOURCE, IGF_AW_GEN.LOOKUP_DESC('IGF_SE_SOURCE',SEP.SOURCE) SOURCE_DESCRIPTION, SEP. CREATED_BY, SEP. CREATION_DATE, SEP. LAST_UPDATED_BY, SEP. LAST_UPDATE_DATE, SEP. LAST_UPDATE_LOGIN, SEP.REQUEST_ID , SEP. PROGRAM_APPLICATION_ID, SEP.PROGRAM_ID , SEP. PROGRAM_UPDATE_DATE FROM IGF_SE_PAYMENT SEP
View Text - HTML Formatted

SELECT SEP. ROWID ROW_ID
, SEP. TRANSACTION_ID
, SEP. PAYROLL_ID
, SEP. PAYROLL_DATE
, SEP. PERSON_ID
, SEP. FUND_ID
, SEP. AUTH_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, SEP. PAID_AMOUNT
, NULL
, SEP. ORG_UNIT_CD
, SEP.SOURCE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SE_SOURCE'
, SEP.SOURCE) SOURCE_DESCRIPTION
, SEP. CREATED_BY
, SEP. CREATION_DATE
, SEP. LAST_UPDATED_BY
, SEP. LAST_UPDATE_DATE
, SEP. LAST_UPDATE_LOGIN
, SEP.REQUEST_ID
, SEP. PROGRAM_APPLICATION_ID
, SEP.PROGRAM_ID
, SEP. PROGRAM_UPDATE_DATE
FROM IGF_SE_PAYMENT SEP