DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 81: FROM mtl_system_items_b items

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

Line 94: FROM mtl_system_items_b items

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