DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WSH_CARRIER_SHIP_METHODS

Line 5806: FROM wsh_carrier_ship_methods

5802: AND wsh_org.enabled_flag = 'Y';
5803: ELSE
5804: SELECT substr(freight_code,1,25)
5805: INTO p_x_interface_line_rec.SHIP_VIA
5806: FROM wsh_carrier_ship_methods
5807: WHERE ship_method_code = l_ship_method_code
5808: AND organization_id = p_line_rec.ship_from_org_id;
5809: END IF;
5810: END IF;

Line 5906: FROM wsh_carrier_ship_methods

5902: AND wsh_org.enabled_flag = 'Y';
5903: ELSE
5904: SELECT substr(freight_code,1,25)
5905: INTO p_x_interface_line_rec.SHIP_VIA
5906: FROM wsh_carrier_ship_methods
5907: WHERE ship_method_code = l_ship_method_code
5908: AND organization_id = p_line_rec.ship_from_org_id;
5909: END IF;
5910: END IF;

Line 5953: FROM wsh_carrier_ship_methods

5949: AND wsh_org.enabled_flag = 'Y';
5950: ELSE
5951: SELECT substr(freight_code,1,25)
5952: INTO p_x_interface_line_rec.SHIP_VIA
5953: FROM wsh_carrier_ship_methods
5954: WHERE ship_method_code = l_ship_method_code
5955: AND organization_id = p_line_rec.ship_from_org_id;
5956: END IF;
5957: END IF;