DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on INV_CONVERT

Line 1106: --Bug#14083389: Check if the value returned by inv_Convert is -99999, only then convert it. If the value returned is -99999, proper UOM conversion has not been defined

1102: l_primary_qty NUMBER;
1103: l_move_qty NUMBER;
1104:
1105: BEGIN
1106: --Bug#14083389: Check if the value returned by inv_Convert is -99999, only then convert it. If the value returned is -99999, proper UOM conversion has not been defined
1107: /* Bug#16239604(FP of bug#9276689): Converting the actual quantity instead of 1 quantity */
1108: select decode (msi.outside_operation_uom_type,
1109: 'ASSEMBLY', inv_convert.inv_um_convert(
1110: p_item_id, -- item_id

Line 1109: 'ASSEMBLY', inv_convert.inv_um_convert(

1105: BEGIN
1106: --Bug#14083389: Check if the value returned by inv_Convert is -99999, only then convert it. If the value returned is -99999, proper UOM conversion has not been defined
1107: /* Bug#16239604(FP of bug#9276689): Converting the actual quantity instead of 1 quantity */
1108: select decode (msi.outside_operation_uom_type,
1109: 'ASSEMBLY', inv_convert.inv_um_convert(
1110: p_item_id, -- item_id
1111: NULL, -- precision
1112: p_quantity, -- from_quantity
1113: NULL, -- from_unit

Line 1117: inv_convert.inv_um_convert(

1113: NULL, -- from_unit
1114: NULL, -- to_unit
1115: p_uom_code, -- from_name
1116: p_primary_uom_code), -- to_name
1117: inv_convert.inv_um_convert(
1118: p_item_id, -- item_id
1119: NULL, -- precision
1120: decode (nvl(p_usage_rate_or_amount, 0) ,
1121: 0, 0,

Line 1929: /* Fixed bug 9877798. Add inv_convert.inv_um_convert function for uom conversions */

1925: to_number(null) po_release_id,
1926: pd.po_distribution_id po_distribution_id,
1927: to_number(null) req_header_id,
1928: to_number(null) req_line_id,
1929: /* Fixed bug 9877798. Add inv_convert.inv_um_convert function for uom conversions */
1930: /* Bug#16239604(FP of bug#9276689): Converting the actual quantity instead of 1 quantity */
1931: (pd.quantity_ordered +(
1932: inv_convert.inv_um_convert (msi.inventory_item_id, -- item_id
1933: NULL, -- precision

Line 1932: inv_convert.inv_um_convert (msi.inventory_item_id, -- item_id

1928: to_number(null) req_line_id,
1929: /* Fixed bug 9877798. Add inv_convert.inv_um_convert function for uom conversions */
1930: /* Bug#16239604(FP of bug#9276689): Converting the actual quantity instead of 1 quantity */
1931: (pd.quantity_ordered +(
1932: inv_convert.inv_um_convert (msi.inventory_item_id, -- item_id
1933: NULL, -- precision
1934: DECODE(msi.outside_operation_uom_type,
1935: 'RESOURCE', ROUND(wor.usage_rate_or_amount * p_changed_qty,
1936: WIP_CONSTANTS.INV_MAX_PRECISION),

Line 2006: /* Fixed bug 9877798. Add inv_convert.inv_um_convert function for uom conversions */

2002: pr.po_release_id po_release_id,
2003: pd.po_distribution_id po_distribution_id,
2004: to_number(null) req_header_id,
2005: to_number(null) req_line_id,
2006: /* Fixed bug 9877798. Add inv_convert.inv_um_convert function for uom conversions */
2007: (pd.quantity_ordered +(
2008: inv_convert.inv_um_convert (msi.inventory_item_id, -- item_id
2009: NULL, -- precision
2010: DECODE(msi.outside_operation_uom_type,

Line 2008: inv_convert.inv_um_convert (msi.inventory_item_id, -- item_id

2004: to_number(null) req_header_id,
2005: to_number(null) req_line_id,
2006: /* Fixed bug 9877798. Add inv_convert.inv_um_convert function for uom conversions */
2007: (pd.quantity_ordered +(
2008: inv_convert.inv_um_convert (msi.inventory_item_id, -- item_id
2009: NULL, -- precision
2010: DECODE(msi.outside_operation_uom_type,
2011: 'RESOURCE', ROUND(wor.usage_rate_or_amount * p_changed_qty,
2012: WIP_CONSTANTS.INV_MAX_PRECISION),