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 976: if (l_comp_table(l_comp_count).basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then

972:
973: -- Added for Lot Based Material Support
974: -- For item basis type, the usage is the component cumulative usage * flow schedule open qty
975: -- For lot basis type, the usage is the qty per assembly for that component.
976: if (l_comp_table(l_comp_count).basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then
977: l_usage:=l_comp_table(l_comp_count).usage*l_open_qty;
978: else
979: l_usage:=l_comp_table(l_comp_count).qty_per_lot;
980: end if;