AR Invoice Transaction DFF Setup to for user selection of Project and Task Number
I have setup the AR Invoice Transaction descriptive flexfield with 2 segments:
1) Project Number. For this I defined a Value Set with Table validation so the user can pick up the Project Number at transaction level entry.
2) Task Number: For this I defined a Value Set with Table validation so the user can pick up the Task Number at transaction level entry. For this I choose:
Application: Projects
Table: PA_TASKS
Table Columns: TASK_NUMBER
I have an issue with the definition above because I want the list for Task Number segment to be display only with the Task Numbers LOV for the Project selected in segment 1 (Project Number) and with my definition the lov included all the tasks numbers.