View: PN_PAY_GROUP_BYS_V

Product:	PN - Property Manager
Description:	Stores Group By information.
Implementation/DBA Data:	APPS.PN_PAY_GROUP_BYS_V

View Text

SELECT GROUP_BY_ID
, GROUPING_RULE_ID
, GROUP_BY_LOOKUP_CODE
, LOOKUP.MEANING AS GROUP_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM PN_PAY_GROUP_BYS
, FND_LOOKUPS LOOKUP
WHERE LOOKUP.LOOKUP_TYPE = 'PN_PAY_GROUP_BY'
AND LOOKUP.LOOKUP_CODE = GROUP_BY_LOOKUP_CODE
AND LOOKUP.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(LOOKUP.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(LOOKUP.END_DATE_ACTIVE
, SYSDATE))

Columns