When we open a form, some values are pre-loaded in some dynamic variables like Person_id , organization_id, user_id etc.
We can use these values to limit the results.
Let me show you an example...its an easy one.
I will show employee date of birth in a form filed based on its Person id loaded in $PROFILES$.Value
It is same like creating a Table Validated value with a little change in WHERE CLAUSE
See: How to create Table Validated Value set
Lets create a value set.
Press "Edit Information"
WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
AND PERSON_ID = :$PROFILES$.PER_PERSON_ID ( Automatically passed)
After i attached the value set to a field, Here is the result.
Value Sets in Oracle Apps
We can use these values to limit the results.
Let me show you an example...its an easy one.
I will show employee date of birth in a form filed based on its Person id loaded in $PROFILES$.Value
It is same like creating a Table Validated value with a little change in WHERE CLAUSE
See: How to create Table Validated Value set
Lets create a value set.
Press "Edit Information"
WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
AND PERSON_ID = :$PROFILES$.PER_PERSON_ID ( Automatically passed)
After i attached the value set to a field, Here is the result.
Value Sets in Oracle Apps
No comments:
Post a Comment