CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Hi all how can i get rcv_shipment_header.comments information

i need to get rcv_shipment_headers.comments information by joining rcv_shipment_headers table with the following tables

gl_je_lines        gjl,

gl_je_headers       gjh,

gl_je_batches       gjb,

gl_ledgers        ledger,

gl_code_combinations   gcc,

gl_je_categories_tl    gjct,

gl_je_sources_tl     gjst,

gl_import_references   gir,

xla_ae_headers      aeh,

xla_ae_lines       ael,

xla_events        xle,

xla_event_classes_tl   xect,

xla_event_types_tl    xet,

xla_transaction_entities ent,

xla_subledgers_tl     xsl,

gl_daily_conversion_types

gdct


kindly suggest join conditions between rcv_shipments_headers and the above tables 

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