APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on OE_DUAL_UOM_UTIL

Line 1775: AND NVL(oe_dual_uom_util.get_fulfillment_base(wdd.source_line_id), 'P') = 'P';

1771: FROM wms_shipping_transaction_temp wstt
1772: , wsh_delivery_details wdd
1773: WHERE wstt.outermost_lpn_id = p_outermost_lpn_id
1774: AND wstt.delivery_detail_id = wdd.delivery_detail_id
1775: AND NVL(oe_dual_uom_util.get_fulfillment_base(wdd.source_line_id), 'P') = 'P';
1776:
1777: CURSOR nested_children_lpn_cursor IS
1778: SELECT lpn_id
1779: FROM WMS_LICENSE_PLATE_NUMBERS

Line 5626: AND NVL(oe_dual_uom_util.get_fulfillment_base(wdd.source_line_id), 'P') = 'P';

5622: WHERE wstt.organization_id = p_organization_id
5623: AND nvl(wstt.direct_ship_flag,'N') = 'N'
5624: AND wstt.outermost_lpn_id = p_outermost_lpn_id
5625: AND wdd.delivery_detail_id = wstt.delivery_detail_id
5626: AND NVL(oe_dual_uom_util.get_fulfillment_base(wdd.source_line_id), 'P') = 'P';
5627:
5628: l_index NUMBER;
5629: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
5630: l_return_status VARCHAR2(1);

Line 6002: and NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(ool.line_id),'P') = l_fulfillment_base

5998: and wdst.organization_id (+) = wdd.organization_id --Added bug 4128854
5999: and exists (select 1
6000: from oe_order_lines_all ool
6001: where ool.header_id = wdd.source_header_id
6002: and NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(ool.line_id),'P') = l_fulfillment_base
6003: )
6004: order by 2,1;
6005:
6006: END get_order_lov;

Line 6117: AND NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(oel.line_id),'P') = l_fulfillment_base

6113: WHERE wdd_xdock.source_header_id = oel.header_id
6114: AND wdd_xdock.source_line_id = oel.line_id
6115: AND wdd_xdock.released_status = 'S'
6116: AND wdd_xdock.move_order_line_id IS NULL)
6117: AND NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(oel.line_id),'P') = l_fulfillment_base
6118: GROUP BY oel.line_id
6119: , to_char(oel.line_number) ||'.'||to_char(oel.shipment_number) ||
6120: decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
6121: decode(oel.component_number, null, null,decode(oel.option_number, null,'.',null)||

Line 6227: AND NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(oel.line_id),'P') = l_fulfillment_base

6223: WHERE wdd_xdock.source_header_id = oel.header_id
6224: AND wdd_xdock.source_line_id = oel.line_id
6225: AND wdd_xdock.released_status = 'S'
6226: AND wdd_xdock.move_order_line_id IS NULL)
6227: AND NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(oel.line_id),'P') = l_fulfillment_base
6228: GROUP BY oel.line_id
6229: , to_char(oel.line_number) ||'.'||to_char(oel.shipment_number) ||
6230: decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
6231: decode(oel.component_number, null, null,decode(oel.option_number, null,'.',null)||

Line 6333: AND NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(oel.line_id),'P') = l_fulfillment_base

6329: WHERE wdd_xdock.source_header_id = oel.header_id
6330: AND wdd_xdock.source_line_id = oel.line_id
6331: AND wdd_xdock.released_status = 'S'
6332: AND wdd_xdock.move_order_line_id IS NULL)
6333: AND NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(oel.line_id),'P') = l_fulfillment_base
6334: GROUP BY oel.line_id
6335: , to_char(oel.line_number) ||'.'||to_char(oel.shipment_number) ||
6336: decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
6337: decode(oel.component_number, null, null,decode(oel.option_number, null,'.',null)||

Line 6444: AND NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(oel.line_id),'P') = l_fulfillment_base

6440: WHERE wdd_xdock.source_header_id = oel.header_id
6441: AND wdd_xdock.source_line_id = oel.line_id
6442: AND wdd_xdock.released_status = 'S'
6443: AND wdd_xdock.move_order_line_id IS NULL)
6444: AND NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(oel.line_id),'P') = l_fulfillment_base
6445: GROUP BY oel.line_id
6446: , to_char(oel.line_number) ||'.'||to_char(oel.shipment_number) ||
6447: decode(oel.option_number,NULL,NULL,'.'||to_char(oel.option_number))||
6448: decode(oel.component_number, null, null,decode(oel.option_number, null,'.',null)||