DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on MTL_SYSTEM_ITEMS_B

Line 60: FROM mtl_system_items_b

56: -- Getting the Primary UOM of the item
57: BEGIN
58: SELECT primary_uom_code
59: INTO l_primary_uom
60: FROM mtl_system_items_b
61: WHERE inventory_item_id = p_inventory_item_id
62: AND organization_id = NVL(p_ship_from_org_id,
63: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_org_id)); --4759251
64: EXCEPTION

Line 1004: FROM mtl_system_items_b

1000: -- Getting the Primary UOM of the item
1001: BEGIN
1002: SELECT primary_uom_code
1003: INTO l_primary_uom
1004: FROM mtl_system_items_b
1005: WHERE inventory_item_id = p_inventory_item_id
1006: AND organization_id = NVL(p_ship_from_org_id,
1007: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_rsv_tbl(1).org_id)); --4759251
1008: EXCEPTION