View: IGI_RECOVERABLE_LINES

Product:	IGI - Public Sector Financials International
Description:	MultiOrg View
Implementation/DBA Data:	APPS.IGI_RECOVERABLE_LINES

View Text

SELECT IRL.INVOICE_ID
, IRL.ACCOUNTING_DATE
, IRL.INVOICE_DATE
, IRL.INV_CURRENCY_CODE
, IRL.ACCRUAL_SET_OF_BOOKS_ID
, IRL.REQUEST_ID
, IRL.TAX_DISTRIBUTION_ID
, IRL.TAX_CCID
, IRL.TAX_AMOUNT
, IRL.ITEM_DISTRIBUTION_ID
, IRL.ITEM_CCID
, IRL.LAST_UPDATED_BY
, IRL.LAST_UPDATE_DATE
, IRL.CREATED_BY
, IRL.CREATED_DATE
, IRL.ORG_ID
, IRL.LAST_UPDATE_LOGIN
, IRL.JE_CREATED_FLAG
FROM IGI_RECOVERABLE_LINES_ALL IRL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns