VIEW: APPS.IGI_RECOVERABLE_LINES

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)