create LOV from more than 1 table
Hi,
HOW TO CREATE a LOV BASED ON MORE THAN 1 TABLE IN E business suite form
for example this is my query :
SELECT DISTINCT
x_t_balance.DEFINITION_CODE ,
x_t_balance.NATURAL_ACCOUNT_SEGMENT_VALUE,
x_tb_def.name
FROM XLA_TRIAL_BALANCES x_t_balance,
XLA_TB_DEFINITIONS_TL x_tb_def
WHERE x_t_balance.DEFINITION_CODE = x_tb_def.DEFINITION_CODE
is there is note or document to read
thanks
Tagged:
0