VIEW: APPS.IGW_BUSINESS_RULES_V

Source

View Text - Preformatted

SELECT PBRA.ROWID ROW_ID, ORU.NAME ORGANIZATION, PBRA.RULE_ID RULE_ID, PBRA.RULE_SEQUENCE_NUMBER RULE_SEQUENCE_NUMBER, PBRA.ORGANIZATION_ID ORGANIZATION_ID, PBRA.ORG_ID ORG_ID, PBRA.RULE_NAME RULE_NAME, PBRA.RULE_TYPE RULE_TYPE, PBRA.MAP_ID MAP_ID, PBRA.VALID_FLAG VALID_FLAG, PBRA.START_DATE_ACTIVE START_DATE_ACTIVE, PBRA.END_DATE_ACTIVE END_DATE_ACTIVE, PBRA.LAST_UPDATE_DATE LAST_UPDATE_DATE, PBRA.CREATION_DATE CREATION_DATE, POMA.DESCRIPTION MAP, PBRA.LAST_UPDATED_BY LAST_UPDATED_BY, PBRA.CREATED_BY CREATED_BY, PBRA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGW_ORG_MAPS_ALL POMA ,IGW_BUSINESS_RULES PBRA ,HR_ALL_ORGANIZATION_UNITS ORU WHERE POMA.MAP_ID(+) = PBRA.MAP_ID AND ORU.ORGANIZATION_ID = PBRA.ORGANIZATION_ID

View Text - HTML Formatted

SELECT PBRA.ROWID ROW_ID
, ORU.NAME ORGANIZATION
, PBRA.RULE_ID RULE_ID
, PBRA.RULE_SEQUENCE_NUMBER RULE_SEQUENCE_NUMBER
, PBRA.ORGANIZATION_ID ORGANIZATION_ID
, PBRA.ORG_ID ORG_ID
, PBRA.RULE_NAME RULE_NAME
, PBRA.RULE_TYPE RULE_TYPE
, PBRA.MAP_ID MAP_ID
, PBRA.VALID_FLAG VALID_FLAG
, PBRA.START_DATE_ACTIVE START_DATE_ACTIVE
, PBRA.END_DATE_ACTIVE END_DATE_ACTIVE
, PBRA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PBRA.CREATION_DATE CREATION_DATE
, POMA.DESCRIPTION MAP
, PBRA.LAST_UPDATED_BY LAST_UPDATED_BY
, PBRA.CREATED_BY CREATED_BY
, PBRA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGW_ORG_MAPS_ALL POMA
, IGW_BUSINESS_RULES PBRA
, HR_ALL_ORGANIZATION_UNITS ORU
WHERE POMA.MAP_ID(+) = PBRA.MAP_ID
AND ORU.ORGANIZATION_ID = PBRA.ORGANIZATION_ID