View: IGI_DUN_CUSTOMER_PROFILE_V

Product:	IGI - Public Sector Financials International
Description:	Holds information about Dunning customer profiles
Implementation/DBA Data:	APPS.IGI_DUN_CUSTOMER_PROFILE_V

View Text

SELECT IDCP.ROWID ROW_ID
, ARV.CUSTOMER_ID
, ARV.CUSTOMER_NAME
, ARSU.SITE_USE_ID
, ADDR2.CONCATENATED_ADDRESS
, DECODE( ARCP.CUSTOMER_PROFILE_ID
, NULL
, ARCP2.DUNNING_LETTER_SET_ID
, ARCP.DUNNING_LETTER_SET_ID)
, ARDL.NAME DUNNING_LETTER_SET_NAME
, DECODE( ARCP.CUSTOMER_PROFILE_ID
, NULL
, ARCP2.CUSTOMER_PROFILE_ID
, ARCP.CUSTOMER_PROFILE_ID)
, IDCP.USE_DUNNING_FLAG
, IDCP.DUNNING_CHARGE_TYPE
, DECODE( ARCP.CUSTOMER_PROFILE_ID
, NULL
, ARCP2.DUNNING_LETTERS
, ARCP.DUNNING_LETTERS)
, IDCP.CREATED_BY
, IDCP.CREATION_DATE
, IDCP.LAST_UPDATED_BY
, IDCP.LAST_UPDATE_DATE
, IDCP.LAST_UPDATE_LOGIN
, ARSU.ADDRESS_ID
, DECODE( ARCP.CUSTOMER_PROFILE_ID
, NULL
, ARCP2.CUSTOMER_PROFILE_CLASS_ID
, ARCP.CUSTOMER_PROFILE_CLASS_ID)
FROM RA_HCUSTOMERS ARV
, AR_ADDRESSES_V ADDR2
, RA_SITE_USES ARSU
, AR_HCUSTOMER_PROFILES ARCP
, AR_HCUSTOMER_PROFILES ARCP2
, AR_DUNNING_LETTER_SETS ARDL
, IGI_DUN_CUST_PROF IDCP
WHERE ARV.CUSTOMER_ID = ADDR2.CUSTOMER_ID
AND ARSU.ADDRESS_ID = ADDR2.ADDRESS_ID
AND ARSU.SITE_USE_CODE = 'BILL_TO'
AND ARCP.SITE_USE_ID(+) = ARSU.SITE_USE_ID
AND ADDR2.CUSTOMER_ID = ARCP2.CUSTOMER_ID
AND ARCP2.SITE_USE_ID IS NULL
AND DECODE(ARCP.CUSTOMER_PROFILE_ID
, NULL
, ARCP2.DUNNING_LETTER_SET_ID
, ARCP.DUNNING_LETTER_SET_ID) IS NOT NULL
AND DECODE(ARCP.CUSTOMER_PROFILE_ID
, NULL
, ARCP2.DUNNING_LETTERS
, ARCP.DUNNING_LETTERS) = 'Y'
AND DECODE(ARCP.CUSTOMER_PROFILE_ID
, NULL
, ARCP2.DUNNING_LETTER_SET_ID
, ARCP.DUNNING_LETTER_SET_ID) = ARDL.DUNNING_LETTER_SET_ID
AND DECODE(ARCP.CUSTOMER_PROFILE_ID
, NULL
, ARCP2.CUSTOMER_PROFILE_ID
, ARCP.CUSTOMER_PROFILE_ID) = IDCP.CUSTOMER_PROFILE_ID ORDER BY ARV.CUSTOMER_NAME

Columns