Based on the looped data defined in the exhibit, identify one correct option that lists all the
possible lookup codes that would be displayed when the application passes “US” as a reference
determination code.
A.
US_CODE1
US_CODE2
COM_CODE1
COM_CODE2
B.
US_CODE1
US_CODE2
US_CODE3
C.
US_CODE1
US_CODE2
US_CODE3
COM_CODE1
COM_CODE2
DEF_CODE1
DEF_CODE2
D.
US_CODE1
US_CODE2
US_CODE3
DEF_CODE1
DEF_CODE2
E.
COM_CODE1
COM_CODE2
COM_CODE3
Explanation:
Lookup codes are identified in an application by the following keys:
* A lookup view, which defines a distinct set of lookup types.
Each lookup view is accessed through its own view, and may have different
attributes or different validation, almost as if it were a separate table.
* A lookup type, which is a string identifier of a type that groups certain codes
together; for example, COLORS.
Within each lookup type, multiple lookup codes can be defined.
Note: Lookups in applications are used to represent a set of codes and their translated meanings.
For example, a product team might store the values ‘Y’ and ‘N’ in a column in a table, but when
displaying those values they would want to display “Yes” or “No” (or their translated equivalents)
instead. Each set of related codes is identified as a lookup type.
Reference; Oracle Fusion Applications, Developer’s Guide, Overview of Lookups