[Home] [Help]
310:
311: if (l_lot_entry_type = 0 ) then -- Check only once
312: SELECT backflush_lot_entry_type
313: INTO l_lot_entry_type
314: FROM wip_parameters
315: WHERE organization_id = flow_rec.organization_id ;
316: end if ;
317:
318: IF ((l_bf_count <> 0) and (l_lot_ser_count <> 0) and
2063: when others then
2064: l_cfmRouting := -2;
2065: end;
2066:
2067: -- ER 4369064: Get the 'Include yield' setting from WIP Parameters
2068: if (p_txnFlag) then
2069: select nvl(include_component_yield,1)
2070: into l_includeYield
2071: from wip_parameters
2067: -- ER 4369064: Get the 'Include yield' setting from WIP Parameters
2068: if (p_txnFlag) then
2069: select nvl(include_component_yield,1)
2070: into l_includeYield
2071: from wip_parameters
2072: where organization_id = p_orgID;
2073: end if;
2074:
2075: l_numOfComp := x_compTbl.count;
2075: l_numOfComp := x_compTbl.count;
2076: while ( l_count <= l_numOfComp ) loop
2077:
2078: -- ER 4369064: For work orderless txn, we have to include yield factor
2079: -- if Include Yield in WIP Parameters is checked.
2080: -- Rounding this to 5 decimals since this will go into MTI
2081: /* Bug fix 4728358: Number of rounding decimal places should be obtained from WIP_CONSTANTS.
2082: In particular we want 6 places instead of 5. */
2083: if (p_txnFlag AND l_includeYield = 1) then
2220: l_msiLocatorID,
2221: l_wpSubinv,
2222: l_wpLocatorID
2223: from mtl_system_items msi,
2224: wip_parameters wp
2225: where msi.organization_id = wp.organization_id
2226: and msi.organization_id = p_orgID
2227: and msi.inventory_item_id = x_compTbl(l_count).inventory_item_id;
2228: /* Bugfix 4556685: Locator ID and supply subinventory at parameter and item levels