EBS Customizations (MOSC)

MOSC Banner

Select statement in form personalization

edited Nov 25, 2017 4:00AM in EBS Customizations (MOSC) 2 commentsAnswered

Hello experts

I have a requirement where i need to pull a single row value from a select statement . I developed one personalization, but couldn't able to run my select statment.

Evert time it is giving null, because i may not following proper syntax.

Action tab of form personalization:

Property Name : value

=(select distinct comments

from apps.ap_invoice_lines_all aila, apps.ap_invoices_all aia, apps.po_headers_all pha

where  aia.invoice_id = aila.invoice_id

and      aila.po_header_id =  :LINE_SUM_FOLDER.PO_HEADER_ID

and      pha.po_header_id = aila.po_header_id

)

Can you suggest me the correct syntax , so that my query starts giving rows.

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