DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WSH_CARRIERS

Line 5796: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,

5792: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
5793:
5794: SELECT substr(freight_code,1,25)
5795: INTO p_x_interface_line_rec.SHIP_VIA
5796: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,
5797: wsh_org_carrier_services wsh_org
5798: WHERE wsh_org.organization_id = p_line_rec.ship_from_org_id
5799: AND wsh.carrier_service_id = wsh_org.carrier_service_id
5800: AND wsh_ca.carrier_id = wsh.carrier_id

Line 5896: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,

5892: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
5893:
5894: SELECT substr(freight_code,1,25)
5895: INTO p_x_interface_line_rec.SHIP_VIA
5896: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,
5897: wsh_org_carrier_services wsh_org
5898: WHERE wsh_org.organization_id = p_line_rec.ship_from_org_id
5899: AND wsh.carrier_service_id = wsh_org.carrier_service_id
5900: AND wsh_ca.carrier_id = wsh.carrier_id

Line 5941: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,

5937: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
5938:
5939: SELECT substr(freight_code,1,25)
5940: INTO p_x_interface_line_rec.SHIP_VIA
5941: FROM wsh_carriers wsh_ca,wsh_carrier_services wsh,
5942: wsh_org_carrier_services wsh_org
5943: WHERE wsh_org.organization_id =
5944: p_line_rec.ship_from_org_id
5945: AND wsh.carrier_service_id =