DBA Data[Home] [Help]

APPS.CTO_WIP_WRAPPER dependencies on INV_CONVERT

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

582: '(select cal2.prior_seq_num '||
583: '- nvl(:p_offset_days, 0) '||
584: '- (ceil(nvl(msi.fixed_lead_time,0) '||
585: '+ nvl(msi.variable_lead_time,0) '||
586: '* (INV_CONVERT.inv_um_convert( '||
587: 'oel.inventory_item_id, '||
588: '5, '||
589: -- bugfix 2204376: pass precision of 5
590: 'oel.ordered_quantity, '||

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

1504: oel.inventory_item_id,
1505: oel.order_quantity_uom,
1506: --oel.ordered_quantity,
1507: oel.source_document_type_id, -- bugfix 1799874: to check if it is an internal SO or regular
1508: INV_CONVERT.inv_um_convert -- bugfix 1661094: added conversion logic
1509: (oel.inventory_item_id,
1510: 5, -- bugfix 2204376: pass precision of 5
1511: wei.start_quantity,
1512: msi.primary_uom_code,

Line 1892: select nvl(sum(INV_CONVERT.inv_um_convert

1888: -- bugfix 2074290: convert the reservation_quantity into primary UOM.
1889: -- Reservation_Quantity will not be in primary UOM in case of manual reservation.
1890: -- If the reservations are created by autocreate FAS, it will be in primary uom.
1891:
1892: select nvl(sum(INV_CONVERT.inv_um_convert
1893: (oel.inventory_item_id,
1894: 5, -- bugfix 2204376: pass precision of 5
1895: mr.reservation_quantity,
1896: mr.reservation_uom_code,

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

2032: --
2033: -- Note : Requested_Quantity in WDD is in primary UOM
2034:
2035: select decode( max(shipping_interfaced_flag),
2036: 'N', max(INV_CONVERT.inv_um_convert
2037: (oel.inventory_item_id,
2038: 5, -- bugfix 2204376: pass precision of 5
2039: oel.ordered_quantity,
2040: oel.order_quantity_uom,