[Home] [Help]
279:
280: if (l_lot_entry_type = 0 ) then -- Check only once
281: SELECT backflush_lot_entry_type
282: INTO l_lot_entry_type
283: FROM wip_parameters
284: WHERE organization_id = flow_rec.organization_id ;
285: end if ;
286:
287: IF ((l_bf_count <> 0) and (l_lot_ser_count <> 0) and
2030: when others then
2031: l_cfmRouting := -2;
2032: end;
2033:
2034: -- ER 4369064: Get the 'Include yield' setting from WIP Parameters
2035: if (p_txnFlag) then
2036: select nvl(include_component_yield,1)
2037: into l_includeYield
2038: from wip_parameters
2034: -- ER 4369064: Get the 'Include yield' setting from WIP Parameters
2035: if (p_txnFlag) then
2036: select nvl(include_component_yield,1)
2037: into l_includeYield
2038: from wip_parameters
2039: where organization_id = p_orgID;
2040: end if;
2041:
2042: l_numOfComp := x_compTbl.count;
2042: l_numOfComp := x_compTbl.count;
2043: while ( l_count <= l_numOfComp ) loop
2044:
2045: -- ER 4369064: For work orderless txn, we have to include yield factor
2046: -- if Include Yield in WIP Parameters is checked.
2047: -- Rounding this to 5 decimals since this will go into MTI
2048: /* Bug fix 4728358: Number of rounding decimal places should be obtained from WIP_CONSTANTS.
2049: In particular we want 6 places instead of 5. */
2050: if (p_txnFlag AND l_includeYield = 1) then
2181: l_msiLocatorID,
2182: l_wpSubinv,
2183: l_wpLocatorID
2184: from mtl_system_items msi,
2185: wip_parameters wp
2186: where msi.organization_id = wp.organization_id
2187: and msi.organization_id = p_orgID
2188: and msi.inventory_item_id = x_compTbl(l_count).inventory_item_id;
2189: /* Bugfix 4556685: Locator ID and supply subinventory at parameter and item levels