VIEW: APPS.IGS_FI_UNPOSTED_TRANSACTIONS

Source

View Text - Preformatted

SELECT GL_DATE, REC_ACCOUNT_CD, REC_GL_CCID, AMOUNT, 'DR' FROM IGS_FI_INVLN_INT WHERE ((POSTING_ID IS NULL) AND (POSTING_CONTROL_ID IS NULL)) AND IGS_FI_GEN_005.FINP_GET_ACCT_METH = 'ACCRUAL' AND GL_DATE IS NOT NULL AND ERROR_ACCOUNT <> 'Y' UNION ALL SELECT GL_DATE, REV_ACCOUNT_CD, REV_GL_CCID, AMOUNT, 'CR' FROM IGS_FI_INVLN_INT WHERE ((POSTING_ID IS NULL) AND (POSTING_CONTROL_ID IS NULL)) AND IGS_FI_GEN_005.FINP_GET_ACCT_METH = 'ACCRUAL' AND GL_DATE IS NOT NULL AND ERROR_ACCOUNT <> 'Y' UNION ALL SELECT GL_DATE, DR_ACCOUNT_CD, DR_GL_CCID, AMOUNT, 'DR' FROM IGS_FI_CR_ACTIVITIES WHERE GL_DATE IS NOT NULL AND ((DR_GL_CCID IS NOT NULL) OR (DR_ACCOUNT_CD IS NOT NULL)) AND ((POSTING_ID IS NULL) AND (POSTING_CONTROL_ID IS NULL)) UNION ALL SELECT GL_DATE, CR_ACCOUNT_CD, CR_GL_CCID, AMOUNT, 'CR' FROM IGS_FI_CR_ACTIVITIES WHERE GL_DATE IS NOT NULL AND ((CR_GL_CCID IS NOT NULL) OR (CR_ACCOUNT_CD IS NOT NULL)) AND ((POSTING_ID IS NULL) AND (POSTING_CONTROL_ID IS NULL)) UNION ALL SELECT GL_DATE, DR_ACCOUNT_CD, DR_GL_CODE_CCID, AMOUNT_APPLIED, 'DR' FROM IGS_FI_APPLICATIONS WHERE ((POSTING_ID IS NULL) AND (POSTING_CONTROL_ID IS NULL)) AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE, CR_ACCOUNT_CD, CR_GL_CODE_CCID, AMOUNT_APPLIED, 'CR' FROM IGS_FI_APPLICATIONS WHERE ((POSTING_ID IS NULL) AND (POSTING_CONTROL_ID IS NULL)) AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE, CASH_ACCOUNT_CD, CASH_GL_CCID, FEE_AMOUNT, 'DR' FROM IGS_AD_APP_REQ WHERE ((POSTING_CONTROL_ID IS NULL) AND (GL_POSTED_DATE IS NULL)) AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE, REV_ACCOUNT_CD, REV_GL_CCID, FEE_AMOUNT, 'CR' FROM IGS_AD_APP_REQ WHERE ((POSTING_CONTROL_ID IS NULL) AND (GL_POSTED_DATE IS NULL)) AND GL_DATE IS NOT NULL

View Text - HTML Formatted

SELECT GL_DATE
, REC_ACCOUNT_CD
, REC_GL_CCID
, AMOUNT
, 'DR'
FROM IGS_FI_INVLN_INT
WHERE ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL))
AND IGS_FI_GEN_005.FINP_GET_ACCT_METH = 'ACCRUAL'
AND GL_DATE IS NOT NULL
AND ERROR_ACCOUNT <> 'Y' UNION ALL SELECT GL_DATE
, REV_ACCOUNT_CD
, REV_GL_CCID
, AMOUNT
, 'CR'
FROM IGS_FI_INVLN_INT
WHERE ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL))
AND IGS_FI_GEN_005.FINP_GET_ACCT_METH = 'ACCRUAL'
AND GL_DATE IS NOT NULL
AND ERROR_ACCOUNT <> 'Y' UNION ALL SELECT GL_DATE
, DR_ACCOUNT_CD
, DR_GL_CCID
, AMOUNT
, 'DR'
FROM IGS_FI_CR_ACTIVITIES
WHERE GL_DATE IS NOT NULL
AND ((DR_GL_CCID IS NOT NULL) OR (DR_ACCOUNT_CD IS NOT NULL))
AND ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL)) UNION ALL SELECT GL_DATE
, CR_ACCOUNT_CD
, CR_GL_CCID
, AMOUNT
, 'CR'
FROM IGS_FI_CR_ACTIVITIES
WHERE GL_DATE IS NOT NULL
AND ((CR_GL_CCID IS NOT NULL) OR (CR_ACCOUNT_CD IS NOT NULL))
AND ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL)) UNION ALL SELECT GL_DATE
, DR_ACCOUNT_CD
, DR_GL_CODE_CCID
, AMOUNT_APPLIED
, 'DR'
FROM IGS_FI_APPLICATIONS
WHERE ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL))
AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE
, CR_ACCOUNT_CD
, CR_GL_CODE_CCID
, AMOUNT_APPLIED
, 'CR'
FROM IGS_FI_APPLICATIONS
WHERE ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL))
AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE
, CASH_ACCOUNT_CD
, CASH_GL_CCID
, FEE_AMOUNT
, 'DR'
FROM IGS_AD_APP_REQ
WHERE ((POSTING_CONTROL_ID IS NULL)
AND (GL_POSTED_DATE IS NULL))
AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE
, REV_ACCOUNT_CD
, REV_GL_CCID
, FEE_AMOUNT
, 'CR'
FROM IGS_AD_APP_REQ
WHERE ((POSTING_CONTROL_ID IS NULL)
AND (GL_POSTED_DATE IS NULL))
AND GL_DATE IS NOT NULL