Product: | IGI - Public Sector Financials International |
---|---|
Description: | Holds letter set information for the letter sets form |
Implementation/DBA Data: | APPS.IGI_DUN_LETTER_SET_LINES_V |
SELECT IDLSL.ROWID ROW_ID
, IDLSL.DUNNING_LETTER_SET_ID
, IDLSL.DUNNING_LINE_NUM
, IDLSL.CURRENCY_CODE
, IDLSL.DUNNING_LETTER_ID
, ARDL.LETTER_NAME
, IDLSL.LETTER_CHARGE_AMOUNT
, IDLSL.INVOICE_CHARGE_AMOUNT
, IDLSL.CREATED_BY
, IDLSL.CREATION_DATE
, IDLSL.LAST_UPDATED_BY
, IDLSL.LAST_UPDATE_DATE
, IDLSL.LAST_UPDATE_LOGIN
FROM AR_DUNNING_LETTERS_VL ARDL
, IGI_DUN_LETTER_SET_LINES IDLSL
WHERE IDLSL.DUNNING_LETTER_ID = ARDL.DUNNING_LETTER_ID