VIEW: APPS.IGS_FI_INVLN_INT_V

Source

View Text - Preformatted

SELECT FII.ROWID, FII.INVOICE_LINES_ID, FII.INVOICE_ID, FII.LINE_NUMBER, FII.S_CHG_METHOD_TYPE, FII.DESCRIPTION, FII.CHG_ELEMENTS, FII.AMOUNT, UOO.UNIT_CD, UOO.VERSION_NUMBER , FII.UNIT_ATTEMPT_STATUS, UOO.CAL_TYPE, UOO.CI_SEQUENCE_NUMBER, UOO.UNIT_CLASS, FII.EFTSU, FII.CREDIT_POINTS, FII.REC_ACCOUNT_CD, FII.REV_ACCOUNT_CD, FII.REC_GL_CCID, FII.REV_GL_CCID, FII.ORG_UNIT_CD, FII.POSTING_ID, FII.SOURCE_TRANSACTION_ID, FII.ATTRIBUTE_CATEGORY, FII.ATTRIBUTE1, FII.ATTRIBUTE2, FII.ATTRIBUTE3, FII.ATTRIBUTE4, FII.ATTRIBUTE5, FII.ATTRIBUTE6, FII.ATTRIBUTE7, FII.ATTRIBUTE8, FII.ATTRIBUTE9, FII.ATTRIBUTE10, FII.ATTRIBUTE11, FII.ATTRIBUTE12, FII.ATTRIBUTE13, FII.ATTRIBUTE14, FII.ATTRIBUTE15, FII.ATTRIBUTE16, FII.ATTRIBUTE17, FII.ATTRIBUTE18, FII.ATTRIBUTE19, FII.ATTRIBUTE20, FII.ORG_ID, FII.LAST_UPDATE_DATE, FII.LAST_UPDATED_BY, FII.CREATION_DATE, FII.CREATED_BY, FII.LAST_UPDATE_LOGIN, FII.REQUEST_ID, FII.PROGRAM_APPLICATION_ID, FII.PROGRAM_ID, FII.PROGRAM_UPDATE_DATE, FII.ERROR_STRING, FII.ERROR_ACCOUNT , FII.LOCATION_CD, FII.UOO_ID , FII.GL_DATE, FII.GL_POSTED_DATE, FII.POSTING_CONTROL_ID, FII.UNIT_TYPE_ID, PUT.LEVEL_CODE, FII.UNIT_LEVEL FROM IGS_FI_INVLN_INT FII , IGS_PS_UNIT_OFR_OPT UOO, IGS_PS_UNIT_TYPE_LVL PUT WHERE UOO.UOO_ID (+) = FII.UOO_ID AND FII.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)

View Text - HTML Formatted

SELECT FII.ROWID
, FII.INVOICE_LINES_ID
, FII.INVOICE_ID
, FII.LINE_NUMBER
, FII.S_CHG_METHOD_TYPE
, FII.DESCRIPTION
, FII.CHG_ELEMENTS
, FII.AMOUNT
, UOO.UNIT_CD
, UOO.VERSION_NUMBER
, FII.UNIT_ATTEMPT_STATUS
, UOO.CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER
, UOO.UNIT_CLASS
, FII.EFTSU
, FII.CREDIT_POINTS
, FII.REC_ACCOUNT_CD
, FII.REV_ACCOUNT_CD
, FII.REC_GL_CCID
, FII.REV_GL_CCID
, FII.ORG_UNIT_CD
, FII.POSTING_ID
, FII.SOURCE_TRANSACTION_ID
, FII.ATTRIBUTE_CATEGORY
, FII.ATTRIBUTE1
, FII.ATTRIBUTE2
, FII.ATTRIBUTE3
, FII.ATTRIBUTE4
, FII.ATTRIBUTE5
, FII.ATTRIBUTE6
, FII.ATTRIBUTE7
, FII.ATTRIBUTE8
, FII.ATTRIBUTE9
, FII.ATTRIBUTE10
, FII.ATTRIBUTE11
, FII.ATTRIBUTE12
, FII.ATTRIBUTE13
, FII.ATTRIBUTE14
, FII.ATTRIBUTE15
, FII.ATTRIBUTE16
, FII.ATTRIBUTE17
, FII.ATTRIBUTE18
, FII.ATTRIBUTE19
, FII.ATTRIBUTE20
, FII.ORG_ID
, FII.LAST_UPDATE_DATE
, FII.LAST_UPDATED_BY
, FII.CREATION_DATE
, FII.CREATED_BY
, FII.LAST_UPDATE_LOGIN
, FII.REQUEST_ID
, FII.PROGRAM_APPLICATION_ID
, FII.PROGRAM_ID
, FII.PROGRAM_UPDATE_DATE
, FII.ERROR_STRING
, FII.ERROR_ACCOUNT
, FII.LOCATION_CD
, FII.UOO_ID
, FII.GL_DATE
, FII.GL_POSTED_DATE
, FII.POSTING_CONTROL_ID
, FII.UNIT_TYPE_ID
, PUT.LEVEL_CODE
, FII.UNIT_LEVEL
FROM IGS_FI_INVLN_INT FII
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_UNIT_TYPE_LVL PUT
WHERE UOO.UOO_ID (+) = FII.UOO_ID
AND FII.UNIT_TYPE_ID = PUT.UNIT_TYPE_ID (+)