Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HZ_DSS_SECURED_CLASSES_V |
SELECT HDC.SECURED_ITEM_ID
, HDC.STATUS
, HDC.DSS_GROUP_CODE
, HDC.OWNER_TABLE_ID1 CLASS_CATEGORY
, CAT.MEANING CLASS_CATEGORY_NAME
, HDC.OWNER_TABLE_ID2 CLASS_CODE
, CC.MEANING CLASS_NAME
, CCD.CONCAT_CLASS_CODE
, CCD.CONCAT_CLASS_CODE_MEANING CONCAT_CLASS_NAME
, HDC.OBJECT_VERSION_NUMBER
, HDC.LAST_UPDATE_DATE
, HDC.LAST_UPDATED_BY
, HDC.CREATION_DATE
, HDC.CREATED_BY
, HDC.LAST_UPDATE_LOGIN
FROM HZ_DSS_CRITERIA HDC
, FND_LOOKUP_TYPES_TL CAT
, FND_LOOKUP_VALUES_VL CC
, HZ_CLASS_CODE_DENORM CCD
WHERE HDC.OWNER_TABLE_NAME = 'FND_LOOKUP_VALUES'
AND CAT.LOOKUP_TYPE = HDC.OWNER_TABLE_ID1
AND CAT.LANGUAGE = USERENV('LANG')
AND CC.LOOKUP_TYPE = HDC.OWNER_TABLE_ID1
AND CC.LOOKUP_CODE = HDC.OWNER_TABLE_ID2
AND CCD.CLASS_CATEGORY (+) = HDC.OWNER_TABLE_ID1
AND CCD.CLASS_CODE (+) = HDC.OWNER_TABLE_ID2
AND CCD.LANGUAGE (+) = USERENV('LANG')