APPS.PO_SUPPLY dependencies on MTL_SYSTEM_ITEMS

Line 1916: l_uom mtl_system_items.primary_unit_of_measure%TYPE;

1912: /* ----------------------------------------------------------------------- */
1913:
1914: FUNCTION maintain_mtl_supply RETURN BOOLEAN IS
1915:
1916: l_uom mtl_system_items.primary_unit_of_measure%TYPE;
1917: l_lead_time mtl_system_items.postprocessing_lead_time%TYPE;
1918: l_pri_qty mtl_supply.to_org_primary_quantity%TYPE;
1919: l_exclude_from_planning mtl_supply.exclude_from_planning%TYPE; --
1920:

Line 1917: l_lead_time mtl_system_items.postprocessing_lead_time%TYPE;

1913:
1914: FUNCTION maintain_mtl_supply RETURN BOOLEAN IS
1915:
1916: l_uom mtl_system_items.primary_unit_of_measure%TYPE;
1917: l_lead_time mtl_system_items.postprocessing_lead_time%TYPE;
1918: l_pri_qty mtl_supply.to_org_primary_quantity%TYPE;
1919: l_exclude_from_planning mtl_supply.exclude_from_planning%TYPE; --
1920:
1921: -- : Brought in from Pro*C to cursor sup2:

Line 1979: FROM mtl_system_items

1975: CURSOR uom_itemid(item_id NUMBER, to_org NUMBER)
1976: IS
1977: SELECT primary_unit_of_measure
1978: , postprocessing_lead_time
1979: FROM mtl_system_items
1980: WHERE inventory_item_id = item_id
1981: AND organization_id = to_org;
1982:
1983: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.maintain_mtl_supply';