APPS.CSD_ESTIMATE_UTILS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 191: FROM mtl_system_items_b

187: WHERE inventory_item_id = p_item_id
188: AND organization_id = Cs_Std.get_item_valdn_orgzn_id
189: AND uom_type =
190: (SELECT allowed_units_lookup_code
191: FROM mtl_system_items_b
192: WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id
193: AND inventory_item_id = p_item_id)
194: AND uom_code = p_uom_code;
195: l_tmp_count NUMBER;

Line 978: FROM mtl_system_items_b

974:
975: -- Cursor to get the billable_flag
976: CURSOR CUR_BILLING_TYPE(p_item_id NUMBER) IS
977: SELECT material_billable_flag
978: FROM mtl_system_items_b
979: WHERE inventory_item_id = p_item_id
980: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
981:
982: -- Cursor to get the item cost for a material item

Line 1261: FROM mtl_system_items_b

1257: DECODE(serial_number_control_Code, 1, 'N', '6', 'N', 'Y') serial_control,
1258: comms_nl_trackable_Flag ib_control,
1259: primary_uom_code,
1260: material_billable_flag
1261: FROM mtl_system_items_b
1262: WHERE inventory_item_id = p_item_id
1263: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
1264:
1265: