DBA Data[Home] [Help]

APPS.CTO_WIP_WRAPPER dependencies on INV_CONVERT

Line 558: '* (INV_CONVERT.inv_um_convert( '||

554: '(select cal2.prior_seq_num '||
555: '- nvl(:p_offset_days, 0) '||
556: '- (ceil(nvl(msi.fixed_lead_time,0) '||
557: '+ nvl(msi.variable_lead_time,0) '||
558: '* (INV_CONVERT.inv_um_convert( '||
559: 'oel.inventory_item_id, '||
560: '5, '||
561: -- bugfix 2204376: pass precision of 5
562: 'oel.ordered_quantity, '||

Line 1364: INV_CONVERT.inv_um_convert -- bugfix 1661094: added conversion logic

1360: oel.inventory_item_id,
1361: oel.order_quantity_uom,
1362: --oel.ordered_quantity,
1363: oel.source_document_type_id, -- bugfix 1799874: to check if it is an internal SO or regular
1364: INV_CONVERT.inv_um_convert -- bugfix 1661094: added conversion logic
1365: (oel.inventory_item_id,
1366: 5, -- bugfix 2204376: pass precision of 5
1367: wei.start_quantity,
1368: msi.primary_uom_code,

Line 1746: select nvl(sum(INV_CONVERT.inv_um_convert

1742: -- bugfix 2074290: convert the reservation_quantity into primary UOM.
1743: -- Reservation_Quantity will not be in primary UOM in case of manual reservation.
1744: -- If the reservations are created by autocreate FAS, it will be in primary uom.
1745:
1746: select nvl(sum(INV_CONVERT.inv_um_convert
1747: (oel.inventory_item_id,
1748: 5, -- bugfix 2204376: pass precision of 5
1749: mr.reservation_quantity,
1750: mr.reservation_uom_code,

Line 1888: 'N', max(INV_CONVERT.inv_um_convert

1884: --
1885: -- Note : Requested_Quantity in WDD is in primary UOM
1886:
1887: select decode( max(shipping_interfaced_flag),
1888: 'N', max(INV_CONVERT.inv_um_convert
1889: (oel.inventory_item_id,
1890: 5, -- bugfix 2204376: pass precision of 5
1891: oel.ordered_quantity,
1892: oel.order_quantity_uom,