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