APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on WIP_CONSTANTS

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

245: DECODE(sys.wip_supply_type, NULL,
246: 1, sys.wip_supply_type),
247: comp.wip_supply_type)) wip_supply_type,
248: MIN(comp.component_quantity) component_quantity,
249: MIN(nvl(comp.basis_type,WIP_CONSTANTS.ITEM_BASED_MTL)) basis_type
250: from mtl_system_items sys,
251: bom_inventory_components comp,
252: bom_explosions expl,
253: bom_bill_of_materials bbm

Line 669: if (var_comp_tbl(var_current_row).basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then

665:
666: -- Added for Lot Based Material Support
667: -- For item basis type, the usage is the subassembly cumulative usage * flow schedule qty
668: -- For lot basis type, the usage is the qty per assembly for that subassembly.
669: if (var_comp_tbl(var_current_row).basis_type = WIP_CONSTANTS.ITEM_BASED_MTL) then
670: l_flow_schedule_rec.planned_quantity := var_comp_tbl(var_current_row).usage * var_qty;
671: else
672: l_flow_schedule_rec.planned_quantity := var_comp_tbl(var_current_row).qty_per_lot;
673: end if;