Product: | IGW - Grants Proposal (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RULES.RULE_NAME
, RULES.RULE_SEQUENCE_NUMBER
, RULES.RULE_TYPE
, RULES.VALID_FLAG
, RULES.START_DATE_ACTIVE
, RULES.END_DATE_ACTIVE
, RULES.RULE_ID
, RULES.ORGANIZATION_ID
, HR.NAME
, RULES.ORG_ID
, RULES.MAP_ID
, MPALL.DESCRIPTION
, RULES.LAST_UPDATE_DATE
, RULES.LAST_UPDATED_BY
, RULES.CREATION_DATE
, RULES.CREATED_BY
FROM IGW_BUSINESS_RULES_ALL RULES
, HR_ALL_ORGANIZATION_UNITS HR
, IGW_ORG_MAPS_ALL MPALL
WHERE RULES.MAP_ID = MPALL.MAP_ID
AND HR.ORGANIZATION_ID = RULES.ORGANIZATION_ID WITH READ ONLY