DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WSH_ORG_CARRIER_SERVICES

Line 6042: wsh_org_carrier_services wsh_org

6038:
6039: SELECT substr(freight_code,1,25)
6040: INTO p_x_interface_line_rec.SHIP_VIA
6041: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,
6042: wsh_org_carrier_services wsh_org
6043: WHERE wsh_org.organization_id = p_line_rec.ship_from_org_id
6044: AND wsh.carrier_service_id = wsh_org.carrier_service_id
6045: AND wsh_ca.carrier_id = wsh.carrier_id
6046: AND wsh.ship_method_code = l_ship_method_code

Line 6142: wsh_org_carrier_services wsh_org

6138:
6139: SELECT substr(freight_code,1,25)
6140: INTO p_x_interface_line_rec.SHIP_VIA
6141: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,
6142: wsh_org_carrier_services wsh_org
6143: WHERE wsh_org.organization_id = p_line_rec.ship_from_org_id
6144: AND wsh.carrier_service_id = wsh_org.carrier_service_id
6145: AND wsh_ca.carrier_id = wsh.carrier_id
6146: AND wsh.ship_method_code = l_ship_method_code

Line 6187: wsh_org_carrier_services wsh_org

6183:
6184: SELECT substr(freight_code,1,25)
6185: INTO p_x_interface_line_rec.SHIP_VIA
6186: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,
6187: wsh_org_carrier_services wsh_org
6188: WHERE wsh_org.organization_id =
6189: p_line_rec.ship_from_org_id
6190: AND wsh.carrier_service_id =
6191: wsh_org.carrier_service_id