eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DUAL_UOM_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 6: ( Inventory_item_id mtl_system_items.Inventory_item_id%TYPE ,

2: /* $Header: OEXUDUMS.pls 120.0.12020000.2 2013/01/11 01:12:20 gabhatia noship $ */
3:
4:
5: TYPE Inventory_Item_Rec_Type IS RECORD
6: ( Inventory_item_id mtl_system_items.Inventory_item_id%TYPE ,
7: Org_id mtl_system_items.organization_id%TYPE ,
8: primary_uom_code mtl_system_items.primary_uom_code%TYPE ,
9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,
10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,

Line 7: Org_id mtl_system_items.organization_id%TYPE ,

3:
4:
5: TYPE Inventory_Item_Rec_Type IS RECORD
6: ( Inventory_item_id mtl_system_items.Inventory_item_id%TYPE ,
7: Org_id mtl_system_items.organization_id%TYPE ,
8: primary_uom_code mtl_system_items.primary_uom_code%TYPE ,
9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,
10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,
11: shippable_item_flag mtl_system_items.shippable_item_flag%TYPE ,

Line 8: primary_uom_code mtl_system_items.primary_uom_code%TYPE ,

4:
5: TYPE Inventory_Item_Rec_Type IS RECORD
6: ( Inventory_item_id mtl_system_items.Inventory_item_id%TYPE ,
7: Org_id mtl_system_items.organization_id%TYPE ,
8: primary_uom_code mtl_system_items.primary_uom_code%TYPE ,
9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,
10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,
11: shippable_item_flag mtl_system_items.shippable_item_flag%TYPE ,
12: reservable_type mtl_system_items.reservable_type%TYPE ,

Line 9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,

5: TYPE Inventory_Item_Rec_Type IS RECORD
6: ( Inventory_item_id mtl_system_items.Inventory_item_id%TYPE ,
7: Org_id mtl_system_items.organization_id%TYPE ,
8: primary_uom_code mtl_system_items.primary_uom_code%TYPE ,
9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,
10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,
11: shippable_item_flag mtl_system_items.shippable_item_flag%TYPE ,
12: reservable_type mtl_system_items.reservable_type%TYPE ,
13: tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE ,

Line 10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,

6: ( Inventory_item_id mtl_system_items.Inventory_item_id%TYPE ,
7: Org_id mtl_system_items.organization_id%TYPE ,
8: primary_uom_code mtl_system_items.primary_uom_code%TYPE ,
9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,
10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,
11: shippable_item_flag mtl_system_items.shippable_item_flag%TYPE ,
12: reservable_type mtl_system_items.reservable_type%TYPE ,
13: tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE ,
14: ordered_uom_class mtl_units_of_measure.uom_class%TYPE,

Line 11: shippable_item_flag mtl_system_items.shippable_item_flag%TYPE ,

7: Org_id mtl_system_items.organization_id%TYPE ,
8: primary_uom_code mtl_system_items.primary_uom_code%TYPE ,
9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,
10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,
11: shippable_item_flag mtl_system_items.shippable_item_flag%TYPE ,
12: reservable_type mtl_system_items.reservable_type%TYPE ,
13: tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE ,
14: ordered_uom_class mtl_units_of_measure.uom_class%TYPE,
15: primary_uom_class mtl_units_of_measure.uom_class%TYPE,

Line 12: reservable_type mtl_system_items.reservable_type%TYPE ,

8: primary_uom_code mtl_system_items.primary_uom_code%TYPE ,
9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,
10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,
11: shippable_item_flag mtl_system_items.shippable_item_flag%TYPE ,
12: reservable_type mtl_system_items.reservable_type%TYPE ,
13: tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE ,
14: ordered_uom_class mtl_units_of_measure.uom_class%TYPE,
15: primary_uom_class mtl_units_of_measure.uom_class%TYPE,
16: secondary_uom_class mtl_units_of_measure.uom_class%TYPE,

Line 13: tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE ,

9: secondary_uom_code mtl_system_items.secondary_uom_code%TYPE ,
10: inventory_item_flag mtl_system_items.inventory_item_flag%TYPE ,
11: shippable_item_flag mtl_system_items.shippable_item_flag%TYPE ,
12: reservable_type mtl_system_items.reservable_type%TYPE ,
13: tracking_quantity_ind mtl_system_items.tracking_quantity_ind%TYPE ,
14: ordered_uom_class mtl_units_of_measure.uom_class%TYPE,
15: primary_uom_class mtl_units_of_measure.uom_class%TYPE,
16: secondary_uom_class mtl_units_of_measure.uom_class%TYPE,
17: wms_enabled_flag VARCHAR2(1)

Line 35: -- In get_fulfillment_eligible , we will query mtl_system_items to fetch property of a item,

31: -- Boolean FALSE implies : No, not eligible to calculate FB
32: -- OUT parameters -
33: -- p_inventory_item_rec :
34: -- A new record type structure Inventory_Item_Rec_Type is defined.
35: -- In get_fulfillment_eligible , we will query mtl_system_items to fetch property of a item,
36: -- we use thi swuery to fetch other required parameters like primary uom of item (to be used later in derive_fulfillment_base API).
37: ---------------------------------------------------------------------
38:
39: Function get_fulfillment_eligible