Query for shipping method in oracle apps

Hi friends, We are going to discuss about the the sql query for shipping method in oracle apps. We will share the detail sql query to extract the shipping method details in oracle apps. Using this sql query , we can find out the shipping method and carriers created for sales order shipments in oracle apps. This is one of the important sql query about shipments which helps to find out the shipping method related informations in oracle apps. We will also share some of the important tables too which helps to store the hipping method details in oracle apps. In Oracle apps, shipping method details stores in the look up tables with lookup code is 'SHIP_METHOD'. Please find below the complete detail about Query for shipping method in oracle apps.

Query for shipping method in oracle apps

Important tables used by Query for shipping method in oracle apps

1.fnd_lookup_values_vl

2.hz_parties

3.wsh_carrier_services

4.wsh_org_carrier_services

Detail SQL Query for shipping method in oracle apps

Here below is the detail sql query which helps to extract the complete shipping method details in oracle apps.

select fl.meaning "Ship Method Code',

wsh.SHIP_METHOD_CODE,

fl.LOOKUP_TYPE,

wsh.ship_method_meaning meaning

       from  fnd_lookup_values_vl fl,

       HZ_PARTIES HP, 

       wsh_carrier_services wsh,

       wsh_org_carrier_services wsh_org

where  wsh_org.organization_id=:inv_org_id

  and  wsh_org.carrier_service_id = wsh.carrier_service_id

  and    fl.enabled_flag='Y'

  and    fl.LOOKUP_TYPE = 'SHIP_METHOD'

  and    WSH_ORG.ENABLED_FLAG = 'Y'

  and    fl.LOOKUP_CODE =  wsh.SHIP_METHOD_CODE

  and    wsh.carrier_id = HP.party_id

  and    fl.VIEW_APPLICATION_ID = 3

  and    HP.STATUS= 'A'

  and    sysdate between fl.start_date_active and nvl(fl.end_date_active,sysdate)

Query for shipping method in oracle apps