Retail Merchandising System (MOSC)

MOSC Banner

Statuses for saexpgl batch.

edited Nov 11, 2013 5:03PM in Retail Merchandising System (MOSC) 1 commentAnswered ✓
 Hello, 
I have a question regarding audit_status . Batch saexpgl  will send data according to next conditions:


 SELECT   sd.store_day_seq_no,
               el.seq_no,
               sd.store,
               sd.day,
               TO_CHAR(sd.business_date, 'YYYYMMDD'),
               vls.set_of_books_id,
               vls.period_name,
               vls.last_update_id,
               ROWIDTOCHAR(el.rowid)
      FROM     sa_store_day sd, mv_loc_sob vls, sa_export_log el
      WHERE    sd.store_day_seq_no = el.store_day_seq_no
      AND      sd.store = el.store
      AND      sd.store = vls.location
      AND      sd.day = el.day
      AND      sd.store_status = :SASS_C             /* Complete */
      AND      sd.data_status = :SADS_F              /* Fully   */

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