DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on WSH_CARRIER_SHIP_METHODS

Line 6051: FROM wsh_carrier_ship_methods

6047: AND wsh_org.enabled_flag = 'Y';
6048: ELSE
6049: SELECT substr(freight_code,1,25)
6050: INTO p_x_interface_line_rec.SHIP_VIA
6051: FROM wsh_carrier_ship_methods
6052: WHERE ship_method_code = l_ship_method_code
6053: AND organization_id = p_line_rec.ship_from_org_id;
6054: END IF;
6055: END IF;

Line 6151: FROM wsh_carrier_ship_methods

6147: AND wsh_org.enabled_flag = 'Y';
6148: ELSE
6149: SELECT substr(freight_code,1,25)
6150: INTO p_x_interface_line_rec.SHIP_VIA
6151: FROM wsh_carrier_ship_methods
6152: WHERE ship_method_code = l_ship_method_code
6153: AND organization_id = p_line_rec.ship_from_org_id;
6154: END IF;
6155: END IF;

Line 6198: FROM wsh_carrier_ship_methods

6194: AND wsh_org.enabled_flag = 'Y';
6195: ELSE
6196: SELECT substr(freight_code,1,25)
6197: INTO p_x_interface_line_rec.SHIP_VIA
6198: FROM wsh_carrier_ship_methods
6199: WHERE ship_method_code = l_ship_method_code
6200: AND organization_id = p_line_rec.ship_from_org_id;
6201: END IF;
6202: END IF;