DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on OE_DUAL_UOM_UTIL

Line 2260: OR (Nvl(oe_dual_uom_util.GET_FULFILLMENT_BASE(wdd.source_line_id), 'P') = 'P'

2256: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2257: AND wda.delivery_id = p_delivery_id
2258: AND wdd.container_flag = 'N'
2259: AND (wdd.released_status NOT IN ( 'X', 'Y' )
2260: OR (Nvl(oe_dual_uom_util.GET_FULFILLMENT_BASE(wdd.source_line_id), 'P') = 'P'
2261: AND (wdd.cycle_count_quantity > 0
2262: OR wdd.shipped_quantity < wdd.requested_quantity
2263: )
2264: )

Line 2265: OR (Nvl(oe_dual_uom_util.GET_FULFILLMENT_BASE(wdd.source_line_id), 'P') = 'S'

2261: AND (wdd.cycle_count_quantity > 0
2262: OR wdd.shipped_quantity < wdd.requested_quantity
2263: )
2264: )
2265: OR (Nvl(oe_dual_uom_util.GET_FULFILLMENT_BASE(wdd.source_line_id), 'P') = 'S'
2266: AND (wdd.cycle_count_quantity2 > 0
2267: OR wdd.shipped_quantity2 < wdd.requested_quantity2
2268: )
2269: )