DBA Data[Home] [Help]

APPS.PO_SUPPLY dependencies on MTL_SYSTEM_ITEMS

Line 1802: l_uom mtl_system_items.primary_unit_of_measure%TYPE;

1798: /* ----------------------------------------------------------------------- */
1799:
1800: FUNCTION maintain_mtl_supply RETURN BOOLEAN IS
1801:
1802: l_uom mtl_system_items.primary_unit_of_measure%TYPE;
1803: l_lead_time mtl_system_items.postprocessing_lead_time%TYPE;
1804: l_pri_qty mtl_supply.to_org_primary_quantity%TYPE;
1805:
1806:

Line 1803: l_lead_time mtl_system_items.postprocessing_lead_time%TYPE;

1799:
1800: FUNCTION maintain_mtl_supply RETURN BOOLEAN IS
1801:
1802: l_uom mtl_system_items.primary_unit_of_measure%TYPE;
1803: l_lead_time mtl_system_items.postprocessing_lead_time%TYPE;
1804: l_pri_qty mtl_supply.to_org_primary_quantity%TYPE;
1805:
1806:
1807: -- : Brought in from Pro*C to cursor sup2:

Line 1850: FROM mtl_system_items

1846: CURSOR uom_itemid(item_id NUMBER, to_org NUMBER)
1847: IS
1848: SELECT primary_unit_of_measure
1849: , postprocessing_lead_time
1850: FROM mtl_system_items
1851: WHERE inventory_item_id = item_id
1852: AND organization_id = to_org;
1853:
1854: d_module VARCHAR2(70) := 'po.plsql.PO_SUPPLY.maintain_mtl_supply';