DBA Data[Home] [Help]

APPS.WIP_REQUIREMENT_DEFAULT dependencies on WIP_CONSTANTS

Line 60: if( p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL) then

56:
57: x_state_num := x_state_num + 1;
58:
59: /* begin LBM Project */
60: if( p_basis_type = WIP_CONSTANTS.LOT_BASED_MTL) then
61: x_required_quantity := round(p_quantity_per_assembly, 6);
62: x_MPS_required_quantity := x_required_quantity;
63: else
64: x_required_quantity :=

Line 132: if (X_entity_type = wip_constants.eam) then

128: and wdj.wip_entity_id = we.wip_entity_id
129: and wdj.organization_id = we.organization_id ;
130:
131: /* bug#2811687 */
132: if (X_entity_type = wip_constants.eam) then
133: x_wip_supply_type := wip_constants.push;
134: end if;
135:
136: x_state_num := x_state_num + 1;

Line 133: x_wip_supply_type := wip_constants.push;

129: and wdj.organization_id = we.organization_id ;
130:
131: /* bug#2811687 */
132: if (X_entity_type = wip_constants.eam) then
133: x_wip_supply_type := wip_constants.push;
134: end if;
135:
136: x_state_num := x_state_num + 1;
137:

Line 199: round(x_quantity_per_assembly * decode(p_basis_type, wip_constants.lot_based_mtl, 1,

195: mps_required_quantity = nvl(required_quantity,x_mps_required_quantity), /*Bug 4369064 */
196: mps_date_required = nvl(mps_date_required,x_mps_date_required),
197: /* Modified for Bug 10182424*/
198: component_yield_factor = decode (nvl(required_quantity,x_required_quantity),0,1,
199: round(x_quantity_per_assembly * decode(p_basis_type, wip_constants.lot_based_mtl, 1,
200: X_start_quantity) / nvl(required_quantity,x_required_quantity),6))
201:
202: /*Component Yield Enhancement(Bug 4369064)->default component yield factor based on required quantity and qpa */
203: WHERE group_id = p_group_id