DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on MTL_SYSTEM_ITEMS_B

Line 136: FROM mtl_system_items_b

132: -- Getting the Primary UOM of the item
133: BEGIN
134: SELECT primary_uom_code
135: INTO l_primary_uom
136: FROM mtl_system_items_b
137: WHERE inventory_item_id = p_inventory_item_id
138: AND organization_id = NVL(p_ship_from_org_id,
139: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_org_id)); --4759251
140: EXCEPTION

Line 1049: FROM mtl_system_items_b

1045: -- Getting the Primary UOM of the item
1046: BEGIN
1047: SELECT primary_uom_code
1048: INTO l_primary_uom
1049: FROM mtl_system_items_b
1050: WHERE inventory_item_id = p_inventory_item_id
1051: AND organization_id = NVL(p_ship_from_org_id,
1052: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID',p_rsv_tbl(1).org_id)); --4759251
1053: EXCEPTION