[Home] [Help]
14: -- Boolean FALSE implies : No, not eligible to calculate FB
15: -- OUT parameters -
16: -- p_inventory_item_rec :
17: -- A new record type structure Inventory_Item_Rec_Type is defined.
18: -- In get_fulfillment_eligible , we will query mtl_system_items to fetch property of a item,
19: -- we use thi swuery to fetch other required parameters like primary uom of item (to be used later in derive_fulfillment_base API).
20: ---------------------------------------------------------------------
21:
22: Function get_fulfillment_eligible
70: p_inventory_item_rec.tracking_quantity_ind ,
71: p_inventory_item_rec.reservable_type ,
72: p_inventory_item_rec.primary_uom_class,
73: p_inventory_item_rec.secondary_uom_class
74: FROM mtl_system_items msi,
75: MTL_UNITS_OF_MEASURE muomt1,
76: MTL_UNITS_OF_MEASURE muomt2
77: WHERE msi.primary_uom_code = muomt1.uom_code
78: AND msi.secondary_uom_code = muomt2.uom_code(+)
235: END IF;
236:
237: SELECT 1
238: INTO l_validate_combinition
239: FROM mtl_system_items_b msi,
240: org_organization_definitions org
241: WHERE msi.inventory_item_id= p_line_rec.Inventory_Item_Id
242: AND org.organization_id=msi.organization_id
243: AND sysdate<=nvl(org.disable_date,sysdate)