Announcement

Collapse
No announcement yet.

How to find No.of LEGS for a shipment

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

  • How to find No.of LEGS for a shipment

    Hi ,

    I have got to requirement to build a report which includes total no.of legs for a shipment please guide me where can i get a link for this

    Is it total number of shipments build is total number of legs or any other way to get this done


    Thanks
    Sujith
    Regards,
    Sujith

  • #2
    Re: How to find No.of LEGS for a shipment

    Hi Sujith,

    Refer to the Itinerary for that Shipment and you will find the number of legs.

    Cheers!
    Andres.

    Comment


    • #3
      Re: How to find No.of LEGS for a shipment

      Hi Andres,

      Thanks for your response,

      I need that in creating a report so I am looking for a table which contains shipment and itinerary details

      Thanks
      Sujith
      Regards,
      Sujith

      Comment


      • #4
        Re: How to find No.of LEGS for a shipment

        Hi Sujith,

        Join the table of SHIPMENT and ITINERARY_DETAILS by using joint column as 'ITINERARY_GID'. It is available in both tables. From there you can take the number of legs.
        Best Regards,
        Sangamesh Bidari
        Xchanging a CSC Company

        Oracle Certified OTM 6 Implementation Specialist

        Comment


        • #5
          Re: How to find No.of LEGS for a shipment

          Hi Sangamesh,

          Thanks I got it
          Regards,
          Sujith

          Comment

          Working...
          X