DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on WIP_PARAMETERS

Line 452: from wip_parameters

448:
449: /* Bug 4712535 -- need to check for include component yield flag even for lot based items */
450: select nvl(include_component_yield,1)
451: into l_include_yield
452: from wip_parameters
453: where organization_id = p_orgID;
454:
455:
456: if (l_reqRec.basisType = WIP_CONSTANTS.LOT_BASED_MTL) then

Line 523: from wip_parameters

519:
520: /* ER 4369064: Component quantity will depend on yield factor, if the parameter is set */
521: /*select include_component_yield
522: into l_include_yield
523: from wip_parameters
524: where organization_id = p_orgID; -- moved above */
525:
526: if (l_include_yield = 1) then
527: l_compQty := round(l_reqRec.qtyPerAssy * p_assyQty/NVL(l_reqRec.componentYieldFactor,1),

Line 2767: FROM wip_parameters

2763: );
2764:
2765: SELECT backflush_lot_entry_type
2766: INTO l_lot_entry_type
2767: FROM wip_parameters
2768: WHERE organization_id = p_orgID;
2769:
2770: IF(l_bf_count = 0) THEN
2771: -- There is no backflush components required for this transaction