VIEW: APPS.PA_ALLOC_RUN_RULES_V

Source

View Text - Preformatted

SELECT distinct arn.rule_id ,arl.rule_name ,arl.description ,arn.run_period ,arn.org_id from pa_alloc_runs arn, pa_alloc_rules_all arl WHERE arn.rule_id = arl.rule_id

View Text - HTML Formatted

SELECT DISTINCT ARN.RULE_ID
, ARL.RULE_NAME
, ARL.DESCRIPTION
, ARN.RUN_PERIOD
, ARN.ORG_ID
FROM PA_ALLOC_RUNS ARN
, PA_ALLOC_RULES_ALL ARL
WHERE ARN.RULE_ID = ARL.RULE_ID