View: IGI_DUN_CUST_PROFILE_CLASS_V

Product:	IGI - Public Sector Financials International
Description:	Holds information for Dunning customer profile classes
Implementation/DBA Data:	APPS.IGI_DUN_CUST_PROFILE_CLASS_V

View Text

SELECT IDCP.ROWID ROW_ID
, IDCP.CUSTOMER_PROFILE_CLASS_ID
, ARCP.NAME PROFILE_CLASS_NAME
, ARCP.DESCRIPTION PROFILE_CLASS_DESCRIPTION
, ARCP.STATUS
, ARCP.DUNNING_LETTER_SET_ID
, ARDL.NAME DUNNING_LETTER_SET_NAME
, IDCP.USE_DUNNING_FLAG
, IDCP.DUNNING_CHARGE_TYPE
, IGIL.MEANING DUNNING_CHARGE_TYPE_DESC
, ARCP.DUNNING_LETTERS
, IDCP.CREATED_BY
, IDCP.CREATION_DATE
, IDCP.LAST_UPDATED_BY
, IDCP.LAST_UPDATE_DATE
, IDCP.LAST_UPDATE_LOGIN
FROM AR_DUNNING_LETTER_SETS ARDL
, AR_HCUSTOMER_PROFILE_CLASSES ARCP
, IGI_DUN_CUST_PROF_CLASS IDCP
, IGI_LOOKUPS IGIL
WHERE ARCP.CUSTOMER_PROFILE_CLASS_ID = IDCP.CUSTOMER_PROFILE_CLASS_ID
AND IDCP.DUNNING_CHARGE_TYPE = IGIL.LOOKUP_CODE
AND IGIL.LOOKUP_TYPE = 'DUNNING_CHARGE_TYPE'
AND ARCP.DUNNING_LETTER_SET_ID = ARDL.DUNNING_LETTER_SET_ID (+)
AND ARCP.DUNNING_LETTERS = 'Y'
AND ARCP.DUNNING_LETTER_SET_ID IS NOT NULL ORDER BY ARCP.NAME

Columns