Announcement

Collapse
No announcement yet.

shipment Event Table

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • shipment Event Table

    Hi ,

    I need table name which contains shipment event details I have checked data dictionary but I couldn't find one.

    Thanks,
    Sujith
    Regards,
    Sujith

  • #2
    Re: shipment Event Table

    Hi Sujith,

    Join the table of IE_SHIPMENTSTATUS and SS_STATUS_HISTORY by using I_TRANSACTION_NO column.
    Best Regards,
    Sangamesh Bidari
    Xchanging a CSC Company

    Oracle Certified OTM 6 Implementation Specialist

    Comment


    • #3
      Re: shipment Event Table

      Hi Sujith,

      Plese use the below query for find the shipment event details:

      SELECT s.Shipment_gid,ies.STATUS_CODE_GID,ies.eventdate,
      ies.INSERT_USER,ies.insert_date,IT.I_TRANSMISSION_ NO,ISTP.I_TRANSACTION_NO
      FROM IE_SHIPMENTSTATUS IES, SS_STATUS_HISTORY SS, IE_SS_STOP ISTP,
      shipment s,i_transaction it
      WHERE
      ISTP.I_TRANSACTION_NO= IES.I_TRANSACTION_NO AND
      IES.I_TRANSACTION_NO = SS.I_TRANSACTION_NO AND
      it.I_TRANSACTION_NO = SS.I_TRANSACTION_NO AND
      SS.SHIPMENT_GID = S.SHIPMENT_GID AND
      S.SHIPMENT_GID =''

      Regards
      Raj
      Xchanging.

      Comment


      • #4
        Re: shipment Event Table

        Thanks Sangamesh and Raj

        I have implemented in other way using I_TRANSACTION_NO as I needed Description and event time
        Last edited by mr.msujithkumar; July 25, 2014, 04:57.
        Regards,
        Sujith

        Comment

        Working...
        X