APPS.FLM_AUTO_REPLENISHMENT dependencies on WIP_CONSTANTS

Line 254: MIN(nvl(comp.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL)) basis_type

250: DECODE(sys.wip_supply_type, NULL,
251: 1, sys.wip_supply_type),
252: comp.wip_supply_type)) wip_supply_type,
253: MIN(comp.component_quantity) component_quantity,
254: MIN(nvl(comp.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL)) basis_type
255: FROM mtl_system_items sys,
256: bom_inventory_components comp,
257: bom_explosions expl,
258: bom_bill_of_materials bbm

Line 907: if (l_comp_table(l_comp_count).basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then

903:
904: -- Added for Lot Based Material Support
905: -- For item basis type, the usage is the component cumulative usage * flow schedule open qty
906: -- For lot basis type, the usage is the qty per assembly for that component.
907: if (l_comp_table(l_comp_count).basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then
908: l_usage:=l_comp_table(l_comp_count).usage*l_open_qty;
909: else
910: l_usage:=l_comp_table(l_comp_count).qty_per_lot;
911: end if;