Technology Stack - EBS (MOSC)

MOSC Banner

create LOV from more than 1 table

edited Aug 20, 2021 10:50AM in Technology Stack - EBS (MOSC) 8 commentsAnswered
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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center