DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 79: FROM mtl_system_items_b items

75: p_inventory_item_id IS NOT NULL THEN
76: BEGIN
77: SELECT primary_uom_code
78: INTO l_uom
79: FROM mtl_system_items_b items
80: WHERE items.inventory_item_id = p_inventory_item_id
81: AND items.organization_id = l_organization_id
82: AND ROWNUM = 1;
83:

Line 92: FROM mtl_system_items_b items

88: IF (l_uom IS NULL) AND
89: (l_organization_id <> l_master_organization_id) THEN
90: SELECT primary_uom_code
91: INTO l_uom
92: FROM mtl_system_items_b items
93: WHERE items.inventory_item_id = p_inventory_item_id
94: AND items.organization_id = l_master_organization_id;
95: END IF;
96: