BI Publisher (MOSC)

MOSC Banner

XML generating empty row

edited Jun 10, 2011 6:44AM in BI Publisher (MOSC) 3 commentsAnswered
 Hello all,

When I run the SQL, it produces one row.

SELECT

  to_char(to_date(max(trx.trx_date), 'DD-MON-RRRR'), 'YYYY/MM/DD') ar_etd
     , fnd_date.canonical_to_date(wsh.attribute7) etd
    , fnd_date.canonical_to_date(wsh.attribute8) eta
    , wsh.attribute9 container
    , wsh.attribute2 vessel
     , oolv.attribute10 meat_number
     , oolv.header_id

  FROM oe_order_lines_v oolv
     , oe_ra_cust_trx_hdr_v trx
   , wsh_new_deliveries wsh
  , wsh_delivery_assignments wda
    , wsh_delivery_details wdd

WHERE oolv.order_number = trx.order_number (+)
AND oolv.line_number = (select min(line_number)
                       from oe_order_lines_v ov

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