DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on WIP_PARAMETERS

Line 444: from wip_parameters

440:
441: /* Bug 4712535 -- need to check for include component yield flag even for lot based items */
442: select nvl(include_component_yield,1)
443: into l_include_yield
444: from wip_parameters
445: where organization_id = p_orgID;
446:
447:
448: if (l_reqRec.basisType = WIP_CONSTANTS.LOT_BASED_MTL) then

Line 515: from wip_parameters

511:
512: /* ER 4369064: Component quantity will depend on yield factor, if the parameter is set */
513: /*select include_component_yield
514: into l_include_yield
515: from wip_parameters
516: where organization_id = p_orgID; -- moved above */
517:
518: if (l_include_yield = 1) then
519: l_compQty := round(l_reqRec.qtyPerAssy * p_assyQty/NVL(l_reqRec.componentYieldFactor,1),

Line 2658: FROM wip_parameters

2654:
2655:
2656: SELECT backflush_lot_entry_type
2657: INTO l_lot_entry_type
2658: FROM wip_parameters
2659: WHERE organization_id = p_orgID;
2660:
2661: IF(l_bf_count = 0) THEN
2662: -- There is no backflush components required for this transaction