Product: | OKL - Lease and Finance Management |
---|---|
Description: | Describes the presentation of invoice information |
Implementation/DBA Data: | APPS.OKL_INV_FORMATS_ALL_V |
SELECT INFB.ROWID
, INFB.ID
, INFB.OBJECT_VERSION_NUMBER
, INFT.SFWT_FLAG
, INFT.NAME
, INFT.DESCRIPTION
, INFB.CONTRACT_LEVEL_YN
, INFB.START_DATE
, INFB.END_DATE
, INFB.ILT_ID
, INFB.ORG_ID
, INFB.ATTRIBUTE_CATEGORY
, INFB.ATTRIBUTE1
, INFB.ATTRIBUTE2
, INFB.ATTRIBUTE3
, INFB.ATTRIBUTE4
, INFB.ATTRIBUTE5
, INFB.ATTRIBUTE6
, INFB.ATTRIBUTE7
, INFB.ATTRIBUTE8
, INFB.ATTRIBUTE9
, INFB.ATTRIBUTE10
, INFB.ATTRIBUTE11
, INFB.ATTRIBUTE12
, INFB.ATTRIBUTE13
, INFB.ATTRIBUTE14
, INFB.ATTRIBUTE15
, INFB.CREATED_BY
, INFB.CREATION_DATE
, INFB.LAST_UPDATED_BY
, INFB.LAST_UPDATE_DATE
, INFB.LAST_UPDATE_LOGIN
, OU.NAME OPERATING_UNIT
FROM OKL_INV_FORMATS_ALL_B INFB
, OKL_INVOICE_FORMATS_TL INFT
, HR_OPERATING_UNITS OU
WHERE INFB.ID = INFT.ID
AND INFT.LANGUAGE = USERENV('LANG')
AND OU.ORGANIZATION_ID= INFB.ORG_ID